Which command can be used to load data into an internal stage?
Which command can be used to load data into an internal stage?
The PUT command is used to load data files from a local directory into an internal stage in Snowflake. The PUT command uploads data to a stage, where it can then be accessed for further processing or loading into a Snowflake table.
D is the correct answer
chatGPT said it's D
ChatGPT also says to learn to read documentation.
D - PUT (load data into a stage (from local)) B - COPY (unload data into a stage (from snowflake))
load/unload -> copy into download/upload -> get/put
I think it's ambiguous question B or D It depends on the data source COPY unloads the data from table into stage PUT uploads a file from local file system into a stage https://docs.snowflake.com/en/user-guide/data-unload-overview https://docs.snowflake.com/en/sql-reference/sql/put
Its not PUT. The question is about loading data (i.e., rows). Not placing FILES. If the questions is about Unloading Data Files then its PUT. Its just Data Load, which means row transfer. So its COPY
If the question was "Which command can be used to UNLOAD ..." then is correct copy, but loading on stage means that You are loading external data, so is correct D
You can load data from table to a stage, for instance. its not necessarily external data
eiher B or D depending on the source
D. PUT
D correct
correct
Depending upon from where the data is being loaded.
correct
Option D as per https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage#types-of-internal-stages
B - COPY INTO @stage to unload the data into an internal stage
PUT command is for uploading the files from local system to cloud environment (snowflake internal stages). GET command is for unload the files from cloud environment (snowflake internal stages) to local system. COPY INTO is used to load data into a Snowflake table
Copy INTO @location is to upload it into a Stage. but this is for external stage
Answer is D We need 'PUT' to uploads data files from a local directory/folder into Internal Stage; Then we can use 'COPY INTO' command to load data into a table from the staged files https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#types-of-internal-stages