Set Up and Access Meter Passthrough Data in Object Storage

Oracle Utilities Data Intelligence can deliver meter passthrough data from Meter Solution Cloud Service to your Oracle Cloud Infrastructure (OCI) object storage. Meter passthrough data includes measurements from channels such as voltage, power factor, amperage, and other meter telemetry that may not need to be stored as regular meter data in Meter Solution Cloud Service. Oracle Utilities Data Intelligence copies the passthrough data, transforms it to iceberg table format, and delivers the transformed data as Parquet files back to your object storage. You can then access the data directly to support analytics, machine learning, and custom data science use cases.

Meter passthrough data is delivered separately from standard advanced metering infrastructure usage data. Standard usage channels, such as kilowatt hour usage, can continue to be processed and stored as regular meter data. Other channels can be configured for passthrough processing so they are routed for external use without being stored as regular meter measurements.

Configure Meter Solution Cloud Service for Meter Passthrough Data

Before the data can be delivered to object storage, configure the applicable external measuring component types and measuring components in Meter Solution Cloud Service so their initial measurement data is handled as passthrough data. For the detailed setup process, go to Direct Measurement Processing and see Measuring Component Filtering.

Provide Oracle Utilities Access to Your Object Storage

After your passthrough data has been copied to your object storage, Oracle Utilities needs access so the data can be copied and transformed to Apache Iceberg table format. If you have not already provided this access, follow the object storage access setup process in the Administrator Guide: Provide Oracle Utilities with Access to Object Storage.

Access Your Transformed Meter Passthrough Data

After Oracle Utilities has copied and transformed your meter passthrough data to iceberg format, it is delivered to your OCI object storage under the AMI Publisher directory. If applicable, partitions are organized under the table prefix.

The list below is an example of the directory path where the meter passthrough data may appear under /AMI_PUBLISHER.

• /AMI_PUBLISHER
  • /CISADM
    • /data
      • /MEASUREMENT_PASS_THROUGH

Your Data Responsibilities

It is recommended that you not perform any actions on the delivered meter passthrough data other than reading it. You can copy the data to another location for further modification, but any changes or custom solutions built on top of this data are your sole responsibility. Keep in mind the scenarios below.

Customer Action	AMI Publisher Response or Impact
Deletes data from the table	AMI Publisher attempts to recover deleted data. Large deletions may cause job failure and require technical support.
Adds data to the table independently	AMI Publisher does not interact with customer-added data.
Updates data in the table independently	Updates remain unless the source system provides new updates, in which case AMI Publisher overwrites the data with the latest value.
Deletes the table entirely	AMI Publisher may try to rebuild the table, but large data volumes can cause job failure.
Deletes the object storage bucket	The AMI Publisher job fails.
Deletes the user or changes user permissions	The AMI Publisher job fails.
Needs to reload the entire table	Full table reload is possible, but a support ticket must be opened.
Needs regular backups of delivered data	Backups are not required unless you have advanced or specific needs, such as protection against rare regional outages.
Builds custom solutions or modifies data in another copy	All customer-built solutions or data modifications are solely your responsibility.