Courses Handbook Models Changelog Reference

Courses Handbook Models Changelog Reference

Handbook contents

0 of 31 read0%

Learn

Overview
Why dbt?
Analysts and dbt
The data we model
Understanding analytical tables
How models depend on each other
Data layers
Reading model names
Finding and reusing models
Designing models
Tests & documentation
Building and checking a change
Git & pull requests
From merge to production
Observing production

Field guides

Overview
Set up your development environment
Find your source
Write a staging model
Add the YAML
Build & test locally
Open your pull request
Review & merge
Change an existing model
Undoing things in git

Going further

Overview
The dbt extension
Macros
Materialisations
Clustering
Project configuration
Snapshots
Semantic views
Python models

Keep handy

Command reference
Model docs
Changelog
Dataset directory
Production reference

0 of 31 read0%

Learn

Overview
Why dbt?
Analysts and dbt
The data we model
Understanding analytical tables
How models depend on each other
Data layers
Reading model names
Finding and reusing models
Designing models
Tests & documentation
Building and checking a change
Git & pull requests
From merge to production
Observing production

Field guides

Overview
Set up your development environment
Find your source
Write a staging model
Add the YAML
Build & test locally
Open your pull request
Review & merge
Change an existing model
Undoing things in git

Going further

Overview
The dbt extension
Macros
Materialisations
Clustering
Project configuration
Snapshots
Semantic views
Python models

Keep handy

Command reference
Model docs
Changelog
Dataset directory
Production reference

Changelog

Warehouse changes from merged dbt-analytics pull requests, grouped by day.

dbt-analytics Handbook

dbt onboarding

Built by the WNL Analytics team for analysts working in dbt-analytics.

Learn

Courses
Handbook
Field guides

Look up

Model docs
Changelog
Command reference

Project

dbt-analytics ↗
This site ↗
Changelog RSS

dbt™ is a trademark of dbt Labs, Inc. This is a community resource, not an official dbt product.

Changelog

Warehouse changes from merged dbt-analytics pull requests, grouped by day.

dbt-analytics Handbook

Courses Handbook Models Changelog Reference

Courses Handbook Models Changelog Reference

0 of 31 read0%

Learn

Overview
Why dbt?
Analysts and dbt
The data we model
Understanding analytical tables
How models depend on each other
Data layers
Reading model names
Finding and reusing models
Designing models
Tests & documentation
Building and checking a change
Git & pull requests
From merge to production
Observing production

Field guides

Overview
Set up your development environment
Find your source
Write a staging model
Add the YAML
Build & test locally
Open your pull request
Review & merge
Change an existing model
Undoing things in git

Going further

Overview
The dbt extension
Macros
Materialisations
Clustering
Project configuration
Snapshots
Semantic views
Python models

Keep handy

Command reference
Model docs
Changelog
Dataset directory
Production reference

0 of 31 read0%

Learn

Overview
Why dbt?
Analysts and dbt
The data we model
Understanding analytical tables
How models depend on each other
Data layers
Reading model names
Finding and reusing models
Designing models
Tests & documentation
Building and checking a change
Git & pull requests
From merge to production
Observing production

Field guides

Overview
Set up your development environment
Find your source
Write a staging model
Add the YAML
Build & test locally
Open your pull request
Review & merge
Change an existing model
Undoing things in git

Going further

Overview
The dbt extension
Macros
Materialisations
Clustering
Project configuration
Snapshots
Semantic views
Python models

Keep handy

Command reference
Model docs
Changelog
Dataset directory
Production reference

Changelog

Warehouse changes from merged dbt-analytics pull requests, grouped by day.

dbt-analytics Handbook

October 2026
September 2026
August 2026
July 2026
June 2026
May 2026
April 2026
March 2026
February 2026
January 2026
December 2025
November 2025
October 2025
September 2025
August 2025

