Blog
Setting up SSH in 1password for both authentication and git signing
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.
BigQuery Editions vs On Demand
These are some notes on the tradeoffs and best practices between On Demand pricing vs Editions pricing.
How to quickly profile python imports and runtime
A small TIL about Python profiling.
BigQuery performance best practice: use semi joins when possible
SQL is an amazing language, it lets you declaratively say what you want, and the engine figures out for you the best way to return it to you. Or should I say, it figures out the best way to return it to you given the information it has and the capabilities of the engine itself.
In this post, we鈥檒l discuss a performance optimization technique for BigQuery (also other advanced enough Enteprise Data Warehouses and databases support SEMI JOINS, but I'll focus on BigQuery since it's the one I use the most these days): using semi joins.