Turns out database clones don’t have to be so slow - select.dev/posts/snowflak…

2 weeks ago, ian.sql and JT shared their first hand experience of cutting Snowflake spend. Slides and recording from this 30-minute deep dive now available in the link below 👇 select.dev/posts/extend-t…

Pairing query design with effective clustering can dramatically improve pruning and query speeds. See how and when you should leverage this powerful Snowflake feature in our latest post from Niall select.dev/posts/introduc…

Now in private preview on SnowflakeDB, you can set up an alert that periodically performs an action under specific conditions, based on data within Snowflake.

How do you design your table to support multiple, unique access patterns? Recently uncovered a neat trick with materialized views: they can be used to automagically manage multiple versions of your table that are each clustered differently:

Full post on the different ways you can create tables with multiple cluster keys, and the pros and cons of each here: select.dev/posts/clusteri…

New dbt Labs Analytics Engineering Podcast is LIVE🎙️! Tristan Handy and I sit down with Brad Culberson from SnowflakeDB and Niall from SELECT to talk about cloud warehouse optimization. Listen for practical advise on a top of mind topic 🧠🫰 open.spotify.com/episode/2j8Djh…

Do yourself a favour and turn on npmjs.com/package/eslint… before ever starting a new react project. *goes back to crying at hook debt*