Wojtek Bialek
Row count & statistics is an import option that allows for the extension of the process with a step for retrieving table statistics. This option is not available for all connectors and varies in the number of statistics retrieved.
Description of Imported Statistics
- Row count - the number of rows in the table
- Last user query - the date when a user last queried the table for data
- Number of user queries - the number of queries made by users on the table
- Last user update - the date when the data in the table was last updated
- Number of user updates - the number of updates performed on the table
- Last load time - the date of the last data load into the table; this statistic pertains only to data warehouses
Import
To import additional statistics during the import process, check the Import row count and statistics checkbox in the connection window.
The rest of the import process remains unchanged.
In the import summary window, an additional step will appear, informing you of the number of tables scanned and the time taken to import the statistics.
To refresh the statistics, import the changes for the database using the Import changes option.
The statistics values are saved to the repository in the dbo.tables and dbo.tables_stats tables.
Displaying statistics
Desktop
In the desktop application, access to the statistics is available through the Summary panel for Tables. To access it, double-click the Tables folder in the object tree. After a successful import, the statistics will appear in new columns.
Portal
In the portal, the data will be accessible from the table level. You need to enter the object, and the data will appear in the main table panel.
Supported connectors
Dataedo supports statistics import for six connectors.
We encourage you to review the documentation for each connector to better understand their capabilities.