Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Introduction to SQL in BigQuery
Data Types
Questions
-
Can you set Vim keybindings for editors?
-
how to connect to a BigQuery …
GCP Compute Engine VM Instances
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
GCP¶
GCP c2 and c3 VMs are good choices according to performance per price. It's even cheaper than customized VM types with reduced memories! GCP c2 VMs are compute optimized and are ideal for CPU intensive workloads. Note that GCP c2 spot VMs are even cheaper than AWS t2.nano VMs if you can stand your VM being preempted.
Tips on GCP
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Notice that lots of services can be used for free (with monthly limits). For more details, please refer to GCP Free Tier Usage Limits .
https://cloud.google …
Comparison of Popular Cloud Platforms
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
References
Top 10 Cloud Provider Comparison 2023: VM Performance / Price
Tips on ZetaSQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
ZetaSQL is a customized SQL dialect, along with parser and analyzer, that Google uses for products like BigQuery and Spanner.
unnest
cross join if an implicit join is used. Notice that …