DataHub Overview

What is DataHub?

DataHub is Arcadia’s new utility data access product, providing transformed and normalized reports to power your downstream systems. DataHub offers an alternative bulk access mechanism to access your utility data without integrating with Plug API. DataHub provides access to your utility data through two new ingestion options: zipped CSV files delivered to your SFTP server or access to a Snowflake Direct Share to query your data directly in Snowflake export tables. Learn more about setting up data access.

DataHub Tables

Currently, DataHub offers ESG and Meter Level Summary tables

The ESG tables prepare calendarized, standardized, and aggregated meter-level utility data at monthly, quarterly, and annual timeframes to support ESG scope 2 reports. For example, the Calendarized Monthly Usages table aggregates your meters’ daily usage values and provides monthly level totals for your meters’ usages. This table enables you to understand how much energy the meter uses for a specific month to calculate how much greenhouse gas emissions occur at this service location.

The Meter Level Summary table presents meter measurement period utility data, including consumption categories (e.g., measured total consumption, measured max demand, bidirectional in, etc.), total costs, meter-level custom data, and site-level custom data fields. The Meter Level Summary table solves for duplicate statement scenarios in deregulated markets where the supplier and delivery utility providers report overlapping data for the same meter. This new format includes standardizing units of measure for electric, water, and natural gas service types. Meter Level Summary supports insights like highest peak demand per meter, total consumption per site, and meters enrolled in budget billing to address energy management and carbon accounting use cases.

Learn more about DataHub tables.

Prerequisites

Onboard Utility Credentials and Utility Files onto Plug

If you haven't already, you will onboard your utility data onto Plug. You will submit utility credentials through Plug’s Connect experience or Create Credential API endpoint. If you do not have utility credentials and instead have the source statement PDFs, you will onboard these statements through Plug’s Bill Uploader module or Add File API endpoint.

Enable Proration and Inference Features

If signed up after March 25th, 2024, proration and inference features are enabled by default. If you signed up before then, you will need to enable proration and inference features.

Create Sites and Assign Meters to Site (optional)

In order to group your meters by site ID in DataHub, Arcadia recommends that you create Sites for your relevant geographical locations and map utility meters to the site containers to further organize your utility data in Plug.