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?

Question

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

• A
  5% (1)
• B
  15% (3)
• C
  5% (1)
• D
  75% (15)

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.

No community discussion yet for this question.