Snowflake - Table Statistics
Imported Statistics
| Statistics | Is imported | Description |
|---|---|---|
| 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
