> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Use this reference to monitor the state, progress, and errors of CDC table ingestion through the information schema.

# CDC ingests

<Warning>
  **Private Preview Feature**

  This feature is currently in private preview. Contact [support@firebolt.io](mailto:support@firebolt.io) to request early access.
</Warning>

The `information_schema.cdc_ingests` view reports the live state of [CDC table](/guides/change-data-capture/cdc-tables) 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.

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
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 Name        | Data Type   | Description                                                                                                                |
| :----------------- | :---------- | :------------------------------------------------------------------------------------------------------------------------- |
| database\_name     | TEXT        | The database containing the CDC table.                                                                                     |
| schema\_name       | TEXT        | The schema containing the CDC table.                                                                                       |
| table\_name        | TEXT        | The CDC table.                                                                                                             |
| stream\_name       | TEXT        | The stream feeding the table.                                                                                              |
| engine\_id         | TEXT        | The engine running the ingest worker.                                                                                      |
| state              | TEXT        | Derived rollup: `backfilling`, `streaming`, or `error` (streaming with recent failures).                                   |
| phase              | TEXT        | Ingest phase: `backfilling` (initial snapshot) or `streaming` (applying the change feed).                                  |
| apply\_count       | BIGINT      | Number of batches applied since the worker started.                                                                        |
| last\_commit\_time | TIMESTAMPTZ | When the worker last committed a batch.                                                                                    |
| live\_lag\_ms      | BIGINT      | Milliseconds since the worker last advanced. A steadily growing value while `state` is `streaming` signals a stalled feed. |
| last\_error        | TEXT        | The most recent failure message; `NULL` if none.                                                                           |
| error\_count       | BIGINT      | Number of failed ingest attempts since the worker started.                                                                 |

## Examples

### Check ingestion health

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
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

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SELECT table_name, phase, apply_count, last_commit_time
FROM information_schema.cdc_ingests
WHERE table_name = 'orders';
```

## Related

* [CDC tables](/guides/change-data-capture/cdc-tables): lifecycle and monitoring.
* [CREATE CDC TABLE](/reference-sql/commands/data-definition/create-cdc-table): DDL reference, including `ALTER CDC TABLE RESUME | SUSPEND | CASCADE`.
* [`information_schema.streams`](/reference-sql/information-schema/streams): stream metadata.