Skip to main content
FULL_TABLE rereads all visible rows for the selected source stream. Use it for first-run validation, small reference tables, controlled complete refreshes, or confirming a published SQL model and destination contract.

​
Configure Full table

  1. Open the pipeline Source tab.
  2. Discover the catalog.
  3. Enable the stream.
  4. Choose Full table in that stream’s Sync mode column.
  5. Preview the stream and click Save stream settings.
  6. Complete destination and transformation setup.
  7. Validate in Overview and click Run all.

​
Scheduling

Schedules are configured at pipeline level in Settings. A scheduled pipeline with Full table streams rereads those complete streams each time, so review source size and API limits before enabling an interval or UTC cron expression.

​
Run behavior

  • source rows are staged in temporary storage;
  • published destination-owned SQL revisions run against staged relations;
  • assigned final destination tables must exist;
  • Upsert keys control matching; and
  • temporary staging is cleaned up after checkpoint extraction.