What happens to COPY_HISTORY data when the associated table is dropped?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Master Snowflake Data Engineer Exam. Study with flashcards and multiple choice questions, each question includes hints and explanations. Prepare for your success!

Multiple Choice

What happens to COPY_HISTORY data when the associated table is dropped?

Explanation:
Copy history is metadata tied to a specific table’s data-loading operations. When the table is dropped, Snowflake cleans up that metadata, so the copy history entries are removed from the system. There isn’t an automatic archive or ledger for this history; if you need to preserve it, you must capture or export it before dropping the table.

Copy history is metadata tied to a specific table’s data-loading operations. When the table is dropped, Snowflake cleans up that metadata, so the copy history entries are removed from the system. There isn’t an automatic archive or ledger for this history; if you need to preserve it, you must capture or export it before dropping the table.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy