What is RTDIP SDK?

​​Real Time Data Ingestion Platform (RTDIP) SDK is a software development kit built to easily access some of RTDIP's transformation functions.

The RTDIP SDK will give the end user the power to use some of the convenience methods for frequency conversions and resampling of Pi data all through a self-service platform. RTDIP is offering a flexible product with the ability to authenticate and connect to Databricks SQL Warehouses given the end users preferences. RTDIP have taken the initiative to cut out the middle man and instead wrap these commonly requested methods in a simple python module so that you can instead focus on the data.

See RTDIP SDK Usage for more information on how to use the SDK.

Authenticators

The RTDIP SDK includes several authentication methods to cater to the preference of the user. See below:

• Default Authentication - For authenticating users with Azure AD using the azure-identity package. Note the order that Default Authentication uses to sign in a user and how it does it in this documentation. From experience, the Visual Studio Code login is the easiest to setup, but the azure cli option is the most reliable option. This page is useful for troubleshooting issues with this option to authenticate.

Visual Studio Code

As per the guidance in the documentation - To authenticate in Visual Studio Code, ensure version 0.9.11 or earlier of the Azure Account extension is installed. To track progress toward supporting newer extension versions, see this GitHub issue. Once installed, open the Command Palette and run the Azure: Sign In command.

• Certificate Authentication - Service Principal authentication using a certificate

• Client Secret Authentication - Service Principal authentication using a client id and client secret

Note

RTDIP are continuously adding more to this list so check back regularly!

SQL Warehouses

The RTDIP SDK uses Databricks SQL Warehouses to provide access to RTDIP data. See below for different endpoint options depending on the region required:

• SQL Warehouses

Connectors

Once the user is authenticated, they can connect to Databricks SQL warehouses using one of the following methods:

• Databricks SQL Connector

• PYODBC SQL Connector

• TURBODBC SQL Connector

Functions

Finally, once the user is authenticated and connected to Databricks SQL Warehouses they have access the following functions:

• Resample

• Interpolate

• Raw

• Time Weighted Averages

• Metadata

Note

RTDIP are continuously adding more to this list so check back regularly!