Google Cloud: Exploring a BigQuery Public Dataset
Overview Storing and querying massive datasets can be time consuming and expensive without the right hardware and infrastructure. BigQuery is an enterprise data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google’s infrastructure. Simply move your data into BigQuery and let us handle the hard work. You can control access […]
Google Cloud: VPC Flow Logs – Analyzing Network Traffic
Overview In this lab, we will learn how to configure a network to record traffic to and from an Apache web server using VPC Flow Logs. You will then export the logs to BigQuery for analysis. There are multiple use cases for VPC Flow Logs. For example, you might use VPC Flow Logs to determine […]
Google Cloud: Viewing Sample Billing Data with BigQuery
Introduction Part of working with billing data is working with data exported to BigQuery. In this lab, we are going to view sample billing exports maintained by Google, and conduct queries against a public dataset of billing exports. This will be a fun lab in that we can play around with SQL queries in BigQuery […]
Google Cloud: Introduction to BigQuery
What is BigQuery? BigQuery is a fully managed big data tool for companies who need a cloud-based interactive query service for massive datasets. BigQuery is not a database, it’s a query service. BigQuery supports SQL queries, which makes it quite user-friendly. It can be accessed from Console, CLI, or using SDK. You can query billions […]