- Create a Teradata source system running on a Compute Engine instance
- Prepare the Teradata source system for the schema and data transfer
- Configure the schema and data transfer service
- Migrate the schema and data from Teradata to BigQuery
- Translate Teradata SQL queries into compliant BigQuery Standard SQL
More Details:
https://iamvigneshc.medium.com/gcp-migrating-teradata-to-bigquery-a655c44b2dbd
IamVigneshC
/
GCP-Migrating-Teradata-to-BigQuery
Create a Teradata source system running on a Compute Engine instance Prepare the Teradata source system for the schema and data transfer Configure the schema and data transfer service Migrate the schema and data from Teradata to BigQuery Translate Teradata SQL queries into compliant BigQuery Standard SQL
Migrating-Teradata-to-BigQuery
- Create a Teradata source system running on a Compute Engine instance
- Prepare the Teradata source system for the schema and data transfer
- Configure the schema and data transfer service
- Migrate the schema and data from Teradata to BigQuery
- Translate Teradata SQL queries into compliant BigQuery Standard SQL
Creating the Teradata VM and downloading Teradata Express
Enable the required Cloud APIs:
The following APIs are required for the demo: Compute Engine, Cloud Storage, Cloud Storage JSON, Pub/Sub, BigQuery, BigQuery Data Transfer Service, and Cloud Build.
Check which APIs are enabled for the project
gcloud services list --enabled
Enable the following APIs:
Required for the data transfer service
gcloud services enable bigquery-json.googleapis.com
gcloud services enable storage-api.googleapis.com
gcloud services enable storage-component.googleapis.com
gcloud services enable pubsub.googleapis.com
gcloud services enable bigquerydatatransfer.googleapis.com
Required to run Teradata on a GCE instance
gcloud services enable compute.googleapis.com
Create a service account for the BigQuery Data Transfer Service This…
PS: Sorry, couldn't repost here since there are some incompatible MD codes. Thank you!
Top comments (0)