Ismail Mezzour

Ismail Mezzour

I build Snowflake, dbt and Airflow platforms your teams can run without me.

At a CAC 40 company, I deployed Airflow for 80+ data engineers and scientists, with 15 teams on one platform.

Email meWork with me

Two free courses

No account needed. Progress is saved automatically.

Ismail in a yellow bobble hat in front of a snowy mountain, beside a small drawing of Snowflake's three layers

SnowPro Core COF-C03 Study Guide

For Snowflake users who want the certification. New to it? Start with the Field Guide.

The five COF-C03 exam domains, taught from the architecture up.

  • Why the same query can cost zero compute the second time
  • When to scale a warehouse up, and when to scale it out
  • 30 practice questions at the end of each part

65 lessons, 7 practice sets, 4 timed mock exams, 610 questions

Open the course
Ismail in an explorer's hat on a contour map, beside a signpost from raw data to stg_orders, fct_orders and a dashboard

The Analytics Engineer’s Field Guide

Start here if dbt, Airflow or Snowflake are new to you. Some SQL is all you need.

dbt, Airflow and Snowflake on one pipeline, from your first model to a warehouse that’s fast and cheap.

  • Turn a SQL script into a tested, documented dbt model
  • Write your first Airflow DAG, then run dbt on it with Cosmos
  • Read a Snowflake query profile and bring the bill down
  • Finish on a full case study, the IsmaFrost pizzeria

34 lessons, each ending with a quiz, 6 challenges, 120 questions

Open the course

Talk decks

The PDFs from my talks on Airflow, dbt and self-service analytics.

See the decks
Ismail presenting on stageHand-drawn slide, A Company in ChaosHand-drawn slide, A tool without rules is difficult to manage

What DataFrost does

Audit

We review your Snowflake or BigQuery platform: performance, cost, governance and data quality. You get a prioritized plan.

Build

We set up dbt, Airflow and CI/CD with templates and guardrails, so analysts ship their own work safely.

Train

Your analysts and engineers learn Snowflake, dbt and Airflow with us, then keep going without us.

Talk to me

I set up dbt across the data teams of a CAC 40 company. DataFrost brings that work to other companies.