Skip to main content
Private Preview FeatureThis feature is currently in private preview. Contact support@firebolt.io to request early access.
The information_schema.cdc_ingests view reports the live state of CDC table ingestion: one row per CDC table with an active ingest worker. The state comes from the workers themselves, so query the view on the engine where ingestion runs (the engine that executed ALTER CDC TABLE ... RESUME); on other engines the view is empty. 
SELECT table_name, stream_name, state, phase,
       apply_count, last_commit_time, live_lag_ms, last_error, error_count
FROM information_schema.cdc_ingests;

​
Columns in information_schema.cdc_ingests

Column NameData TypeDescription
database_nameTEXTThe database containing the CDC table.
schema_nameTEXTThe schema containing the CDC table.
table_nameTEXTThe CDC table.
stream_nameTEXTThe stream feeding the table.
engine_idTEXTThe engine running the ingest worker.
stateTEXTDerived rollup: backfilling, streaming, or error (streaming with recent failures).
phaseTEXTIngest phase: backfilling (initial snapshot) or streaming (applying the change feed).
apply_countBIGINTNumber of batches applied since the worker started.
last_commit_timeTIMESTAMPTZWhen the worker last committed a batch.
live_lag_msBIGINTMilliseconds since the worker last advanced. A steadily growing value while state is streaming signals a stalled feed.
last_errorTEXTThe most recent failure message; NULL if none.
error_countBIGINTNumber of failed ingest attempts since the worker started.

​
Examples

​
Check ingestion health

SELECT table_name, state, live_lag_ms, last_error
FROM information_schema.cdc_ingests
WHERE state = 'error' OR live_lag_ms > 60000;

​
Watch a backfill progress

SELECT table_name, phase, apply_count, last_commit_time
FROM information_schema.cdc_ingests
WHERE table_name = 'orders';