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…

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.


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:{account_id}/{environment_id}/dashboard)


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.

Have questions about this Kit?

Please contact the Rivery Support Team by clicking the Help menu and creating a ticket.

Easily Solve Your Most Complex Data Challenges

No Credit Card Required.