Skip to main content

Striim for BigQuery Documentation

When target tables already exist

Select what you want Striim to do when some of the tables selected to be synced already exist in the target:

  • Proceed without the existing tables: Omit both source and target tables from the pipeline. Do not write any data from the source table to the target. (If all the tables already exist in the target, this option will not appear.)

  • Add prefix and create new tables: Do not write to the existing target table. Instead, create a target table of the same name, but with a prefix added to distinguish it from the existing table.

  • Drop and re-create the existing tables: Drop the existing target tables and any data they contain, create new target tables, and perform initial sync with the source tables. Choose this option if you were unsatisfied with an initial sync and are starting over.

  • Use the existing tables: Retain the target table and its data, and add additional data from the source.

Review the impact of the action to be taken. To proceed enter yes and click Confirm and continue.