QuestionQ74

Performance Optimization, Querying & Transformation

How can a user improve the performance of a COPY INTO <table> query that is running against a very large file?

Explanation

Splitting a very large data file into smaller files lets Snowflake process multiple files in parallel and distribute the load across the active warehouse’s compute resources. Snowflake recommends splitting larger files to improve load scalability.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!