Answer is C & D.
Not B as:
https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes
All COPY INTO <table> copy options are supported except for the following:
FILES = ( 'file_name1' [ , 'file_name2', ... ] )
ON_ERROR = ABORT_STATEMENT
SIZE_LIMIT = num
PURGE = TRUE | FALSE (i.e. automatic purging while loading)
FORCE = TRUE | FALSE
The correct options for what is true of Snowpipe via REST API are:
C. Snowflake automatically manages the compute required to execute the Pipe's COPY INTO commands
D. Snowpipe keeps track of which files it has loaded
Here's why the other options are not accurate:
A. You can only use it on Internal Stages: You can use Snowpipe via REST API with both Internal Stages (located within Snowflake storage) and External Stages (referencing data in external cloud storage providers like S3 or Azure Blob Storage).
B. All COPY INTO options are available during pipe creation: Not all COPY INTO options are available through the Snowpipe REST API for pipe creation. While the core functionality is supported, some advanced options might be limited through the API compared to directly using the COPY INTO command within Snowflake.
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.
redsky0
Highly Voted 2 years, 10 months agoMallikharjuna452
Most Recent 4 months ago372110c
4 months, 3 weeks agopranalig
5 months agoPrashantGupta1616
5 months, 2 weeks agoAlex_Ovidiu
7 months, 2 weeks agooscarglob
1 year, 1 month agoMayuri917233
1 year, 6 months agoRajuNaik
1 year, 7 months agoPrajdeo
1 year, 8 months agoBigDataBB
1 year, 10 months agoTapasgup007
1 year, 11 months agobharathmv
2 years, 2 months agoDK69
2 years, 6 months agoAGuru2020
2 years, 8 months agovivek_nitd
2 years, 9 months agoRajokkiyam
2 years, 9 months ago