Skip to main content
POST
Create backfill
Stages data from a Snowflake table for the given window, then streams it to one or more destinations. The job progresses through staging → transporting → completed (or failed / cancelled).
We currently only support Base tables (e.g. base.assets.erc20_token_transfers). Contact support@allium.so to request support for additional tables.
Response:
Use job_id to poll job status via List backfills or to cancel via Cancel backfill.
Request body:

backfill_window

start is inclusive, end is exclusive, and start must be less than end. Backfill by block timestamp. Set partition_key to "block_timestamp".

filter (optional)

Translates to WHERE column IN (values) on the Snowflake COPY INTO query.

destinations

Uses the same sink types as pipelines. See the Sinks reference.