🧭✨Future Failed Charges Info (NEW)

✨ NEW TABLE - November 2025

🛠️ Partner API Alignment Migration

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

1️⃣ Migrate to this table by April 2026

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

Contains detailed information about failed charging sessions and their associated error data. Tracks technical failures, error codes, and charging session metrics to help diagnose and analyze charging point issues.

SQL: FUTURE__failed_charges_info

Schema

Column Name	Data Type	Description
Primary ID
id	INTEGER	Primary key (is charge_id)
Other IDs
charge_point_id	INTEGER	References the charge point where the failed charging session occurred
Timestamps
created_at	TIMESTAMP_NTZ	Timestamp when the failed charging session was initiated
completed_at	TIMESTAMP_NTZ	Timestamp when the failed charging session ended
Attributes
failed_reason	VARCHAR	High-level categorization of why the charging session failed
kwh	NUMBER	Amount of energy delivered before the charging session failed, measured in kilowatt-hours
firmware	VARCHAR	Version of firmware running on the charge point at time of failure
ocpp_reported_failure	VARCHAR	Raw failure message reported by the charge point via OCPP protocol
ocpp_end_reason	VARCHAR	Standardized OCPP reason code for why the charging session terminated
ocpp_end_reason_description	VARCHAR	Detailed description explaining the OCPP end reason code
ocpp_vendor_error_code	VARCHAR	Vendor-specific error code reported by the charge point
ocpp_reported_info	VARCHAR	Additional diagnostic information reported by the charge point via OCPP

Changes from Last Version

Renamed columns:

charge_id → 'id'
cp_id → charge_point_id

** Removed column

external_id (was always null and unused)

Data inclusion criteria

the charge_point_id is among ids of the operator's FUTURE__charge_points

Data flow

Upstream tables	Downstream tables
`FUTURE__charge_points`	none

The `failed_charges_info` table

To match failed_charges_info one needs to align FUTURE__charge_points with charge_points

Updated 4 days ago