By Taylor Mcgrath

Rivery Consumption to BigQuery

Integrates with:

The Rivery Usage (RPUs) kit pulls data from the Rivery API to provide the user with an overview of the RPU usage over a given date range.

This Kit includes…

Data ingestion from the following Rivery API entity:
- River Activities

The granularity of the resulting dataset is river_id and day within a given Rivery environment. Consumption totals for each record can be found in the ‘RPUs’ field.

Configuring this Kit for use

API Token Creation

An API token has to be created in the Rivery account where this kit will be used. Follow the steps in the Rivery docs to create a Rivery API Token here.

Variables

In this Kit, there are six environment variables that are used to make for dynamic use of target configuration.

{dataset_rivery_activities} is used in all Target configurations and queries as the target database name.
{Rivery_activities_token} is your Rivery API Token. NOTE – Rivery API tokens are per environment, so to pull consumption data for multiple environments, you’ll need to replicate this process in each desired environment.
{Rivery_activities_account} is your Rivery Account ID. See below for how to locate this.
{Rivery_activities_environment} is the Environment ID See below for how to locate this.
{Rivery_API_Failure_Group} is used as the alert email address(es) for when a river fails. This is optional.

Go to the Variables menu on the left side navigation bar and create variables for dataset_rivery_activities, Rivery_API_Failure_Group, Rivery_activities_token, Rivery_activities_account, and Rivery_activities_environment. Fill in the value for the BigQuery dataset you’d like the data to land, your Rivery Account/Environment Details, and Rivery Token in the appropriate environment variables listed above.

*Rivery Account and Environment IDs can be found in the URL when logged in (ex: https://console.rivery.io/dashboard/{account_id}/{environment_id}/dashboard)

Connections

Kits are imported with ‘blank’ source and target connections. In order to use the kit, the user will need to add the API Token to the blank connection that comes with the imported kit.