the best answer is : A
Snowflake supports specifying a SELECT statement instead of a table in the COPY INTO <location> command. The results of the query are written to one or more files as specified in the command and the file(s) are stored in the specified location (internal or external).
Bullk unload supports "SELECT" statements and the answer is True. See query below
COPY INTO @my_stage/my_unloaded_data.csv
FROM (
SELECT col1, col2, col3
FROM my_table
WHERE condition
)
FILE_FORMAT = (FORMAT_NAME = 'CSV' COMPRESSION = 'AUTO');
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
dbairfan
2 months agoPrasantSadangi
2 months, 3 weeks agotharangaweer
4 months, 2 weeks agoSahuVijay
4 months, 4 weeks agoMallikharjuna452
11 months ago_yyukta
1 year, 3 months agoKHarish
1 year, 6 months agoShanvi_27
1 year, 8 months agogalicneverdie
1 year, 9 months agoasorock
1 year, 11 months agoVS3497
2 years agoshubtred
2 years agoMayuri917233
2 years, 1 month agoFabmel1
2 years, 1 month agocxna
2 years, 2 months agoTapasgup007
2 years, 6 months agoPercy2112
2 years, 10 months ago