BigQuery Snippets

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 :)

Comments