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
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
Latest ARA-C01 Dumps Valid Version with 156 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund