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 FeedData Sharing Across Organisations with Snowflake
Published: at 10:00 AMExplore how Snowflake enables secure data sharing across organisations. Learn about secure share mechanics, the difference between private and public shares, publishing to the Marketplace, and best practices for sharing responsibly.
How to Raise Support Tickets in Snowflake Using Snowsight
Published: at 10:00 AMThis article outlines the process for raising Snowflake support tickets using Snowsight, including how to enable access to support services, assign roles and privileges, and manage support cases effectively.
Mastering Data Types in Snowflake - From Scalars to Semi-Structured
Published: at 11:38 PMExplore the diverse data types supported by Snowflake, including scalar, semi-structured, and structured types. Learn how to effectively utilise VARIANT, ARRAY, OBJECT, and MAP data types to manage complex data structures within the Snowflake ecosystem.
Unlocking the Power of Snowflake Data Marketplace
Published: at 10:00 AMExplore the Snowflake Data Marketplace, a platform enabling seamless data sharing and access to third-party data products. Learn how it benefits data teams and businesses, and discover how to access and utilize its offerings effectively.
Snowflake 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
Claude Opus 4.5 Now Available on Snowflake Cortex AI: Enterprise AI Made Simple
Published: at 10:00 AMDiscover how Anthropic's Claude Opus 4.5 integration with Snowflake Cortex AI brings enterprise-grade generative AI capabilities directly to your data warehouse with enhanced security and seamless accessibility.
The Open Semantic Interchange Initiative: Breaking Down Data Silos Through Industry Collaboration
Published: at 10:00 AMDiscover how the Open Semantic Interchange initiative is bringing together major cloud providers and data platforms to standardize semantic data exchange and break down analytics silos.
Snowflake Semantic Views: Bridging the Gap Between Business Logic and Database Schema
Published: at 10:00 AMLearn how Snowflake Semantic Views create an abstraction layer that translates complex database schemas into business-friendly concepts, enabling better AI and BI integration.
Snowflake OpenFlow: Managed Data Integration Built on Apache NiFi
Published: at 10:00 AMExplore how Snowflake OpenFlow provides a fully managed data integration platform built on Apache NiFi, enabling seamless connectivity between diverse data sources and Snowflake with deployment flexibility.