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

Snowflake applies file format and copy options in a specific order of precedence. Options specified directly within the COPY INTO

statement have the highest priority. This allows for maximum control and flexibility on a per-load basis, as these settings will override any conflicting options defined in more general locations like a named stage or the target table's metadata. This ensures that the most specific instruction for a given data loading operation is the one that is executed.

statement.

C. Session level: File format options are not typically defined at the session level in the context of the COPY command's precedence hierarchy.

---

.

Section: Usage Notes > Order of Precedence for File Format and Copy Options

Content: The documentation explicitly lists the order of precedence for applying file format and copy options during a load operation. It states that options specified directly in the COPY INTO

statement are evaluated first (i.e.

have the highest precedence)

followed by options in a named file format (if referenced)

then options in the stage definition

and finally

options specified for the target table. This directly supports that the COPY INTO TABLE statement's options are applied first.