Sponsored Charge Points (🧭 FUTURE)

✨ 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

Updated 12 days ago