COPY_HISTORY retains data loading history for how many days?

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

COPY_HISTORY retains data loading history for how many days?

Explanation:
The main idea is that COPY_HISTORY is a built-in history view for data-loading operations, showing metadata about recent COPY INTO jobs. It retains data-loading history for fourteen days, giving you quick access to details like which files were loaded, how many rows were loaded, and whether the load succeeded, for the most recent two weeks. After that window, older records are purged. If you need longer-term records, you’d export the data or use other auditing mechanisms outside this 14-day window.

The main idea is that COPY_HISTORY is a built-in history view for data-loading operations, showing metadata about recent COPY INTO jobs. It retains data-loading history for fourteen days, giving you quick access to details like which files were loaded, how many rows were loaded, and whether the load succeeded, for the most recent two weeks. After that window, older records are purged. If you need longer-term records, you’d export the data or use other auditing mechanisms outside this 14-day window.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy