The Complete Snowflake & dbt Hands-On Course
Master Snowflake & dbt – from scratch to pro
Lo que serás capaz de hacer
Want to build real, production-ready data pipelines with two of the most in-demand tools in the modern data stack ? This all-levels, project-based course takes you from the basics to advanced workflows with Snowflake and dbt (data build tool). With over 11 hours of content, you’ll not just learn the concepts — you’ll apply them step by step in real projects, including a Bitcoin blockchain data pipeline designed to mirror real-world challenges. In this course, you will: Set up and manage Snowflake environments (databases, schemas, stages). Ingest data from local files, S3 buckets, and external sources. Write modular SQL with dbt models, CTEs, and window functions. Apply ELT best practices and build maintainable data models. Use dbt contracts, versioning, and generic tests for reliability. Set up CI/CD with GitHub Actions and key pair authentication. Optimize Snowflake with caching, micropartitions, and clustering. Prepare data for analytics tools like Power BI. This course is packed with real-world use cases, code walkthroughs, and tips I’ve implemented in production environments. By the end, you’ll be confident in building scalable, maintainable data pipelines — skills you can immediately apply in your current role or future projects. These lessons are designed to give you both technical expertise and practical confidence when working with modern data tools.
- Ingest data into Snowflake from multiple sources (AWS S3 and local files)
- Set up and manage internal and external stages in Snowflake
- Use SnowSQL to load and query data in Snowflake efficiently
- Build and optimize data transformation models using dbt
- Understand version control and modularity in dbt for scalable data projects
- Work with semi-structured data - JSON
Temario
UNIDAD 1 - Snowflake · 26 leccionesUNIDAD 1 - Snowflake
UNIDAD 1 - Snowflake
- Start Here: How This Course Will Help You
- Course Roadmap & Learning Paths
- Note
- Getting Started with Snowflake: Your Free Trial Setup
- Snowflake Workspaces: What Changed & How to Switch
- Set Up Your Workspace: Undestanding Roles, Warehouses and Worksheets
- Exercise: Create Your First Objects
- Snowflake Objects and Warehouses
- Granting Privileges in Snowflake
- Loading Data Starts Here: Creating Your First Stage
- The Power of VARIANT Columns in Snowflake
- Extract Columns from JSON in Snowflake (with VARIANT)
- Working with Stages and Semi-Structured Data in Snowflake
- Copying Data into Snowflake Tables (From Stage to Table)
- Exercise - Hands-On: Load Nested JSON from S3 into Snowflake
- Exercise - Correction
- Bike dataset and Snowsql
- Note: Update on Finding Your Snowflake Account Identifier for SnowSQL
- Push Local Files to Snowflake with PUT Command
- Note before starting the next Exercise
- Exercise - Create a Role Analyst
- Note after completing the Exercise
- Check Your Stage File Structure Before Loading
- COPY INTO Deep Dive: Debug, Options & Pro Tips
- Loading Data from Stages & Error Handling in Snowflake
- Section 1 Cheat Sheet – Snowflake Basics
UNIDAD 2 - Bonus: Automating your Snowflake Workflows · 4 leccionesUNIDAD 2 - Bonus: Automating your Snowflake Workflows
UNIDAD 2 - Bonus: Automating your Snowflake Workflows
- Introduction to Snowflake Tasks - Scheduled Task creation
- Snowflake Tasks - Creation of a child task and DAG of tasks
- Snowflake Tasks - Management
- Section 2 Cheat Sheet – Updated
UNIDAD 3 - DBT · 33 leccionesUNIDAD 3 - DBT
UNIDAD 3 - DBT
- Before you dive into dbt: watch this first!
- Note for the dbt Section
- Introduction to DBT
- DBT Cloud - Account creation
- DBT Cloud - Account setup
- Key Pair Authentication for dbt Cloud
- DBT Run
- Getting Started with dbt: Core Concepts, Environments & Materialization
- Jinja and dbt_project
- DBT - Materialization precedence
- Note
- DBT defining sources
- Ref function and first commit
- dbt Under the Hood: Jinja, Materialization Precedence & Source/Ref Functions
- CTEs and working with dates - Part 1
- CTEs and working with dates - Part 2
- Exercise - Reusable SQL with Macros
- Exercise Correction - Macro Refactor Walkthrough
- Daily weather and Window functions - Part 1
- Daily weather and Window functions - Part 2
- Mastering CTEs, Timestamps & Window Functions in dbt with Snowflake
- Station dimension
- DBT - Trip fact
- DBT - Weather Bike correlation
- Quick note. Watch or jump ahead
- Error correction - reuploading BIKE table
- Models corrected
- Prod deployment
- Deploying to Production with dbt Cloud
- End to End flow
- Snowflake Tasks Scheduling
- DBT Job scheduling
- Wrap up
UNIDAD 4 - Bonus – Advanced Automation (Requires Paid Plans) · 5 leccionesUNIDAD 4 - Bonus – Advanced Automation (Requires Paid Plans)
UNIDAD 4 - Bonus – Advanced Automation (Requires Paid Plans)
- Before You Start: Automation Setup Requirements
- Automation Prep: Setting Up External Access in Snowflake
- Understanding Functions in Snowflake (Inline vs Script-Based)
- End-to-End Automation: Triggering dbt Cloud from a Snowflake DAG
- Final Note: Clean Up to Avoid Unnecessary Costs
UNIDAD 5 - Bonus: Connecting Snowflake to Private Cloud Buckets · 5 leccionesUNIDAD 5 - Bonus: Connecting Snowflake to Private Cloud Buckets
UNIDAD 5 - Bonus: Connecting Snowflake to Private Cloud Buckets
- Intro Note
- AWS - Storage Integration - Part 1
- AWS - Storage Integration - Part 2
- Azure - Storage Integration
- GCS - Storage Integration
UNIDAD 6 - Build a Bitcoin Data Pipeline with dbt Core + Snowflake · 54 leccionesUNIDAD 6 - Build a Bitcoin Data Pipeline with dbt Core + Snowflake
UNIDAD 6 - Build a Bitcoin Data Pipeline with dbt Core + Snowflake
- Intro Project
- Note from Daniel
- AWS S3 BTC data
- BTC data explanation
- Copy Into With Regular Expression
- Wrapping COPY INTO in a Task
- Wrap Your COPY INTO in a Snowflake Task
- Note
- Python Setup
- Setup Git
- Visual Studio Code Setup
- DBT Init and first commit
- Key Pair Authentication for dbt Core
- Note about Git
- Push to the Git repo
- Note
- Dbt Core extension for lineage
- Main Yaml files and sources
- Source freshness
- Dbt Tests
- Incremental Model - Overview
- Incremental Model - Merge Strategy
- Snowflake Latteral Flatten
- Incremental Model - Append Strategy
- Incremental Models and dbt Strategies
- Ephemeral models - and Whale alert
- Quick analysis and dbt project reorganization
- dbt seed in Action: BTC Data, Price Enrichment & Debugging
- Macro refactoring
- Go Into Production
- The Manifest.json file
- Creation of a new dbt profile
- The defer flag - Defer upstream models
- Zero Copy Cloning and dbt Clone
- Defer vs Clone
- Python dbt models - Overview
- Note
- Python dbt models - Refactor Walkthrough
- Debugging Python dbt models - the print() Workaround
- DBT Packages
- Using a Macro from dbt packages
- DBT Docs
- Track Your Reports: Exposing Looker Dashboards in dbt
- DBT Test on Whale Alert
- Locking our Whale alert with a Contract
- Versioning out Whale Alert
- Setting Up Key Pair Authentication
- Note
- Continuous Integration Setup
- Optional Enhancement: Dynamic Target per Branch
- Thank you and Exercise Intro
- Ready to Pass the dbt Analytics Engineer Certification ?
- ETH Exercise
- Your feedback means a lot !
UNIDAD 7 - Building a dbt Audit Framework: Hooks, Context & Snapshots · 10 leccionesUNIDAD 7 - Building a dbt Audit Framework: Hooks, Context & Snapshots
UNIDAD 7 - Building a dbt Audit Framework: Hooks, Context & Snapshots
- Advanced Topic: Building a dbt Audit Framework
- Behind the Scenes: Making Sense of dbt Logs
- Intro to Tracking: Query Comments & History in Snowflake
- Post-Hooks in Action: Tagging dbt-Created Tables
- From Context to Audit: Using dbt Variables
- From Variables to Logs: Creating Your Audit Table
- Complete Audit Trail: From Runs to Row-Level Logs
- Optional Exercise: Pro-Level Audit Logging with Or Avidov’s results Object
- Handling Failures: runResults.json + dbt retry
- Snapshots in dbt: Using the Timestamp Strategy
UNIDAD 8 - dbt Fusion · 10 leccionesUNIDAD 8 - dbt Fusion
UNIDAD 8 - dbt Fusion
- dbt Fusion - Overview
- Getting Started (If You're Jumping Straight to dbt Fusion)
- dbt Fusion - Setup
- dbt Fusion - Migration
- Benchmark: dbt Fusion vs dbt Core
- A new concept: Static Analysis
- Development Experience Boost: Column Lineage
- Development Experience Boost: Preview CTE and Refactoring
- Registration
- Limitations & Reality
UNIDAD 9 - Unlocking Snowflake: Real-Time Data, Access Control & Optimization · 31 leccionesUNIDAD 9 - Unlocking Snowflake: Real-Time Data, Access Control & Optimization
UNIDAD 9 - Unlocking Snowflake: Real-Time Data, Access Control & Optimization
- About This Section
- Intro to Snowflake features
- Snowpipe Part 1: Uploading JSON to S3 & Creating Your External Stage
- Fixing the 403: Setting Up Storage Integration & Trust Policy in AWS
- Triggering Snowpipe from S3 & Wrapping It All Up
- Note on Snowpipe file processing
- Loading Clean Data with MERGE
- Introduction to Streams: Tracking Table Changes in Snowflake
- Consuming a Stream with MERGE: Handling Inserts, Updates & Deletes
- Automating Stream Consumption with Snowflake Tasks
- Snowflake Time Travel in Action: Querying Past States & Undropping Objects
- Advanced Time Travel Tips: Retention Period & SHOW HISTORY
- Cloning a Database with Time Travel
- Understanding Fail-safe: Snowflake’s Last Line of Data Recovery
- Exporting Data from Snowflake to S3
- Customizing Your Snowflake Data Exports
- Snowflake Secure Shares: Full Walkthrough
- Note on Shares
- Hiding Superpowers with Masking Policies
- RLS in Snowflake
- Exercise - Row & Column Security: Game of Thrones Edition
- Note on RBAC
- Role Hierarchy in Snowflake: Granting and Revoking Roles
- Direct Grants and Secondary Roles
- Why Professor X Can’t See Villains (Yet)
- Snowflake Roles & Privileges - Made simple
- Dropping Objects and Cleaning up
- Cache
- Micro Partitions
- Clustering
- Snowflake Cheat Sheet – Updated
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
9 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
8 cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
Muestra · verificable por folio y QR
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Daniel Weigel.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 9 unidades · 178 lecciones · 45 h
- 12 meses de acceso
- 8 cuestionarios de evaluación
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Daniel Weigel; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.
