Monitoring a Query and Copy History

Introduction to Snowflake

Daniel Hong

Senior Data Engineer

Benefits of Monitoring

• See how tables are queried
• See which queries take longest to execute
• See how much data is copied to tables
• Debug failures and see historical queries

Viewing Query History

• Can retrieve a past SQL query you wrote
• Keeps track of queries executed in past 14 days

Finding a Query

Query Details

Viewing Copy History

• Monitor incoming volume of data from external sources
  • see how often loads are succeeding vs failing
• Two options to view
  • Monitoring > Copy History (45 minute data latency, BUT can be longer)
  • Table > Copy History (no latency, data is up to date)
• Access limited to higher privilege roles
  • PUBLIC role restricted due to sensitive information

Copy History Demo

Monitoring > Copy History

Table > Copy History

Let's practice!

Introduction to Snowflake