using pattern while loading csv file from s3 to snowflake

Question

below copy command is not working , please correct me if something wrong.

copy into mytable
from  @mystage
pattern='20.*csv.gz'

here i am trying to load the files which are starts with 20, there are mix of files which are having the name as 2021myfile.csv.gz, myfile202109.csv.gz, above command is not loading any files though there are files which starts with 20. if i use pattern as pattern='.*20.*csv.gz' it is taking all the files which is wrong, i need to load only the files that are starts with 20.

Michael Golos · Accepted Answer · 2021-10-04 16:22:40Z

1

This is because the pattern clause is a Regex expression. Try this:

copy into mytable from @mystage pattern = '[20]*.*csv.gz'

Reference: Loading Using Pattern Matching

edited Oct 4, 2021 at 16:22

answered Oct 4, 2021 at 16:16

Michael Golos

2,1191 gold badge9 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Stefano Messina Over a year ago

I'm having a similar problem, cannot match upper cases, do you have a solution for that?

Shifat Sarwar · Accepted Answer · 2024-10-10 21:06:26Z

0

2021myfile.csv.gz, myfile202109.csv.gz both has .20 means anything could be before 20 or not so it will load both the files. if it is inside a folder than . is necessary try something like .*/20.*csv.gz.

answered Oct 10, 2024 at 21:06

Shifat Sarwar

1

Collectives™ on Stack Overflow

using pattern while loading csv file from s3 to snowflake

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related