🧭✨Future Sponsored Charge Points (NEW)

✨ NEW TABLE - November 2025

🛠️ Partner API Alignment Migration

🧭 This table represents the post-migration state for sponsored_charge_points.

1️⃣ Migrate to this table by April 2026

2️⃣ Between April 2026 and July 2026, remove FUTURE__ prefix

Contains sponsored charge point relationships between charge point operators and teams. Links charge points to sponsoring teams and tracks sponsorship details including payouts and subscription settings.

SQL: FUTURE__sponsored_charge_points

Schema

Column Name	Data Type	Description
Primary ID
id	INTEGER	primary_key
Other IDs
charge_point_id	INTEGER	References the associated charge point's unique identifier
team_id	INTEGER	References the sponsoring team's unique identifier
price_group_id	INTEGER	References the price group applied to this sponsored charge point
Timestamps
created_at	TIMESTAMP_NTZ	Timestamp when the sponsorship record was created
accepted_at	TIMESTAMP_NTZ	Timestamp when the sponsorship was accepted by both parties
updated_at	TIMESTAMP_NTZ	Timestamp of the last update to this sponsorship record
deleted_at	TIMESTAMP_NTZ	Timestamp when the sponsorship was terminated, null if active
team_deleted_at	TIMESTAMP_NTZ	Timestamp when the sponsoring team was deleted, null if active
Attributes
payout	NUMBER	The monetary amount paid to the charge point operator for this sponsorship
note	VARCHAR	Additional comments or details about the sponsorship arrangement
pay_for_subscriptions	BOOLEAN	Indicates whether subscription-based charging is covered under this sponsorship

Changes from Last Version

same schema
filter out rows where team_deleted_at is not null to align with last table version.

Data Inclusion Criteria

team_id is in among the operator's teams

Data flow

Upstream tables	Downstream tables
`FUTURE__charge_points`	none
`FUTURE__teams`

Alignment

The `sponsored_charge_points` table

exclude rows where team_deleted_at is not null

Partner API

This table aligns with the get/sponsored-charge-points endpoint of the Partner API
Partner API has more restrictive conditions to include a charge point than the Partner Data Warehouse.
Filter rows in FUTURE__sponsored_charge_points to only include charge_point_ids that are among ids in the FUTURE__charge_points table where the charge point is matched on being sponsored, not owned by the operator

where
    charge_point_id in (
        select id
        from FUTURE__charge_points
        where
            -- Include charge points matched via sponsorship
            (is_sponsor_operator_match = true or is_sponsor_parent_operator_match = true)
            -- Exclude charge points already matched via ownership
            and is_main_operator_match = false
            and is_parent_operator_match = false
    )