Loading and Transforming Data

In the previous chapters, we introduced BigQuery and some of its foundational features. We introduced best practices and described the design and organization of resources, enabling you to understand the service. We also began defining different approaches for exploring data in BigQuery and went over the iterative process of exploration as a data analyst. Now that much of the foundational concepts have been covered, in this chapter, we will shift to the concepts and practices around loading and transforming data in BigQuery.

Loading and transforming data are critical steps in the data analysis process. These steps allow organizations to store data efficiently to begin leveraging data for insights and decision-making. In this chapter, we will explore the various techniques and best practices for loading data into BigQuery, including batch loading, streaming data, and data connections from external sources. Additionally, we will delve into the tools and...