Snowflake Table Function to Show Copy History Into Specific Tables

Snowflake provides this table function to query the history of copy commands into specific tables.

This function is quite valuable, show all copies into the specified table whether they were manual copies, or automated copies via snowpipe.

select *
from table(information_schema.copy_history(table_name=>'MYTABLE', start_time=> dateadd(hours, -1, current_timestamp())));

I should add, it is well documented by Snowflake at the link below but, I found this function so valuable that I re-blogged the information here.

https://docs.snowflake.com/en/sql-reference/functions/copy_history.html

Leave a Comment

Scroll to Top