Select sync mode and schema

• In the Select streams section, you can select how you want your data to be delivered to the Teradata destination.
• Under Select Sync Mode, you can choose between Replicate Source and Append Historical Changes. In this example, we select Replicate Source, as it keeps an up-to-date copy of the Google Sheets data in Teradata.
• Under Schema, review the columns detected from the Google Sheet.

• In this example, Airbyte detects the following columns:
  • id
  • Employee Type
  • Experience (Years)
  • Payrate (USD)
• Keep all four columns selected. Select id as the primary key, as it uniquely identifies each row in the Google Sheet.
• After selecting the sync mode and confirming the schema, click Next.