BigQuery Snippets

A collection of BigQuery snippets for fun and non-profit

BigQuery: Monitor Query Costs via INFORMATION_SCHEMA

Published at 2020-06-22 10:40:00 by Pascal Landau

All Google BigQuery queries including costs (via total_bytes_processed) are automatically stored in and can be monitored via INFORMATION_SCHEMA views

BigQuery: Calculate the MEDIAN in BigQuery

Published at 2020-06-20 12:00:00 by Pascal Landau

Calculating the MEDIAN with Google BigQuery is possible by using the PERCENTILE_CONT(x, 0.5) function

BigQuery: Use expression subqueries for querying nested and repeated fields

Published at 2020-05-29 14:00:00 by Pascal Landau

Using expression subqueries to query nested nd repeated fields in Google BigQuery

BigQuery: Use "temporary tables" via WITH (named subqueries)

Published at 2020-05-29 13:00:00 by Pascal Landau

Using "temporary tables" via WITH (named subqueries) in Google BigQuery

BigQuery: Using Variables in BigQuery

Published at 2020-05-29 12:00:00 by Pascal Landau

Variables in Google BigQuery can be declared with the DECLARE statement and then used directly in a query

BigQuery: Using multiple cursors / rectangular selection in BigQuery UI

Published at 2019-12-19 18:00:00 by Pascal Landau

The BigQuery UI provides multiple hotkeys, amongst other for using multiple cursors (column / rectangular selection) via ALT + left-mouse-drag

BigQuery: Convert timestamp/date/datetime to different timezone

Published at 2018-04-08 18:00:00 by Pascal Landau

Converting a timestamp/date/datetime to a different timezone with Google BigQuery

BigQuery: Extract URL parameters as ARRAY

Published at 2018-04-08 12:00:00 by Pascal Landau

Extracting parameters in the query of a URL as ARRAY with Google BigQuery

Wanna stay in touch?

Since you ended up on this blog, chances are pretty high that you're into Software Development (probably PHP, Laravel, Docker or Google Big Query) and I'm a big fan of feedback and networking.

So - if you'd like to stay in touch, feel free to shoot me an email with a couple of words about yourself and/or connect with me on LinkedIn or Twitter or simply subscribe to my RSS feed or go the crazy route and subscribe via mail and don't forget to leave a comment :)

Subscribe to posts via mail

We use Mailchimp as our newsletter provider. By clicking subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp's privacy practices here.
Waving bear