all AI news
A Definitive Guide to Using BigQuery Efficiently
Towards Data Science - Medium towardsdatascience.com
Make the most out of your BigQuery usage, burn data rather than money to create real value with some practical techniques.
· 📝 Introduction
· 💎 BigQuery basics and understanding costs
∘ Storage
∘ Compute
· 📐 Data modeling
∘ Data types
∘ The shift towards de-normalization
∘ Partitioning
∘ Clustering
∘ Nested repeated columns
∘ Indexing
∘ Physical Bytes Storage Billing
∘ Join optimizations with primary keys and foreign keys
· ⚙️ Data operations
∘ Copy data / tables …
basics bigquery clustering compute costs data data engineering data modeling deep-dives google cloud platform guide introduction modeling money normalization partitioning practical shift sql storage types understanding usage value