GCP BigQuery

What is BigQuery?

BigQuery is a fully managed petascale data warehouse.
It can process huge amounts of data very quickly.

BigQuery advantages:

BigQuery is a serverless managed data lake. Once you load the data, operational tasks and availability are automated.

BigQuery use cases:

  1. Big Data
  2. BI

BigQuery antipattern use cases:

Operational Database. 

 

Our BigQuery Blogs

Learn BigQuery

  1. BigQuery Demystified
  2. bigquery bq load error- “cannot determine table described”
  3. Quick Start on GCP BigQuery – 5 rules of thumb
  4. Google BigQuery Demystified
  5. BigQuery Cheat Sheet
  6. BigQuery CLI Cheat Sheet
  7. K Means Via BQ ML Demystified
  8. Parsing the last 4 days of google analytics table GA_sessions in google BigQuery
  9. what really happens when you unnest customDimentions in ga_sessions_* (hint data inaccuracy)
  10. When to use BigQuery? When not to use BigQuery?

BigQuery cost reduction

  1. GCP Cost Reduction in a nutshell
  2. what is the cheapest ways to parse GA_sessions at big query? What is the fastest way to parse GA_sessions at big query? What is the simplest way to parse GA_sessions at big query?
  3. DFP Data Transfer Files Use Case | BigQuery 93% Cost Reduction demystified
  4. How can I get BigQuery cost per query per user?

BigQuery "how to"

  1. Keep your data encrypted in BigQuery
  2. How to export data from Google Big Query into AWS S3 + EMR hive or AWS Athena
  3. AVRO and BigQuery example
  4. Big Query CTAS partitioned by Date or Int example
  5. How to debug BigQuery query failure in Airflow DAG?
  6. How can I connect BigQuery and GCP Cloud SQL ? | GCP Cloud SQL federated queries

BigQuery erorrs

  1. BigQuery Error: “too many tabledata.list bytes per second per project”
  2. How to debug “Error while reading data, error message: Failed to parse JSON: Unexpected end of string; Unexpected end of string; Expected key”?

Architectures and meetups which includes BigQuery

  1. GCP Big Data Demystified | Investing.com
  2. 80% Cost Reduction in Google Cloud BigQuery
  3. BigQuery VS Dataproc cost reduction use case
  4. Keep your data encrypted in BigQuery

Top BigQuery Videos