A user wants to unload data from a relational table into a CSV file in an external stage. The table must be named exactly as specified by the user.
Which file format option MUST be used to do this?
A user wants to unload data from a relational table into a CSV file in an external stage. The table must be named exactly as specified by the user.
Which file format option MUST be used to do this?
To ensure that the data is unloaded into a CSV file with the specified table name, the file_extension option must be used. This option specifies the file extension of the output file. By default, the extension for CSV files is .csv. Using this option ensures that the output file has the correct extension, which helps in maintaining the specified table name in the CSV file.
Question - The table must be named exactly as specified by the user Note If the SINGLE copy option is TRUE, then the COPY command unloads a file without a file extension by default. To specify a file extension, provide a file name and extension in the internal_location or external_location path. For example: copy into @stage/data.csv ...
The file_extension file format option specifies the file extension of the output file. The default file extension for CSV files is .csv. If you want the table to be named exactly as specified by the user, you must set the file_extension option to .csv.
D If the SINGLE copy option is TRUE, then the COPY command unloads a file without a file extension by default. To specify a file extension, provide a file name and extension in the internal_location or external_location path (e.g. copy into @stage/data.csv). https://docs.snowflake.com/en/sql-reference/sql/create-file-format
It's D
D for sure
It's either C or D. The question asks: "which file format option...". D SINGLE is not about file format option. It's a parameter for COPY INTO <location>. Also is the question asking about the table name? or a file name? It sounds like it's about the file name, but the question says "table name", which is confusing. I'd vote D, but I'm not 100% sure. https://docs.snowflake.com/en/sql-reference/sql/copy-into-location https://docs.snowflake.com/en/sql-reference/sql/create-file-format
Sorry, I meant to say I vote "C"
C correct - from docs: "Important If SINGLE = TRUE, then COPY ignores the FILE_EXTENSION file format option and outputs a file simply named data. To specify a file extension, provide a filename and extension in the internal or external location path."
You mean answer is D .. this is where you mention what name the file should be exported. If single is false snowflake generates name for the files
"Extension" only allows an extension name so therefore incorrect
https://docs.snowflake.com/en/sql-reference/sql/copy-into-location Single=True and specify a single file name like this: -- S3 bucket COPY INTO 's3://mybucket/./../a.csv' FROM mytable; -- Google Cloud Storage bucket COPY INTO 'gcs://mybucket/./../a.csv' FROM mytable;
D. Single
I will go for this because it required in naming the file