Index Ai Academy
Glossary · Phase 11 · Professional practice

Staging model

A SQL model that cleans one raw table: renames columns, fixes types and nothing more.

Try it now

Pick a batch and step through the models. Each model reads only what is above it.

Learn it properly

Transformations: staging, models and tests · Raw, staging, facts and marts as SQL models run in dependency order in DuckDB, tests as queries that count the rows that break a rule, an incremental load that is safe to rerun, and the same models as dbt files. About 45 minutes.

Other terms from the same lesson

  • dbt: A tool that runs SQL models in dependency order and tests them, with each model kept as a file.
  • incremental load: Adding only the new or changed rows each run, in a way that is safe to rerun.
  • mart: A table built for one use, such as a team's reports, from cleaned and joined data.
Keep learning

More in plain English.

1286 terms in the glossary, each with the lesson that teaches it.

1286 terms

The glossary

Every word you'll meet in AI and machine learning, explained in everyday language.

Phase 11 · lesson 45 min

Transformations: staging, models and tests

Raw, staging, facts and marts as SQL models run in dependency order in DuckDB, tests as queries that count the rows that break a rule, an incremental load that is safe to rerun, and the same models as dbt files.

Never trained an AI? Teach a small one to write, right in your browser. It takes about 20 seconds and needs no account. Teach it to write