Skip to main content

Snowflake - Table Statistics

Imported Statistics​

StatisticsIs importedDescription
Row count✅Indicates the number of rows in the table
Last user query❌-
Number of user queries❌-
Last user update❌-
Number of user updates❌-
Last load time✅Last datetime of when data was loaded using the COPY command or using Snowpipe

Requirements​

Dataedo requires access to the following tables and views:

  • INFORMATION_SCHEMA.TABLES
  • INFORMATION_SCHEMA.LOAD_HISTORY
  • SNOWFLAKE.ACCOUNT_USAGE.COPY_HISTORY

Limitations​

The COPY_HISTORY view used in the query extracting load time statistics has several limitations:

  • Latency for the view may be up to 120 minutes
  • The view only includes COPY INTO commands that executed to completion
  • Dropping or recreating a table object removes the historical data for bulk data loads
  • Dropping or recreating a pipe object removes the historical data for Snowpipe data loads using the pipe

Learn more​

Read more about table statistics import in the main article

On this page
Questions?
If you have any questions or need assistance, feel free to reach out to the Dataedo support team.
Dataedo support
Dataedo is an end-to-end data governance solution for mid-sized organizations.
Data Lineage • Data Quality • Data Catalog
Release notesArchiveRoadmapSupport
LinkedInYouTube