All Google BigQuery queries including costs (via total_bytes_processed) are automatically stored in and can be monitored via INFORMATION_SCHEMA views
Calculating the MEDIAN with Google BigQuery is possible by using the PERCENTILE_CONT(x, 0.5) function
Using expression subqueries to query nested nd repeated fields in Google BigQuery
Using "temporary tables" via WITH (named subqueries) in Google BigQuery
Variables in Google BigQuery can be declared with the DECLARE statement and then used directly in a query
The BigQuery UI provides multiple hotkeys, amongst other for using multiple cursors (column / rectangular selection) via ALT + left-mouse-drag
Converting a timestamp/date/datetime to a different timezone with Google BigQuery
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 :)