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
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
Teams are directly linked to your operator via the operator_id
field.
charges
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 theteam_id
. This enables you to connect individual charging events to specific teams and their members.
transactions
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
team_members
The team_members
table offers a comprehensive list of team IDs and user IDs for all team memberships.
users
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>
Updated 4 months ago