BLOG

Snowflake Blog Hub

Empowering decisions with intelligent insights

Explore our comprehensive collection of Snowflake tutorials and best practices. Learn how to set up SnowSQL, leverage Snowflake Cortex AI features, load data from AWS, Azure, and GCP, implement secure PrivateLink connections, share data across cloud providers, and optimize compute workloads for both ETL and analytics.

Snowflake Blog Hub

Upgrading from dbt v1 to dbt v2: A Practical Guide for Snowflake Teams

Snowflake Bundle 2026_07 Is On by Default: What to Fix Before the Opt-Out Ends

SQL Server to Snowflake Migration: Collation, T-SQL and the Results That Change

Oracle to Snowflake Migration: Types, PL/SQL and the Behaviour That Changes

Azure Synapse to Snowflake: A Migration Guide for Dedicated SQL Pools

Replacing 200 Excel Reports: SAP, Oracle and Salesforce into Snowflake with Power BI

Multi-Touch Attribution with Shapley Values in Snowflake and Snowpark

Redshift to Snowflake for a Small Team: Which Sort Keys Become Clustering Keys

Getting Data Out of SAP ECC Without Locking Production: RFC, BAPIs and Change Pointers

Controlling Snowflake Cost When an ELT Tool Backfills Years of Data

Moving Retail Inventory Off PostgreSQL: Idempotent Syncs, Clones and Forecasts on Snowflake

Running Claim Checks in Snowflake Alongside a Mainframe

Loading Fixed-Width CDR Files into a Star Schema on Snowflake

Hot and Cold Tiering for Event Data: Snowflake, S3 Parquet and Snowpipe

Near-Real-Time Fraud Rules with Snowflake Streams and Tasks

Teradata to Snowflake Migration: What Converts Cleanly and What Needs Rework

Snowflake Bundle 2026_06: What Changes, and How to Test It Before It Flips

Snowflake Semantic Views vs dbt Semantic Layer: Where Metrics Live

Snowflake MCP Server Permissions: The Least-Privilege Setup

Snowflake DCM Projects Just Went GA: Do You Still Need Terraform?

Snowflake AI Credits Cost: Not Warehouse Credits, and How to Cap It

Snowflake Adaptive Compute vs Sized Warehouses: When to Switch

Batch Cortex Search: Fuzzy Matching Millions of Records in One SQL Statement

dbt Projects on Snowflake: Column-Level Lineage and the Fusion Engine

Snowpark Container Services on AWS Graviton: The GEN_ARM_G1 Family

Cortex AI Guardrails: Stopping Prompt Injection in Snowflake Intelligence and Cortex Agents

Snowflake Cortex Code: AI-Powered dbt and Airflow Workflows

Apache Iceberg Tables in Snowflake: Complete Guide for 2026

Snowflake Cortex AI: Complete Guide to Built-In Intelligence

Snowflake Data Sharing Across Cloud Providers (AWS to Azure) Using Listings

Azure SQL to Snowflake via Fabric Mirroring and OneLake Catalog Integration

Azure SQL to Snowflake via Microsoft Fabric OneLake and ADLS Gen2

Getting Started with dbt and Snowflake: ELT Data Transformation Guide

Loading Semi-Structured Data from AWS S3

Snowflake Cortex AI Functions in SQL: AI_COMPLETE, AI_FILTER, AI_AGG and More

Snowflake Cortex AI Functions: Translate, Summarize, Sentiment and Classify

Connecting Google Cloud Platform (GCP) to Snowflake: A Step-by-Step Guide

Guide to Load Data from Azure Cloud to Snowflake

Connecting to Snowflake from the Command Line: Snowflake CLI and SnowSQL

Streamlining IAM Role Creation for S3 Bucket Access with AWS Policy Generator

Snowflake Dynamic Tables: When to Use Them vs Streams/Tasks

Setting Up Hevo Data with Snowflake

Databricks vs Snowflake in 2026: An Honest Comparison

Migrating from Redshift to Snowflake: A Playbook

Star Schema in Snowflake: Why It Still Works

Snowflake Cost Optimization: 12 Things That Move the Needle

Data Governance in Snowflake: RLS, Masking & Access Controls

Snowpipe vs Snowpipe Streaming: Real-Time Ingestion

Snowflake Zero-Copy Cloning: How It Works

CDC in Snowflake Using Streams and Tasks

Working with JSON, Parquet & Avro in Snowflake

Setting Up RBAC in Snowflake

Snowflake Warehouse Sizing: Pick the Right Size

Snowflake Time Travel and Fail-safe Explained

Snowflake External Tables: Query Your Data Lake

Implementing SCDs in Snowflake with dbt

The Semantic Layer: Why Metrics Don't Match

Hevo vs Fivetran vs Airbyte in 2026