All updates

Improvement

Partner Data Warehouse — New Tables & Expanded Columns

Stage
Live
Product
Data Warehouse
Posted

What’s New

Three new tables are now available in the Partner Data Warehouse:

  • invoices — Periodic billing documents from the wallet billing service. Includes statement financials, billing periods, and wallet ownership matching to your teams and operators.
  • wallets — Wallet records showing ownership, currency, and country. Each wallet is scoped to your teams and operators.
  • wallet_balances — Current balance and credit for each wallet, with tracking for when balances go negative.

We also added new columns to four existing tables:

  • charges — average_price_per_kwh for per-kWh pricing analysis
  • charge_points — reservable flag indicating whether the charge point accepts reservations
  • teams — Extended address fields (address2, address3, province), contact emails (finance_email, legal_email), company registration number, and status fields (frozen_at, frozen_reason, blocked_at, payment_method)
  • team_members — New permission flags (can_deposit_to_wallet, can_withdraw_from_wallet, can_request_sponsoring, can_manage_members) and additional identifiers (cost_group_id, team_member_profile_id)

Why It Matters

These additions bring the Partner Data Warehouse closer to parity with the Partner API. The new wallet and invoice tables give you direct access to financial data that was previously only available through API calls, and the expanded columns on existing tables fill gaps in team, member, and charge point data.

Documentation

Full schema details and inclusion criteria for all new and updated tables are available in the Partner Data Warehouse documentation.