COF-C02 · Question #265
How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?
The correct answer is D. Use the COPY command. The COPY INTO <table> command is Snowflake's recommended and most efficient method for bulk loading data from files already staged in cloud storage (Amazon S3, Azure Blob Storage, or Google Cloud Storage). It loads data in parallel using the virtual warehouse's compute and…
Question
How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?
Options
- AUse Snowpipe.
- BUse the INSERT command.
- CUse an external table.
- DUse the COPY command.
How the community answered
(14 responses)- A7% (1)
- D93% (13)
Explanation
The COPY INTO <table> command is Snowflake's recommended and most efficient method for bulk loading data from files already staged in cloud storage (Amazon S3, Azure Blob Storage, or Google Cloud Storage). It loads data in parallel using the virtual warehouse's compute and supports many file formats (CSV, JSON, Parquet, etc.). Snowpipe (A) is designed for continuous, event-driven micro-batch ingestion - not bulk loads. INSERT (B) is for small-scale row-level inserts. External tables (C) allow querying files in place without loading them, which is not bulk loading.
Topics
Community Discussion
No community discussion yet for this question.