Wojtek Bialek
Imported Statistics
| Statistics | Is imported | Description |
|---|---|---|
| Row count | ✅ | Indicates the number of rows in table |
| Last user query | ❌ | - |
| Number of user queries | ❌ | - |
| Last user update | ❌ | - |
| Number of user updates | ❌ | - |
| Last load time | ✅ | Last datatime of when data was loaded using 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
COPY_HISTORY view used in query extracting load time statistics has several limitations:
- latency for the view may be up to 120 minutes
- 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 main article