Output Tables
This is a list of all the output tables available in the Hosting Capacity Service database, along with detailed descriptions of each column and how to use them. Note that depending on the specific implementation, your tables may not be located in a 'output' database, but may be be found alongside input tables in a 'input/results' database. Talk to your system administrator if you are unsure.
All times in all tables are expressed in UTC.
Network Performance Metrics Enhanced
Weekly Reports
Constraints
Duration Curves
Link to Input
Calibration Meter Results
Node Level Results Table
For information on node level results, a feature in active development only available to select customers, see Node Level Results.
Logs
Raw Results Tables
Energy Meters Raw
Energy Meter Voltages Raw
Overloads Raw
Voltage Exceptions Raw
Metrics Enhanced Profile Raw
Semi-Deprecated Tables
Network Performance Metrics
This table contains the basic (non-enhanced) network performance metrics. It has been superseded by the network_performance_metrics_enhanced table, which provides a more comprehensive set of results and metrics. Users are encouraged to transition to the enhanced table, as this table may be removed in a future version.
Parquet Hierarchy (Blob Storage)
For users storing results in blob storage, parquet files follow the same logical table structure described above and are organised under each Work Package ID. Files are grouped by table, then by scenario, feeder and year, with individual parquet files named by their timestamp (see the hierarchy below).