Data Tables
Overview
The Data Tables dashboard provides a comprehensive overview of your data warehouse, offering key statistics and performance metrics for your core data tables. Use this dashboard to monitor table storage, growth trends, and the performance of read/write operations. This allows you to understand your data footprint and diagnose potential performance issues proactively.
Navigating to the Data Tables Dashboard
To get started, navigate to the central monitoring area for your data tables.
From the main dashboard, locate the Data Management section.
Click on Data Tables.
Understanding Data Table Metrics
The dashboard is organised into several sections, each providing specific insights into your data. You can switch between different tables to view their unique metrics.
Selecting a Data Table
At the top of the dashboard, you will find buttons to select the specific data table you wish to inspect. The primary tables are:
Events Table: Contains all event data captured.
Profiles Table: Stores user profile information.
Products Table: Holds data related to your product catalogue.
Clicking on a table name will refresh the dashboard to display the metrics relevant to that specific table.
Table Storage Metrics
This section provides a high-level view of the storage consumed by the selected table.
Total Rows: The total number of rows currently in the table. This is a direct measure of the volume of records.
Total Size: The amount of disk space the table's data occupies after compression.
Size Uncompressed: The original size of the table's data before any compression is applied. This helps in understanding the efficiency of data storage.
A bar chart visualises the growth in the total number of rows over the last 30 days, making it easy to spot trends and growth patterns.
Database Performance Metrics
Monitor the real-time performance of your database with read and write metrics.
Note: These charts display live performance data, helping you identify throughput and latency for the selected table. Hovering over the graphs will reveal specific data points for a given time.
Database Reads
This panel shows the efficiency of data retrieval operations.
Throughput (QPS): Displays the number of read queries per second being executed against the table.
Response Time (sec, avg): Shows the average time taken to complete a read query. A lower response time indicates better performance.
Database Writes
This panel shows the performance of data ingestion and update operations.
Throughput (WPS): Displays the number of write operations per second being executed against the table.
Last updated