Snowflake
COF-C02 · Question #203
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
The correct answer is D. In the metadata of the pipe for 64 days. The bulk data load history available after a COPY statement is stored in the metadata of the pipe and is retained for 64 days.
Data Loading and Unloading
Question
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
Options
- AIn the metadata of the target table for 14 days
- BIn the metadata of the pipe for 14 days
- CIn the metadata of the target table for 64 days
- DIn the metadata of the pipe for 64 days
How the community answered
(41 responses)- A7% (3)
- B2% (1)
- C2% (1)
- D88% (36)
Explanation
The bulk data load history available after a COPY statement is stored in the metadata of the pipe and is retained for 64 days.
Topics
#Data Loading#Load History#Snowpipe#Metadata Retention
Community Discussion
No community discussion yet for this question.