Snowflake
COF-R02 · Question #108
A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?
The correct answer is D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
Data Loading and Unloading
Question
A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?
Options
- ACreate a task that runs a copy into operation from an external stage every 5 minutes
- BCreate a task that puts the files in an internal stage and automate the data loading wizard
- CCreate a task that runs a GET operation to intermittently check for new files
- DSet up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
How the community answered
(59 responses)- A14% (8)
- B3% (2)
- C10% (6)
- D73% (43)
Explanation
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
Topics
#Snowpipe#auto-ingest#cloud notifications#continuous loading
Community Discussion
No community discussion yet for this question.