Warehousing with Google's Big Query

Описание: Intro to Big Query
Chapters:


Big query is Google’s Enterprise Data Warehouse
Designed to help you INGEST, STORE, ANALYZE, VISUALIZE Data
Multiple ways to ingest data; Using -
Batch
Streaming data
It’s a Fully Managed Serverless Data Warehouse, so the infrastructure is being taken care of, so we mainly have to focus only on analyzing data
Petabyte scale
Supports Standard SQL that is ANSI compliant

Interacting with Big query becomes easy, with SQL we can use Big query console or command line tools or even use API with client libraries on you choice of language
Big query Console
Command Line
API with client libraries

For viz - big query integrates with several bi tools such as tableau, looker, google data studio to convert complex data into compelling stories
It has an interesting pricing model, You pay for-
Data storage
Streaming inserts
Querying - pay as you go
There are two pricing models which we will discuss later in detail
Pay as you go
Flat rate

Big Query - Exploring Ecommerce Dataset

About Dataset

Google Analytics logs for Google ecommerce website into BigQuery

First outlook of data

Expand **ecommerce**.
Click **all_sessions_raw**.
Check out table metadata and schema


#gcp #bigquery #bigdata #datawarehouse #dataanalytics #bigdata #machinelearning #ai