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.
tharangaweer
3 weeks agoSahuVijay
1 month agoMallikharjuna452
7 months, 1 week ago_yyukta
1 year agoKHarish
1 year, 2 months agoShanvi_27
1 year, 4 months agogalicneverdie
1 year, 5 months agoasorock
1 year, 7 months agoVS3497
1 year, 8 months agoshubtred
1 year, 8 months agoMayuri917233
1 year, 9 months agoFabmel1
1 year, 9 months agocxna
1 year, 10 months agoTapasgup007
2 years, 2 months agoPercy2112
2 years, 6 months agodistopic
2 years, 8 months agoSatuPatu
2 years, 8 months ago