Moving from Teradata to BigQuery? Automate the process
Moving from Teradata to BigQuery? Automate the process! The release of Teradata - a technical challenge Teradata is an “Appliance” chosen by countless players. Teradata's specialization in Datawarehousing / Analytics has enabled the implementation of solutions with exceptional computing capacities and strong scalability. But most of Teradata's historical users are now in the process of switching to the Cloud. One of our clients decided to switch its Teradata assets to Google Cloud Platform (BigQuery), as well as to migrate a certain number of data visualization technologies (SAP BO, Power BI). We share with you the methodology implemented as part of this migration. Some key indicators concerning the platform to be migrated Asset data: 400,000 data “containers”; 270,000 tables; 11,000 files. Active scripts: 122,000 views; 1,200 macros; 500 BTEQ injection processes; 600 BO universes; 100,000 web reports; 30,000 data manipulation processes distributed across 450