Introduction

This document explains how to update table target schemas in Reactor by syncing with your data warehouse destination. Updating schemas ensures that output previews on the Mapping canvas reflect the latest destination schema.

How to Update Table Target Schemas by Syncing With Your Destination

BigQuery and Snowflake

1. Navigate to the Destinations page in Reactor.
2. Select a Destination from the left sidebar to open that destination's settings.
3. Select the Sync existing Table Targets with Datawarehouse button.
4. Reactor will compare the schema for each table target with the corresponding table's schema in the data warehouse:
   1. If no changes are detected: select Close to exit the wizard.
   2. If changes are detected:
      1. A list of targets and their corresponding tables will be displayed.
      2. Select Update Target Schema to complete the sync process.

Demonstration

Below is a demonstration of the destination sync process using a BigQuery destination target: