If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

The correct answer is D. COPY INTO TABLE statement. Snowflake applies file format options using this order of precedence (highest to lowest): COPY INTO TABLE statement > Stage definition > Table definition. The COPY INTO TABLE statement has the highest precedence, meaning any format options specified directly in the COPY command…

Data Loading and Unloading

Question

Options

ATable definition
BStage definition
CSession level
DCOPY INTO TABLE statement

How the community answered

(21 responses)

B
5% (1)
C
5% (1)
D
90% (19)

Explanation

Snowflake applies file format options using this order of precedence (highest to lowest): COPY INTO TABLE statement > Stage definition > Table definition. The COPY INTO TABLE statement has the highest precedence, meaning any format options specified directly in the COPY command override those defined on the stage or table. Session-level settings are not part of the file format precedence chain for COPY operations. This precedence order allows users to override default or pre-configured format settings at query time without modifying the stage or table definition.

Topics

#Data loading#File format precedence#COPY INTO statement#Data ingestion

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice