Skip to content
Menu
Assured Info
  • Home
  • Python for automation
Assured Info

Use of structs, arrays, unnest and crossjoin in BigQuery

Posted on July 16, 2022July 29, 2022

These are some of the new concepts introduced by Google query datasets using Google tool BigQuery.

BigQuery supports large JOINs, and JOIN performance is good. However, BigQuery is a columnar datastore, and maximum performance is achieved on denormalized datasets.

It will help to improve the query of performance:
– By avoiding the use of joining two tables

These are some of the new concepts introduced by Google query datasets using Google tool BigQuery.

  • Kibana – Open Source Visualisation
  • Use of structs, arrays, unnest and crossjoin in BigQuery
  • LaTeX for better documentation
  • Pandas
  • Python for automation
©2023 Assured Info | WordPress Theme by Superbthemes.com