AWS now handles Snowflake credential rotation automatically via key-pair auth or Programmatic Access Tokens. No Lambda functions, no manual scripts—just configure and forget.
10 min
Dimensional Modelling in 2026: Star vs Snowflake Schema for Modern Warehouses
Dimensional modelling concepts predate the cloud. Revisit star and snowflake schemas through a modern Snowflake lens — when each still earns its place, and when denormalisation simply wins.
11 min
Snowflake Administration Queries: The Complete ACCOUNT_USAGE Monitoring Toolkit
A practical reference covering cost, storage, security, performance, and governance queries for Snowflake platform administrators using ACCOUNT_USAGE views.
17 min
Feature Engineering in Snowflake: Preparing Data for Machine Learning
Feature engineering transforms raw data into ML-ready inputs. Snowflake provides native SQL functions and Snowpark tools to do this without leaving the warehouse.
9 min
Implementing Machine Learning Workloads in Snowflake
Snowflake offers multiple paths for ML workloads: Snowpark ML, Cortex ML functions, and in-database model training. Here is how to choose and implement each approach.
8 min
Project Snowwork: Snowflake AI for Business Users
Project Snowwork is Snowflake's autonomous AI platform for knowledge workers. Here is why it matters and what data teams should be watching as it develops.
7 min
Continuous Data Replication to Snowflake with Oracle GoldenGate
Oracle GoldenGate enables near real-time CDC from Oracle databases into Snowflake via S3 and Snowpipe. Here is how the pipeline works and when to use it.
7 min
Building a True Lakehouse with Snowflake Postgres and pg_lake
Snowflake Postgres and the pg_lake extension let you run OLTP workloads and analytical queries on the same Iceberg data layer — without copying data.