Snowflake: How To Load Files Through Stage From Ms Azure Using Specific Pattern?

I need to load files from MS Azure to Snowflake tables on a weekly basis, and I wonder if I can find a more efficient way of doing it For example, if i want to load the files in th

Solution 1:

Inside the PATTERN-clause you can use Regex-expressions. I think using a Regex-expression for a date range may become quite complex and your solution is the simplest one. Maybe also looping over the files may help in your case.

More infos about the PATTERN-clause: https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#optional-parameters