Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
How does the PARTITION BY clause affect the output of files generated by a COPY INTO {location} command?
A
The unload operation partitions table rows into separate files unloaded to the specified table.
B
The unload operation partitions table rows into separate files unloaded to the specified stage.
C
A single file will be loaded with a user-defined partition key and the user can use this partition key for clustering.
D
A single file will be loaded with a Snowflake-defined partition key and Snowflake will use this key for pruning.