Tags: #sql

How to read the tea leaves: Identifying exploding joins, spilling to remote, and partition scanning issues.

Control flow in SQL used to be a pain. Snowflake Scripting makes it native. How to write loops, exception handlers, and cursors.

Explore the evolving landscape of SQL and NoSQL databases, and discover how Snowflake bridges structured and semi-structured data management with a modern, cloud-native architecture.

A guide to Snowflake Event Tables—exploring what they are, how they work, and how to set them up and use them effectively for logging and observability in Snowflake environments.

Dive into the world of Snowflake User Defined Functions (UDFs) and discover how to write reusable, modular logic for your data workflows. This guide explores the types of UDFs, practical implementation strategies, and engineering-focused use cases to help you extend Snowflake’s native capabilities with custom logic.

An in-depth exploration of Snowflake Streams, detailing their role in Change Data Capture (CDC), implementation strategies, practical use cases, and best practices for developers and data engineers.

This article provides a comprehensive overview of Snowflake Tasks—what they are, how they work, and how developers can use them to automate data workflows. Learn to build efficient pipelines with best practices and real-world SQL examples.

Explore fundamental SQL join operations in Snowflake, including flipped joins, logical join types, and leveraging the Search Optimization Service (SOS) to improve your query performance and efficiency.