Skip to content

The Digital Skye

Where I share my stories about business, data and anything in between

  • Infographics
  • About Me

Tag: Google BigQuery

A Simple Way to Query Table Metadata in Google BigQuery

Effortless approach to determine what is in the BigQuery dataset and which tables are useful for analysis with INFORMATION_SCHEMA and TABLES

Skye Tran Google BigQuery Leave a comment February 2, 2021February 2, 2021 5 Minutes

Explore Arrays and Structs for Better Query Performance in Google BigQuery

Stepping up your SQL query game with these 2 advanced SQL concepts is easier than you think. Don’t miss out!

Skye Tran Google BigQuery Leave a comment January 21, 2021January 21, 2021 9 Minutes

3 Useful SQL Features You Should Start Using in 2021

It's time to take your queries up a notch with Date Partition, Analytic Window Functions and WITH clause!

Skye Tran Google BigQuery Leave a comment January 19, 2021January 19, 2021 7 Minutes

Counting unique elements faster in Google BigQuery with HyperLogLog

With HyperLogLog algorithm, we trade off some accuracy to get the job done faster. But how much faster and at the expense of what level of accuracy?

Skye Tran Google BigQuery 2 Comments January 14, 2021January 18, 2021 3 Minutes

Copyright © 2020 Skye Tran

Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×