Stairway to Snowflake Level 8 - Event Tables
In this next level of the Stairway to Snowflake, we delve into Event Tables. These are used to capture telemetry from your Snowflake database.
2025-07-02
619 reads
Snowflake
Parent – Child Task Automation in Snowflake via Task Graph
This article explores how to use Snowflake’s task features to implement parent-child data workflows. We will walk through a real-world scenario in which a healthcare organization manages patient records using a sequence of tasks for data ingestion, transformation, enrichment, and reporting.
2025-06-18
Real-time Data Streaming in Snowflake
Real-time data ingestion has become essential for modern analytics and operational intelligence. Organizations across industries need to process data streams from IoT sensors, financial transactions, and application events with minimal latency. Snowflake offers two robust approaches to meet these real-time data needs: Snowpipe for near-real-time file-based streaming and Direct Streaming via Snowpark API for true real-time data integration.
2025-06-13
Stairway to Snowflake Level 7 - Snowflake Tables
In this next level of the Stairway to Snowflake we examine the wide variety of table types that exist in the platform.
2025-06-13 (first published: 2025-05-21)
1,613 reads
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Snowflake has its own CLI tool: SnowSQL. In this level of the Stairway Series learn how to work with this dialect in Snowflake and Visual Studio Code.
2025-06-13 (first published: 2024-11-20)
1,797 reads
Load Data into Snowflake Using Python with Pandas
Loading data into Snowflake is a common need. Using Python and pandas is a common go-to solution for data professionals
2025-04-21
Stairway to Snowflake Level 6 - Creating and Cloning Snowflake Databases
In this next level of the Stairway to Snowflake, learn about creating and dropping databases, with some options for cloning from different sources.
2025-06-13 (first published: 2025-01-15)
2,421 reads
Stairway to Snowflake Level 4 - Introducing Snowsight, Snowflake’s Web UI
This next level of the Stairway to Snowflake looks at the Snowsight UI and what you can accomplish with it.
2025-06-13 (first published: 2024-10-23)
1,734 reads
Bridging Snowflake and Azure Data Stack: A Step-by-Step Guide
This article shows how to access Snowflake information from Synapse Analytics.
2024-06-03
1,650 reads
Data Transfer from Snowflake to Azure Blob using Synapse Analytics
Two of the top cloud services right now are Azure Synapse and Snowflake. Whatever your organization is implementing or if you need to transfer data to/from those services, it is important to know how to interconnect them and be able to transfer data between services.
2023-06-09
Blogs
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
Forums
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Designing Delta Tables with Liquid Clustering: Real-World Patterns for Data Engineers
Comments posted to this topic are about the item Designing Delta Tables with Liquid...
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers