This is a list of time-saving, cost-saving and life-saving SQL query hacks you need to know if you consider yourself an advanced BigQuery user.

Select all columns by excluding only some of them

When you need to select all the columns in the table but a couple of them you can use the EXCEPT keyword to do so:


I was very pleased to exchange and share some thoughts with Sotiris Kyriakidis from the Greek news agency “Praktoreio” on how big data can help the current battle against the Coronavirus (Covid-19). It’s the first pandemic (at least in my lifetime), where data scientists or just a data enthusiast can…

Panagiotis Tzamtzis

Panagiotis (pronounced Panayotis) is a passionate G(r)eek with experience in digital analytics projects and website implementation.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store