Partner Data Warehouse Tables

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

📘

Expand > the sidebar on the left to see the model documentation pages.

• Application Users
• Charge Keys
• Charge Point Sites
• Charge Points
• Charge Pricing Breakdown
• Charge Member Costs
• Charges
• Failed Charges Info
• Operators
• Subscription Purchases
• Subscriptions
• Tariff Recurring Periods
• Tariff Period Groups
• Tariff Prices
• Team Members
• Team Price Groups
• Teams
• Transactions
• Users

All tables are updated every 8 hours.

Tables qualified naming convention (DATABASE.SCHEMA.TABLE)

• DATABASE = partner
• SCHEMA = production_<PARTNER_NAME>
• TABLE = <TABLE_NAME>

-- For example, with PARTNER_NAME=examplepartner and TABLE_NAME=users

SELECT COUNT(1) FROM partner.production_examplepartner.users;