A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?

Question

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.

How does Snowflake recommend maximizing the load performance?

Miguel Medina Parra · Accepted Answer

Produce the largest files possible, reducing the overall number of files to process.

Miguel Medina Parra · Answer

Use auto-ingest Snowpipes to load large files in a serverless model.

Miguel Medina Parra · Answer

Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

Miguel Medina Parra · Answer

Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 311 - COF-R02 discussion

Suggested answer: B

0 comments