Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
To load data from a file located in an external stage into a table in Snowflake, the COPY command should be used. This command is specifically designed for bulk data loading operations, allowing data to be transferred efficiently from external sources into Snowflake tables.
COPY COMMAND
Correct Answer: D
D. COPY
Correct
D - COPY INTO exactly
Why not INSERT ?
GET does not support downloading files from external stages https://docs.snowflake.com/en/sql-reference/sql/get.html So the answer is COPY
copy into table
Correct answer Copy