SnowPipe REST endpoints: which option correctly identifies the endpoint that provides a POST method to inform Snowflake about files to ingest?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

SnowPipe REST endpoints: which option correctly identifies the endpoint that provides a POST method to inform Snowflake about files to ingest?

Explanation:
Snowpipe REST API uses a POST request to a dedicated endpoint to tell Snowflake which files to ingest. The endpoint you post to for this purpose is named insertFiles. When you send the payload, you provide the file URIs (paths in the stage) and optional metadata, and Snowflake enqueues those files for the specified pipe to ingest. This endpoint is the correct choice because it is specifically designed to notify Snowflake about new files to process. The idea of REST support exists for Snowpipe, so saying there is no REST is incorrect. The terms insertTuples or insertReport don’t correspond to the ingestion trigger: they would imply different actions (like inserting data rows or generating a report) rather than informing Snowflake about files to ingest.

Snowpipe REST API uses a POST request to a dedicated endpoint to tell Snowflake which files to ingest. The endpoint you post to for this purpose is named insertFiles. When you send the payload, you provide the file URIs (paths in the stage) and optional metadata, and Snowflake enqueues those files for the specified pipe to ingest.

This endpoint is the correct choice because it is specifically designed to notify Snowflake about new files to process. The idea of REST support exists for Snowpipe, so saying there is no REST is incorrect. The terms insertTuples or insertReport don’t correspond to the ingestion trigger: they would imply different actions (like inserting data rows or generating a report) rather than informing Snowflake about files to ingest.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy