Published warehouse (prod.duckdb)

P1 reference warehouse — queryable directly, no clone. From any duckdb session:

INSTALL httpfs;
LOAD httpfs;

ATTACH 'https://github.com/lukebarousse/dbt_Analytics_Engineering_Course/releases/download/warehouse/prod.duckdb' AS jobs;

USE jobs;
SHOW TABLES;

SELECT * FROM top_locations;

Course dataset (dataset-v1)

Fixed dataset snapshot for the course: 12 months of raw job postings (Jul 2025 - Jun 2026, ~843k rows) plus pre-extracted job skills. Run uv run job_postings/scripts/download_data.py to fetch these, or see the README.