Snowflake SnowPro Core Certification COF-C02 Question # 139 Topic 14 Discussion

When loading data into Snowflake, the file format options specified in the COPY INTO <title> statement take the highest precedence over other locations such as the stage or table definitions. This ensures that any specific settings for a particular load operation are applied correctly.

File Format Hierarchy:

Stage Definition: Specifies default file format options for files staged in the location.

Table Definition: Can specify default file format options associated with the table.

COPY INTO Statement: Overrides both the stage and table definitions with the file format options specified directly in the statement.

Example Usage:

COPY INTO my_table

FROM @my_stage

FILE_FORMAT = (FORMAT_NAME = 'my_format' FIELD_OPTIONALLY_ENCLOSED_BY = '"');

References:

Snowflake Documentation: Copy into Table

Snowflake Documentation: File Format Options