What takes the highest precedence in Snowflake file format options, when specified in multiple locations during data loading?

The correct answer is C. The use of a copy into <table> statement. Snowflake resolves file format options using a defined precedence hierarchy (highest to lowest): (1) options specified directly in the COPY INTO <table> statement, (2) options defined in the stage definition, (3) options defined at the table level. This means that any file…

Data Loading and Unloading

Question

Options

AThe stage definition
BThe table definition
CThe use of a copy into <table> statement
DThe use of a copy INTO <location> statement

How the community answered

(40 responses)

A
3% (1)
B
5% (2)
C
90% (36)
D
3% (1)

Explanation

Snowflake resolves file format options using a defined precedence hierarchy (highest to lowest): (1) options specified directly in the COPY INTO <table> statement, (2) options defined in the stage definition, (3) options defined at the table level. This means that any file format option explicitly set in the COPY INTO statement will override the same option defined in a stage or table. This design gives the executing user maximum control at query time without needing to alter the stage or table definitions.

Topics

#Data Loading#COPY INTO#File Format Options#Precedence

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice