If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
When file format options are specified in multiple locations, the load operation follows a specific precedence. The COPY INTO TABLE statement options take the highest precedence, followed by the stage definition, and then the table definition. This ensures that the most specific and direct instructions in the load operation are applied first.
correct
D - no doubts
https://docs.snowflake.com/en/user-guide/data-load-prepare
add'l info -- order / precedence -- copy into (1st), stage def (2nd), table def (3rd).. D, B, A.