What will you use?

In this scenarios, files are constantly getting ingested in an external stage, the files are between 1 and 4 MB. You want to load the data immediately into a table without any human intervention.

What will you use?
A . Create a materialize view on the external stage
B. Use Snowpipe rest APIs
C. Use Snowpipe with auto ingest

View Answer

Answer: C

Explanation:

The AUTO_INGEST=true parameter specifies to read event notifications sent from an S3 bucket to an SQS queue when new data is ready to load.With auto-ingest enabled, each pipe receives a generated file list from the S3 event notifications. This is completely automated and is event driven