SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ65

Ingest and Process Data

A Data Engineer must obtain details about the data-loading history for tables in a particular database and schema. The tables were loaded by using Snowpipe during the last 24 hours.

How should the Engineer complete these tasks?

Explanation

For a specific table, Snowflake Copy History includes continuous loads performed through Snowpipe and provides up to 14 days of activity. A role needs USAGE on the database and schema containing the table plus any privilege on that table; in Snowsight, the table-level history is reached by selecting the database and schema, opening the table details, and choosing the Copy History tab. LOAD_HISTORY does not return Snowpipe load history.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!