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.
Mallikharjuna452
4 months ago_yyukta
9 months agoKHarish
11 months, 3 weeks agoShanvi_27
1 year, 1 month agogalicneverdie
1 year, 2 months agoasorock
1 year, 4 months agoVS3497
1 year, 5 months agoshubtred
1 year, 5 months agoMayuri917233
1 year, 6 months agoFabmel1
1 year, 6 months agocxna
1 year, 7 months agoTapasgup007
1 year, 11 months agoPercy2112
2 years, 3 months agodistopic
2 years, 5 months agoSatuPatu
2 years, 5 months agoseanosteen
2 years, 6 months agoFab33
2 years, 7 months ago