From the course: Learning BigQuery
Join today to access over 25,600 courses taught by industry experts.
Data sources and queries in BigQuery - BigQuery Tutorial
From the course: Learning BigQuery
Data sources and queries in BigQuery
- [Narrator] Having explored the architecture of BigQuery and how data can be arranged. Let's get a little more low-level and see what it takes to actually work with BigQuery. As a user of this data warehouse service, two of the primary tasks you'll be involved with are loading data into BigQuery, and then querying that data. To understand the different phases in these two tasks. Let's take a look at this diagram, which includes various sub-tasks and the components of the BigQuery architecture that are involved in each process. Towards the left, we have the data ingestion phase. This is where streaming data or batch data is loaded into BigQuery and then stored on the distributed storage system. You'll recall that in BigQuery, this is Colossus. At this point, the data is ready to be queried. And this is where we make use of the compute resources, which includes the Dremel query engine. Note that the storage and compute…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.