Question

A data engineering team ingests files into an internal named stage using a custom application that already knows exactly when each new file arrives. They want the lowest-latency continuous loading using Snowpipe but do not want to configure cloud storage event notifications. Which Snowpipe ingestion method should they use?

Accepted Answer

Call the Snowpipe REST API endpoint (insertFiles) from the application to notify Snowflake of the new files

Answer

Configure auto-ingest with a cloud storage event notification and SQS/Event Grid/Pub/Sub integration

Answer

Schedule a task that runs COPY INTO every minute against the internal stage

Answer

Use Snowpipe Streaming with the Snowflake Ingest SDK to write rows directly