Use BigQuery Data Transfer Service by using the Java Database Connectivity (JDBC) driver with FastExport connection.

Create a Teradata Parallel Transporter (TPT) export script to export the historical data, and import to BigQuery by using the bq command-line tool.

Use BigQuery Data Transfer Service with the Teradata Parallel Transporter (TPT) tbuild utility.

Create a script to export the historical data, and upload in batches to Cloud Storage. Set up a BigQuery Data Transfer Service instance from Cloud Storage to BigQuery.