October 2026
September 2026
August 2026
July 2026
June 2026
May 2026
April 2026
March 2026
February 2026
January 2026
December 2025
November 2025
October 2025
September 2025
August 2025

Changelog · November 2025 · dbt onboarding

–

–

–

–

–

–

20

20

9

9

62

62

39

39

47

47

57

57

39

39

November 2025 · 27 changes

Thu27 Nov 2025

Fixed
Missed a model when cleaning organisation_id
#249
Added
Completebowel screen status table
#247

Wed26 Nov 2025

Added
Development of screening tables for SMI and wider use
#245fct_breast_screening_status

Tue25 Nov 2025

Other
Local procedures
#244

Fri21 Nov 2025

Fixed
Pulled present_on_admission flag through to staged tables
#242
Added
Added RSV
#240
Added
Shingles
#238
Added
Adults imms PPV and Shingles
#236

Thu20 Nov 2025

Added
Smi residential flags and adult imms PPV built
#234

Wed19 Nov 2025

Added
Adult imms doses shingles
#229

Tue18 Nov 2025

Added
Adult imms more dev
#227

Mon17 Nov 2025

Added
Adult imms dev
#225

Fri14 Nov 2025

Added
Further development adult imms
#223

Thu13 Nov 2025

Added
Adult imms development
#221

Tue11 Nov 2025

Added
Vaccination status update
#219
Added
Added new vaccine logic for MMRV
#217
Added
Smi six checks new model
#215smi_six_health_check_dm

Mon10 Nov 2025

Other
Sus demographics
#213

Fri7 Nov 2025

Added
Change vaccine_eligible
#210
Added
Imms currently eligible add max days
#208
Added
Imms schedule and model changes for child and adult
#206

Thu6 Nov 2025

Added
Adding gp practice info to c-ltcs
#203
Added
Adult_imms_codes processing new file
#201

Wed5 Nov 2025

Added
Smi enhanced check models
#198

Tue4 Nov 2025

Added
Smi indicators dev
#196

Mon3 Nov 2025

Added
Time series by residence
#194
Other
Analyst changes mapping issues
#192

27

November 2025 · 27 changes

Thu27 Nov 2025

Fixed
Missed a model when cleaning organisation_id
#249
Added
Completebowel screen status table
#247

Wed26 Nov 2025

Added
Development of screening tables for SMI and wider use
#245fct_breast_screening_status

Tue25 Nov 2025

Other
Local procedures
#244

Fri21 Nov 2025

Fixed
Pulled present_on_admission flag through to staged tables
#242
Added
Added RSV
#240
Added
Shingles
#238
Added
Adults imms PPV and Shingles
#236

Thu20 Nov 2025

Added
Smi residential flags and adult imms PPV built
#234

Wed19 Nov 2025

Added
Adult imms doses shingles
#229

Tue18 Nov 2025

Added
Adult imms more dev
#227

Mon17 Nov 2025

Added
Adult imms dev
#225

Fri14 Nov 2025

Added
Further development adult imms
#223

Thu13 Nov 2025

Added
Adult imms development
#221

Tue11 Nov 2025

Added
Vaccination status update
#219
Added
Added new vaccine logic for MMRV
#217
Added
Smi six checks new model
#215smi_six_health_check_dm

Mon10 Nov 2025

Other
Sus demographics
#213

Fri7 Nov 2025

Added
Change vaccine_eligible
#210
Added
Imms currently eligible add max days
#208
Added
Imms schedule and model changes for child and adult
#206

Thu6 Nov 2025

Added
Adding gp practice info to c-ltcs
#203
Added
Adult_imms_codes processing new file
#201

Wed5 Nov 2025

Added
Smi enhanced check models
#198

Tue4 Nov 2025

Added
Smi indicators dev
#196

Mon3 Nov 2025

Added
Time series by residence
#194
Other
Analyst changes mapping issues
#192

27

102

102

77

77

88

88

72

72

72

72