BigQuery for Data Warehousing: Managed Data Analysis in the Google Cloud

© Mark Mucchetti 2020

M. MucchettiBigQuery for Data Warehousinghttps://doi.org/10.1007/978-1-4842-6186-6_5

5. Loading Data into the Warehouse

Mark Mucchetti¹ 

(1)

Santa Monica, CA, USA

 

Now that you have a data warehouse up and running, the next step is to develop methods for populating it. In this and the following chapter, we’ll go over the different methods you can use to set up paths for your data to load into BigQuery, depending on your needs and constraints. We’ll start with the tried-and-true method, which is setting up loading and migration to populate the warehouse.

Another reason this set of strategies might work for you is if you already have a data infrastructure that uses traditional SQL models or even something like Microsoft Excel or ...