
Explanation:
The question asks about the highest precedence for file format options when specified in multiple locations during data loading in Snowflake. According to Snowflake documentation and the community discussion, the precedence order is: 1) COPY INTO statement options (highest), 2) Stage definition options, 3) Table definition options (lowest). The COPY INTO statement takes precedence because it allows explicit override of file format settings at the time of data loading. The community discussion shows 80% consensus for option C, with references to Snowflake documentation confirming that COPY INTO options override both stage and table definitions. Option B (table definition) is incorrect as it has the lowest precedence. Option D (COPY INTO location) is not relevant to file format option precedence.
Ultimate access to all questions.
No comments yet.
When setting file format options in multiple places during a data load in Snowflake, which location has the highest precedence?
A
The stage definition
B
The table definition
C
The use of a COPY INTO [table] statement
D
The use of a COPY INTO [location] statement