- In the
Configure connectionsection, provide a name for your connection. You can keep the default name or update it based on your use case. - Select the
Schedule type. In this example, we keep it asScheduled. - Select the
Replication frequency. In this example, we keep it asEvery 24 hours. - Under
Destination Namespace, selectDestination-defined. In this example, the destination is Teradata, so Airbyte uses the default schemagsheet_airbyte_tdthat we defined while configuring the Teradata destination.
Note
We use the term "schema", as it is the term used by Airbyte. In a Teradata context, the equivalent term is "database".
-
The stream name is based on the name of the spreadsheet in the source. In this example, the stream name is
sample_employee_payrate. Since we are using the single spreadsheet connector, it supports one stream for the selected spreadsheet. -
Review the configuration and click
Finish & Syncto create the connection and start syncing data from Google Sheets to Teradata.