HomeGuidesAPI ReferenceChangelog
Log In
Guides
  1. Migration Guides

Plug SQL 1.4 File Delivery Migration Guide

A quickstart guide for customers transitioning from UDS SQL 1.3 to Plug SQL 1.4 file delivery (SFTP).

This guide is for customers who currently rely on the legacy UDS SQL Delivery Format (aka "SQL1.3") and are looking to migrate to a similar delivery format on Plug so as to minimizes changes to their existing integration. It covers how Plug file delivery works, what configuration options are available, and where to find the resources you need to validate and load your data.

📘

If you are migrating from the UDS API to the Plug API, see Legacy UDS API to Plug API.

What is SQL 1.4?

SQL 1.4 is a relational data schema designed for customers migrating from the Legacy UDS platform to Plug. It preserves the familiar tabular structure of the UDS SQL 1.3 schema — delivering data as CSV files that map to a relational database — while incorporating Plug platform capabilities that were not available in UDS, such as first-class site modeling, improved meter reconciliation, and enhanced statement versioning. The result is a delivery format that minimizes disruption to existing ingestion workflows while giving you access to richer, more accurate utility data.

How File Delivery Works

Plug delivers data as a .csv file compressed into a .zip archive. Each .csv file contains the new statement data acquired and processed for active Plug accounts since the previous delivery. Customers have the option for source statement PDF files to be included in the .zip file alongside the .csv file.

Deliveries are sent to an SFTP server on a recurring cadence (typically daily). Each .zip and .csv is named with the same, customizable prefix and a timestamp suffix indicating the date and time of delivery.

Delivery Configuration Options

Your Arcadia team will work with you to configure delivery settings during migration onboarding. The following options are available:

Option

Description

SFTP hosting

Arcadia can host the SFTP server, or you can provide your own.

Source PDFs

Original bill PDFs can be included in each delivery .zip. This is configurable per Plug organization.

Delivery cadence

Deliveries are typically daily, but can be adjusted to match your processing schedule. Daily is the most frequent delivery cadence supported.

Statement versioning

You can choose to receive only the first version of each statement (consistent with UDS behavior), or receive the latest version automatically when corrections are made (see Statement Versioning and Repair ).

File naming prefix

A custom filename prefix can be configured, otherwise the default prefix depends on your choice for the statement versioning option:

  • First version only: SQL_1_4__append__[model version]
  • All statement versions: SQL_1_4__statement_versioning__[model version]

[model version] (e.g. "v1") allows us to make enhancements to the models over time without forcing existing customers to adapt to changes that may break their integration. You will be notified when a new version becomes available and given the option to upgrade or not.

To request changes to your delivery configuration, contact your Customer Success Manager or Account Manager.

SQL 1.3 to SQL 1.4 Field Comparison

Download the field comparison spreadsheet for a detailed mapping of every SQL 1.3 field to its SQL 1.4 equivalent. This resource is intended to help you update your ingestion logic and downstream systems.

Download the SQL 1.3 → SQL 1.4 Field Comparison Spreadsheet

Sample Files: SQL 1.3 vs. SQL 1.4 Behavioral Differences

The sample files linked below illustrate scenarios where SQL 1.4 data differs in structure or behavior from SQL 1.3. These samples use anonymized data and are designed to help you understand the practical impact of migration on your ingestion and reporting workflows.

The sample files highlight key scenarios including:

  • Meter reconciliation — how Plug resolves meter assignments differently than UDS, including cases where a meter was previously null.
  • Dual-provider handling — how accounts served by multiple providers are represented in SQL 1.4.
  • Proration and inference — how prorated and inferred usage and charges appear in the new schema.
  • Statement versioning — how corrected or updated statements are delivered.

Download the SQL 1.3 vs. SQL 1.4 Sample Files

Standard Load Scripts

Arcadia has certified Microsoft SQL Server (2017+), MySQL (8.4+), and Oracle (12c+) to be used as the relational database platform for storing Plug data.

The script packages below provide data load scripts (to import delivered CSV files) and schema creation scripts (to set up the SQL 1.4 tables). Detailed step-by-step instructions are included with each package.

Updated 1 day ago