A user has an application that writes a new file to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?
A user has an application that writes a new file to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?
The most efficient way to get the files into Snowflake is to set up cloud provider notifications on the file location and use Snowpipe with auto-ingest. This approach allows for automated, real-time data ingestion as soon as new files appear in the cloud storage, eliminating the need for manual scheduling or frequent checking for new files. Snowpipe is designed specifically for continuous data ingestion and is optimized for this purpose.
i think D
D. Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.
A can also right, because we can schedule task
Correct
D. Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.
D. Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.
D is not a good answer. When we have cloud provider notification, the AUTO-INGEST for SNOWPIPE has to be FALSE. A is good, due to the fact that it refers to External Stage and, in the "SNOWFLAKE language" when it is about Cloud Storage it is about files on External Stages. Hence, we have to load from External Stages to Table, using COPY INTO. Last idea, is what does the question understand by "with AUTO-INGEST"? AUTO-INGEST=TRUE or AUTO-INGEST=FALSE. I still remain to A.