Welcome!
data-flakes.dev/ is your go-to source for all things Snowflake. We cover new features, best practices, and expert opinions to help you make the most of the Snowflake platform.
Discover the latest updates, explore in-depth guides, and read our opinion pieces to stay ahead with Snowflake. Check out our README for tutorials, code and more!
Featured Posts
Featured Articles RSS FeedSnowflake User Defined Functions (UDFs) - These are Powerful
Published: at 10:00 AMDive 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.
Let's Talk Snowflake Streams and Change Data Capture
Published: at 10:00 AMAn 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.
Automating Data Workflows with Ease, with Snowflake Tasks
Published: at 10:00 AMThis 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.
Understanding Basic Joins in Snowflake
Published: at 10:00 AMExplore 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.
Monitoring Individual Table Storage in Snowflake
Published: at 10:00 AMLearn about the three main options for monitoring individual table storage in Snowflake, including the SHOW TABLES command, Information Schema, and Account Usage Schema.
A Quick Overview of Dynamic Data Masking in Snowflake
Published: at 02:00 PMA brief look into Dynamic Data Masking (DDM) in Snowflake, covering its core functionality, benefits, and role-based access control for protecting sensitive data, like email.
Understanding Snowflakes Data Lifecycle Operations
Published: at 10:00 AMExplore how Snowflake supports the full lifecycle of data with standard SELECT, DDL, and DML operations, from organizing and storing data to querying, working with, and removing data.
Monitoring and Managing Your Snowflake Account with Account Usage and Information Schema
Published: at 12:00 PMExplore how Snowflake's Account Usage views and Information Schema enable effective monitoring and management of your account, ensuring optimised performance and resource allocation.
Understanding the Difference Between Data Masking and Row-Level Security in Snowflake
Published: at 02:00 PMAn overview of Data Masking and Row-Level Security in Snowflake, outlining their core differences, use cases, and how they work to protect sensitive data at different levels.
An Overview of Snowflakes Data Cloud
Published: at 10:00 AMDiscover the advanced features and architecture of Snowflake's Data Cloud, a fully managed data platform designed for modern data storage, processing, and analytics.
Loading Data into Snowflake - Methods and Options
Published: at 10:00 AMExplore the various methods available to load data into Snowflake, including external and internal stages, bulk and continuous loading, simple transformations, and more.
Recent Posts
Understanding The Snowflake Open Catalog - Empowering Interoperable Data Management
Published: at 10:00 AMExplore the Snowflake Open Catalog, previously known as Polaris, and learn how it facilitates seamless data interoperability across various platforms. This article provides a comprehensive guide on its benefits, and best practices for effective implementation.
Enhancing Snowflake Security with Multi-Factor Authentication (MFA)
Published: at 10:00 AMThis article provides a comprehensive guide on implementing Multi-Factor Authentication (MFA) in Snowflake, detailing its importance, setup procedures, enforcement timelines, and best practices to enhance data security.
Snowflake Hybrid Tables Compared to Standard Snowflake Tables
Published: at 10:00 AMLet's comparing Snowflake Hybrid Tables and Standard Tables, detailing their differences, use cases, and implementation strategies.
Snowflake Event Tables - What Are Those?
Published: at 10:00 AMA 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.