Inspired from this Pinterest

A quick workaround to avoid people doing "SELECT *" on your tables (which I consider harmful, see stackoverflow) in BigQuery is the following:

1. Create a policy tag in the policy tags page. I create it under a new taxonomy "sql_rules", and call it "no_select_star"
2. Once created, in the policy tag taxonomy page I enable the "enforce access control" option. If you need users to bypass this policy (e.g. needs to run bigquery copy operations) you can add the "fine graded reader" role to the principal associated with the policy tag in the same page.
3. In the table you want to protect, add a dummy column (I call it "do_not_select_star") and assign it the policy tag
4. Done! From now on, SELECT * will throw an error.

For more info see Google Cloud docs

I started taking an amateaur illustration class, yesterday we learned a bit about watercolors so I decided to give it a go drawing Pita, my dog.

It's messy but I like it.

I recently had to set up a new Mac for programming. I took the opportunity to do what a colleague suggested me to do a long time ago: ditch gpg, gpg-agent, and such in favor of 1Password. This setup is much simpler and I believe more secure than what I was doing before.

Just a quick update: I know I haven't being posting in a while, between end-of-year work, holidays, flu, and back to work I didn't have much time. Will go back to posting some tech stuff and drawing stuff soon.