Based on your suggestion, I tried the below test case using XSMALL warehouse:alter session set use_cached_result = false;May 6May 6
Published inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake performance tips and tricks — Part 4: Stored ProcedureIn this post, I will compare each of the languages supported by Snowflake’s Stored Procedure and perform some tests to see how they differ.Apr 162Apr 162
Published inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake query performance tips and tricks - Part 3: window function optimizationThis post will walk you through an example of how to optimize a query that uses a window function with sorting but without partitioning.Dec 8, 2023Dec 8, 2023
Published inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake performance tips and tricks - Part 2: general adviceThis blog post will go through some general advice on Snowflake query performance best practices.Dec 4, 20231Dec 4, 20231
Published inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceHow to force join order for queries with CTEs in SnowflakeThis blog post will walk you through the technique on how to tell the Snowflake compiler to perform certain join orders.Oct 23, 20232Oct 23, 20232