How to migrate a data warehouse to BigQuery

Has your data team outgrown its on-premise traditional data warehouse? Are you looking for a system to store data that is secure, scalable, and cost effective? In this episode of Architecting with Google Cloud, Priyanka Vergadia speaks with Gary Morreale, the Director of Data Services from Independence Blue Cross about how his team migrated from Terradata to Bigquery on Google Cloud Platform. Listen as Gary Morreale discusses his team’s giant undertaking on migrating dataware to BigQuery.

Chapters:
0:00 - Intro
1:00 - What are the challenges with an on-premises Data Warehouse
1:48 - Data warehouse migration strategy for Terabytes of data
2:42 - Data warehouse migration architecture
4:50 - Architecture for data analytics: how do data science teams use the data
6:40 - What is beyond data warehouse migration
7:20 - Wrap Up

#ArchitectingWithGoogleCloud

product: Cloud - General; fullname: Priyanka Vergadia;

[shubhampnp]

As a cost effective solution, didn't we should store data in hive-gs bucket for stage and core layer data and final data should be pushed to bigquery for information layer. Please suggest

[manishzope]

Hi Priyanka! Thank you very much for covering DW migration. Can you please cover the client story along with architecture for RDBMS migration?

[kamaldeepsingh]

I am wandering how audio quality is so great despite microphone on top :)

[prasenize]

Hi Priyanka first of all thanks for the video, Can we talk about moving AB initio/ETL jobs from on premise to Cloud, with some example in details, That will be really helpful

[bidyadharbarik]

HI Priyanka! Thank you very much for DW migration video . Could you please cover how to copy data from on premise to GCS bucket ?

[shivampandey]

how to migrate data directly from oracle to bq?

[valikonen]

We want to see real examples. Make an app with, java/node etc with front in react/angular add a DB and play different scenarios. It's full internet of GC theory...but no real example.

[nileshk]

Thanks. How can ETL written in tools like OTIC be migrated to BigQuery?

[Suresh_k.]

Awaiting Video is,
how improving powerful security to safe lot of informations...

[ssiddhantjha]

Looking to be on the flip side one day