QuestionQ51

VerifiedData Loading and Transformation

When unloading data with the COPY INTO <location> command, what is the purpose of the PARTITION BY <expression> parameter?

Explanation

PARTITION BY <expression> partitions unloaded table rows by the expression’s values and writes the partitions to separate output files. Snowflake may create multiple files within a partition based on data volume and parallel execution, but the expression determines the partitioning. Snowflake COPY INTO <location> documentation

Learn more

Community Discussion

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