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

# Create backfill

Creates a new backfill for a specific sink. The backfill will be created in the `active` state.

## Request fields

<ParamField path="sink_id_or_name" type="string" required>
  The name or ID of the sink
</ParamField>

<ParamField body="table" type="string">
  The source table for the backfill in the format `schema.table` or `table` (schema defaults to `public`)

  Must specify this parameter if the sink is configured to stream changes from all tables in a schema.
</ParamField>

## Response fields

<ResponseField name="id" type="string">
  The unique identifier of the backfill
</ResponseField>

<ResponseField name="state" type="string">
  The current state of the backfill (active, completed, cancelled)
</ResponseField>

<ResponseField name="table" type="string">
  The name of the table that was backfilled
</ResponseField>

<ResponseField name="inserted_at" type="string">
  The timestamp when the backfill was created
</ResponseField>

<ResponseField name="sink_consumer" type="string">
  The name of the sink consumer
</ResponseField>

<ResponseField name="updated_at" type="string">
  The timestamp when the backfill was last updated
</ResponseField>

<ResponseField name="canceled_at" type="string">
  The timestamp when the backfill was cancelled (null if not cancelled)
</ResponseField>

<ResponseField name="completed_at" type="string">
  The timestamp when the backfill was completed (null if not completed)
</ResponseField>

<ResponseField name="rows_ingested_count" type="integer">
  The number of rows ingested by the backfill
</ResponseField>

<ResponseField name="rows_initial_count" type="integer">
  The initial number of rows to be processed
</ResponseField>

<ResponseField name="rows_processed_count" type="integer">
  The number of rows processed by the backfill
</ResponseField>

<ResponseField name="sort_column" type="string">
  The column used for sorting the backfill data
</ResponseField>

<RequestExample>
  ```bash cURL theme={null}
  curl -X POST "https://api.sequinstream.com/api/sinks/kafka-ids/backfills" \
    -H "Authorization: Bearer YOUR_API_TOKEN"
  ```

  ```json Response theme={null}
  {
    "id": "e0c918bb-12a2-4810-94a3-387cd672a478",
    "state": "active",
    "inserted_at": "2025-04-09T04:06:23Z",
    "sink_consumer": "kafka-ids",
    "updated_at": "2025-04-09T04:06:23Z",
    "canceled_at": null,
    "completed_at": null,
    "rows_ingested_count": 0,
    "rows_initial_count": 0,
    "rows_processed_count": 0,
    "sort_column": "benchmark_records"
  }
  ```
</RequestExample>