Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
The command 'COPY INTO [location]' is used to unload data from a Snowflake database table into one or more files in a specified location, such as an internal stage, external stage, or an external storage location like Amazon S3, Google Cloud Storage, or Microsoft Azure. 'COPY INTO [table]' is used for loading data into a table, while 'CREATE STAGE' and 'CREATE PIPE' are not related to unloading data.
copy into command
answer B,C
It's C - https://docs.snowflake.com/en/sql-reference/sql/copy-into-location COPY INTO <location> Unloads data from a table (or query) into one or more files in one of the following locations: Named internal stage (or table/user stage). The files can then be downloaded from the stage/location using the GET command. Named external stage that references an external location (Amazon S3, Google Cloud Storage, or Microsoft Azure). External location (Amazon S3, Google Cloud Storage, or Microsoft Azure).