Eight Months Later, I’m Happy I was Laid Off
I’d really like to thank Shopify for laying me off back in May. I am so much happier in this role, and already starting to feel competent, only six months in. Don’t get me wrong, I have a ton to…
Category Snowflake
Signing Up For and Using a Free Trial of Snowflake
There are plenty of guides to setting up a trial of Snowflake online, but as part of my “Roll for Database” series, I want to have the basics of setting up a free trial of any platform I work with,…
Comparing Index Access and Partition Elimination
The revelation that Snowflake doesn’t (currently) use b-tree indexes may be shocking to some who are used to a more traditional rdbms environment. It is interesting, therefore, to walk through some of the generalities of the methodologies to understand why…
No Indexes?
I’ve spent 20 years of my career working with IBM Db2, then a year working with MySQL, and now my database platform of choice is Snowflake. When I was moving from Db2 to MySQL, there were a number of “WTH?”…
Happy Surprises in Snowflake
As I’ve been learning about Snowflake, at least once a week, I find small things in the SQL or feature set that just make me happy. I really feel like Snowflake is meant for someone who loves SQL, but also…