Eric Lin – Medium

Eric Lin

Based on your suggestion, I tried the below test case using XSMALL warehouse:

alter session set use_cached_result = false;

May 6, 2024

May 6, 2024

Published in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Snowflake performance tips and tricks — Part 4: Stored Procedure

In 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 16, 2024

Snowflake performance tips and tricks — Part 4: Stored Procedure

Apr 16, 2024

Published in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Snowflake query performance tips and tricks - Part 3: window function optimization

This 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, 2023

Snowflake query performance tips and tricks - Part 3: window function optimization

Dec 8, 2023

Published in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Snowflake performance tips and tricks - Part 2: general advice

This blog post will go through some general advice on Snowflake query performance best practices.

Dec 4, 2023

Snowflake performance tips and tricks - Part 2: general advice

Dec 4, 2023

Published in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

How to force join order for queries with CTEs in Snowflake

This blog post will walk you through the technique on how to tell the Snowflake compiler to perform certain join orders.

Oct 23, 2023

How to force join order for queries with CTEs in Snowflake

Oct 23, 2023

Eric Lin

Eric Lin

Principal Technical Support Evangelist specialising in Snowflake query performance troubleshooting. Connect with me: https://www.linkedin.com/in/ericlin05

Following

Help
Status
About
Careers
Press
Blog
Privacy
Rules
Terms
Text to speech