BigQuery, part of the
Google Cloud Platform

If you're not familiar with it, BigQuery is an indispensable tool in a Data Warehouse. When you are responsible for databases which grow by 10's of gigs of data per day, the traditional relational database best practices are thrown out the window.

I recently posted about my personal list of best practices in a Hacker News thread, but I want to repeat and expand on that here, so that hopefully it's easier for someone to find and benefit from.

Overview: How is BigQuery different from traditional, relational databases?

Both can have relational data. Both use SQL. There is a lot of overlap, to be sure, so I will focus on the biggest difference, and that is that BigQuery does not use indexes.