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:

The charge point id (cp_id) links the charge to one of your charge points.
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>