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.
Correct answer Copy
copy into table
GET does not support downloading files from external stages https://docs.snowflake.com/en/sql-reference/sql/get.html So the answer is COPY
Why not INSERT ?
D - COPY INTO exactly
Correct
D. COPY
Correct Answer: D
COPY COMMAND