snowflake-db

2 posts tagged snowflake-db. See all tags

tagged posts

  1. Facing the SnowStorm: Part 2

    Boosting Snowflake Query Performance on High Churn Tables with the Deferred Merge Strategy

    The Adventure Continues! In this chapter we dive into our Snowflake table data partitions, and we're starting to suspect our good friend MERGE might have something to do with it. After some trial and error (and a few too many hairs lost), we managed to boost query speed by 90% (!!!). Read on to find out how!

    15 min read

  2. Facing the SnowStorm: Part 1

    Why Snowflake Queries Slow Down on High Churn Tables and How We Fixed It

    MERGE operations in Snowflake can really slow things down, especially when you're dealing with high churn tables that end up all fragmented. In part 1 of this 2-part series, we’re diving into the problem and take you on a tale of woe, despair, lots of coffee and some glimmering nuggets of wisdom in the land of Snowflakes.

    15 min read