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.