Validate the data in Teradata Trial

Next, you can go to the Teradata Trial and run a Jupyter notebook to verify if the database gsheet_airbyte_td, stream table, and data are available in Teradata.

Notebooks in Teradata Trial are configured to run Teradata SQL queries.

Connect to the local Teradata environment.

%connect local 

Run the following query to verify that the database and table were created in Teradata.

SELECT  DatabaseName, TableName, CreateTimeStamp, LastAlterTimeStamp
FROM    DBC.TablesV
WHERE   DatabaseName = 'gsheet_airbyte_td'
ORDER BY    TableName;

Switch to the gsheet_airbyte_td database.

DATABASE gsheet_airbyte_td; 

Query the synced table.

SELECT * FROM sample_employee_payrate;  

In this example, the table sample_employee_payrate is created in the gsheet_airbyte_td database. The table contains the data synced from the Google Sheet along with Airbyte metadata columns.

Airbyte may convert source column names into SQL-friendly column names in the destination. In this example, the Google Sheet columns are synced to Teradata as id, Employee__Type, Experience__Years_, and Payrate__USD_. Airbyte also adds metadata columns such as _airbyte_raw_id, _airbyte_extracted_at, _airbyte_generation_id, and _airbyte_meta.

You should see 9 rows in the Teradata table, the same as the source Google Sheet.