DEV Community

loading...
Cover image for GCP — Migrating Teradata to BigQuery

GCP — Migrating Teradata to BigQuery

iamvigneshc profile image Vignesh C Updated on ・1 min read
  • 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

GitHub logo 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!

Discussion (0)

pic
Editor guide