Helpful Snowflake Tutorials
September 16, 2026 · PowderInsights Team
How to let Snowflake code reach the internet safely: network rules, stored secrets, external access integrations, and UDF and stored-procedure patterns that survive production volume, retries, and a security review.
Read moreSeptember 15, 2026 · PowderInsights Team
How clones and Time Travel really work in Snowflake, three patterns that use them (weekly dev refresh, per-pull-request CI databases, blue/green cutovers and point-in-time recovery), and the retention and clone-storage traps that inflate your bill.
Read moreSeptember 14, 2026 · PowderInsights Team
A practical guide to Streamlit in Snowflake: when a SiS app beats a BI dashboard, project structure and the snowflake.yml deploy path, warehouse and role design, running Snowpark and Cortex calls safely, external access, and the governance model that keeps row access policies and masking intact.
Read moreSeptember 14, 2026 · PowderInsights Team
An end-to-end Snowflake ML walkthrough: define features once in the Feature Store, train on Container Runtime with ML Jobs, version artifacts in the Model Registry, score from SQL or a service endpoint, and catch drift with model monitors and alerts.
Read moreSeptember 14, 2026 · PowderInsights Team
A practical modelling guide for JSON, Parquet, and Avro in Snowflake: land raw VARIANT with file metadata, profile with FLATTEN and TYPEOF, promote fields to typed columns for pruning, use INFER_SCHEMA and ENABLE_SCHEMA_EVOLUTION on landing tables, and switch to OBJECT/ARRAY/MAP structured types when the data has to leave as Iceberg or Parquet.
Read more