CODEWITHSUNDEEP
snowflake-cloud-data-platform
Priya Chauhan
Priya Chauhan

Reputation: 485

Best way to schedule a copy command in snowflake

I have data staged in azure blob storage. According to snowflake documentation, I am confused, whether I should use create task feature of snowflake with below sql query :

 copy into table_name from azure_stage_name file format = xyz

Or should I use snowpipe

Upvotes: 2

Views: 1374

Answers (2)

Gokhan Atil
Gokhan Atil

Reputation: 10154

Do you need to trigger data ingestion when a new file arrives? In this case, Snowpipe would be the right choice.

If you want to ingest the files on a fixed frequency such as daily/hourly etc, then a task would be enough.

If this is a one-time data load, then you can directly run the COPY command.

Upvotes: 3

Jeffrey Jacobs
Jeffrey Jacobs

Reputation: 332

Copy INTO is probably easier and more flexible than auto-ingest.

Upvotes: -1

Related Questions