How anshlambagit/airbnb_snowflake_dbt_data_engineer_project works
This is a dbt/Snowflake Airbnb analytics pipeline: CSV data is loaded to staging, transformed through Bronze and Silver into Gold analytics models, with snapshots for history and tests for quality. The graph also preserves documented macros and ad-hoc analyses. Most implementation files were not sampled, so transformation links follow the README’s documented lineage; the empty main.py does not appear to implement a runtime entry point.
Main entry points: dbt_project.yml dbt project · silver Silver models · bronze Bronze models · ddl.sql Snowflake staging
Components 16
Data Ingestion
- Airbnb CSVs
SourceData - AWS S3
- Snowflake staging
DDL/ddl.sql - Snowflake warehouse
Data Transformation
- dbt project
aws_dbt_snowflake_project/dbt_project.yml - Source definitions
aws_dbt_snowflake_project/models/sources/sources.yml - Bronze models
aws_dbt_snowflake_project/models/bronze - Silver models
aws_dbt_snowflake_project/models/silver - Custom macros
aws_dbt_snowflake_project/macros
Analytics Products
- Ephemeral models
aws_dbt_snowflake_project/models/gold/ephemeral - Fact model
aws_dbt_snowflake_project/models/gold/fact.sql - One Big Table
aws_dbt_snowflake_project/models/gold/obt.sql - Ad-hoc analyses
aws_dbt_snowflake_project/analyses
Quality and History
- SCD snapshots
aws_dbt_snowflake_project/snapshots - Data quality tests
aws_dbt_snowflake_project/tests/source_tests.sql
Other components
- Data engineer
Connections 23
- Data engineer → dbt project: runs commands
README.md - Airbnb CSVs → AWS S3: loads to
README.md - AWS S3 → Snowflake staging: loads to
README.md - Snowflake staging → Source definitions: defines inputs
README.md - Source definitions → Bronze models: feeds
README.md - Bronze models → Silver models: cleans
README.md - Silver models → Ephemeral models: feeds
README.md - Ephemeral models → Fact model: supports
README.md - Ephemeral models → One Big Table: supports
README.md - dbt project → Bronze models: runs models
README.md - dbt project → Silver models: runs models
README.md - dbt project → Fact model: runs models
README.md - dbt project → One Big Table: runs models
README.md - dbt project → SCD snapshots: runs snapshots
README.md - dbt project → Data quality tests: runs tests
README.md - Silver models → Custom macros: uses tagging
README.md - dbt project → Ad-hoc analyses: hosts queries
README.md - Snowflake staging → Snowflake warehouse: stores tables
README.md - Bronze models → Snowflake warehouse: writes models
README.md - Silver models → Snowflake warehouse: writes models
README.md - Fact model → Snowflake warehouse: writes model
README.md - One Big Table → Snowflake warehouse: writes model
README.md - SCD snapshots → Snowflake warehouse: tracks history
README.md