Monta.com

Available Data

Partner Data Warehouse Access

Upon joining the Partner Data Warehouse, you will gain access to the following key data sets:

  • Charges
  • Charge Points
  • Teams
  • Team Members
  • Transactions
  • Users

All data sets are updated every 4 hours.


Important Relations

charge_points

Charge points are directly associated with your operator, through one or more of the following fields: operator_id, parent_operator_id, sponsor_operator_id, parent_sponsor_operator_id.

teams

Teams are directly linked to your operator via the operator_id field.

charges

Charges is a comprehensive list of all charge events where at least one of the following conditions is met:

  1. The charge point id (cp_id) links the charge to one of your charge points.
  2. The Paying_team_id column associates the charge with one of your teams via the team_id. This enables you to connect individual charging events to specific teams and their members.

transactions

Transactions occur either to or from a team under your operator. The to_wallet_owner_id specifies the recipient of the transaction, while from_wallet_owner_id denotes the sender. Transactions are connected to charges through the reference_id, given that reference_type == CHARGE.

team_members

The team_members table offers a comprehensive list of team IDs and user IDs for all team memberships.

users

The users table provides detailed information on users who are members of one or more of your teams.

All tables adhere to the following naming convention:

PARTNER.PRODUCTION_<PARTNER_NAME>.<TABLE_NAME>


What’s Next

Here is a few examples queries that show how to use the data.