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

# Backfill pipeline tables

> Triggers a backfill for specified tables in the pipeline. Supports options for pre-backfill behavior (drop, truncate, or do nothing) and schema/database filtering.



## OpenAPI

````yaml https://raw.githubusercontent.com/artie-labs/artie-api-spec/refs/heads/master/openapi.yaml post /pipelines/{uuid}/backfill
openapi: 3.1.0
info:
  description: External API endpoints for Artie
  title: Artie API
  version: v1.0.62
servers:
  - url: https://api.artie.com
security:
  - ApiKey: []
paths:
  /pipelines/{uuid}/backfill:
    post:
      tags:
        - Pipelines
      summary: Backfill pipeline tables
      description: >-
        Triggers a backfill for specified tables in the pipeline. Supports
        options for pre-backfill behavior (drop, truncate, or do nothing) and
        schema/database filtering.
      operationId: pipeline_backfill_tables
      parameters:
        - in: path
          name: uuid
          required: true
          schema:
            type: string
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/RouterPipelineBackfillRequest'
      responses:
        '204':
          description: No Content
        '400':
          description: Bad Request
        '403':
          description: Forbidden
        '500':
          description: Internal Server Error
components:
  schemas:
    RouterPipelineBackfillRequest:
      properties:
        backfillFromDatabases:
          description: >-
            Optional source databases to backfill for regular-table backfills.
            Requires beforeBackfill to be the empty-string do-nothing option.
          items:
            type: string
          type:
            - array
            - 'null'
        backfillFromSchemas:
          description: >-
            Optional source schemas to backfill for regular-table backfills.
            Requires beforeBackfill to be the empty-string do-nothing option.
          items:
            type: string
          type:
            - array
            - 'null'
        beforeBackfill:
          description: >-
            Destination handling before the backfill: empty string leaves
            existing data unchanged, truncate_table truncates the destination
            table, and drop_table drops it.
          enum:
            - ''
            - truncate_table
            - drop_table
          type: string
        historyMode:
          description: >-
            When true, backfill the selected history tables instead of the
            regular tables.
          type: boolean
        tableUUIDs:
          description: UUIDs of the regular or history tables to backfill.
          items:
            format: uuid
            type: string
          type: array
      required:
        - tableUUIDs
        - beforeBackfill
      type: object
  securitySchemes:
    ApiKey:
      description: API key passed as a Bearer token in the Authorization header.
      scheme: bearer
      type: http

````