What would be the MOST efficient way to get the files into Snowflake?

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?
A . Create a task that runs a copy into operation from an external stage every 5 minutes
B . Create a task that puts the files in an internal stage and automate the data loading wizard
C . Create a task that runs a GET operation to intermittently check for new files
D . Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

View Answer

Answer: D

Explanation:

The most efficient way to get files into Snowflake, especially when new files are being written to a cloud storage location at frequent intervals, is to use Snowpipe with auto-ingest. Snowpipe is Snowflake’s continuous data ingestion service that loads data as soon as it becomes available in a cloud storage location. By setting up cloud provider notifications, Snowpipe can be triggered automatically whenever new files are written to the storage location, ensuring that the data is loaded into Snowflake with minimal latency and without the need for manual intervention or scheduling frequent tasks.

Reference: Snowflake Documentation on Snowpipe

SnowPro® Core Certification Study Guide