# dmitrydoni/air-boltic architecture

> Architecture diagram of the GitHub repository dmitrydoni/air-boltic, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-09-13). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/dmitrydoni/air-boltic
- Repository: https://github.com/dmitrydoni/air-boltic

## Overview

##### Project type and purpose
- This is a data-analytics/ETL pipeline project (“Air Boltic marketplace analytics”).
- It ingests sample datasets (CSV/JSON), runs transformations with dbt against DuckDB, then analyzes and visualizes results via Polars in a Jupyter notebook and exports an HTML report for stakeholders.

##### File structure
- Top level:
- analytics/air_boltic_analytics → a dbt project with subfolders: sources, staging (stg_*.sql), intermediate (int_*.sql), marts (dim_*.sql & fct_*.sql), plus macros, seeds, snapshots, tests, logs, target.
- analytics/analytics_report.ipynb & .html → Polars-based analysis and report.
- analytics/dev.duckdb → the DuckDB instance used by dbt and Polars.
- docs/analytics_architecture.png → existing architecture doc.
- samples/ → raw input files.
- Key config: dbt_project.yml, pyproject.toml, uv.lock.

##### README for additional insights
- Purpose: build a reusable, layered data model and deliver an HTML analytics report.

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% Raw Data Layer
    subgraph "Raw Data" 
        DS["Sample Data (CSV/JSON)"]:::data
    end

    %% Ingestion Layer
    subgraph "Ingestion Layer (dbt Sources & Staging)"
        SRC["sources.yml"]:::ingestion
        STG1["stg_aeroplane_models.sql"]:::ingestion
        STG2["stg_aeroplanes.sql"]:::ingestion
        STG3["stg_customer_groups.sql"]:::ingestion
        STG4["stg_customers.sql"]:::ingestion
        STG5["stg_orders.sql"]:::ingestion
        STG6["stg_trips.sql"]:::ingestion
    end

    %% Transformation Layer - Intermediate
    subgraph "Intermediate Models"
        INTYML["intermediate.yml"]:::transformation
        INT1["int_aeroplane_models.sql"]:::transformation
        INT2["int_aeroplanes.sql"]:::transformation
        INT3["int_customer_groups.sql"]:::transformation
        INT4["int_customers.sql"]:::transformation
        INT5["int_orders.sql"]:::transformation
        INT6["int_trips.sql"]:::transformation
    end

    %% Transformation Layer - Marts
    subgraph "Data Marts"
        MARTYML["marts.yml"]:::transformation
        DIM1["dim_aeroplane.sql"]:::transformation
        DIM2["dim_customer.sql"]:::transformation
        DIM3["dim_trip.sql"]:::transformation
        FCT["fct_order.sql"]:::transformation
    end

    %% Storage Layer
    subgraph "Analytics Database"
        DB["dev.duckdb"]:::storage
    end

    %% Analysis & Reporting
    subgraph "Analysis & Visualization"
        NB["analytics_report.ipynb"]:::analysis
        HTML["analytics_report.html"]:::analysis
    end

    %% Orchestration & Configuration
    subgraph "Orchestration & Config"
        DBT["dbt_project.yml"]:::config
        PY["pyproject.toml"]:::config
        UV["uv.lock"]:::config
        README["README.md"]:::config
    end

    %% Testing & Snapshots
    subgraph "Testing & Snapshots"
        TESTS["tests/"]:::test
        SNAP["snapshots/"]:::test
    end

    %% Documentation
    DOC["analytics_architecture.png"]:::doc
    class DOC doc

    %% Data Flow
    DS --> SRC
    SRC --> STG1 --> STG2 --> STG3 --> STG4 --> STG5 --> STG6
    STG6 --> INTYML
    INTYML --> INT1 --> INT2 --> INT3 --> INT4 --> INT5 --> INT6
    INT6 --> MARTYML
    MARTYML --> DIM1 --> DIM2 --> DIM3 --> FCT
    FCT --> DB
    DB --> NB --> HTML

    %% Orchestration Flow
    DBT --> SRC
    DBT --> INTYML
    DBT --> MARTYML

    %% Testing & Snapshot Flows
    TESTS -.-> SRC
    TESTS -.-> INTYML
    TESTS -.-> MARTYML
    SNAP --> DB

    %% Click Events
    click DS "https://github.com/dmitrydoni/air-boltic/tree/main/samples/"
    click SRC "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/sources/sources.yml"
    click STG1 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/sources/stg_aeroplane_models.sql"
    click STG2 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/sources/stg_aeroplanes.sql"
    click STG3 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/sources/stg_customer_groups.sql"
    click STG4 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/sources/stg_customers.sql"
    click STG5 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/sources/stg_orders.sql"
    click STG6 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/sources/stg_trips.sql"
    click INTYML "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/intermediate/intermediate.yml"
    click INT1 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/intermediate/int_aeroplane_models.sql"
    click INT2 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/intermediate/int_aeroplanes.sql"
    click INT3 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/intermediate/int_customer_groups.sql"
    click INT4 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/intermediate/int_customers.sql"
    click INT5 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/intermediate/int_orders.sql"
    click INT6 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/intermediate/int_trips.sql"
    click MARTYML "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/marts/marts.yml"
    click DIM1 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/marts/dim_aeroplane.sql"
    click DIM2 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/marts/dim_customer.sql"
    click DIM3 "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/marts/dim_trip.sql"
    click FCT "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/models/marts/fct_order.sql"
    click DB "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/dev.duckdb"
    click NB "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/analytics_report.ipynb"
    click HTML "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/analytics_report.html"
    click DBT "https://github.com/dmitrydoni/air-boltic/blob/main/analytics/air_boltic_analytics/dbt_project.yml"
    click PY "https://github.com/dmitrydoni/air-boltic/blob/main/pyproject.toml"
    click UV "https://github.com/dmitrydoni/air-boltic/blob/main/uv.lock"
    click README "https://github.com/dmitrydoni/air-boltic/blob/main/README.md"
    click TESTS "https://github.com/dmitrydoni/air-boltic/tree/main/analytics/air_boltic_analytics/tests/"
    click SNAP "https://github.com/dmitrydoni/air-boltic/tree/main/analytics/air_boltic_analytics/snapshots/"
    click DOC "https://github.com/dmitrydoni/air-boltic/blob/main/docs/analytics_architecture.png"

    %% Styles
    classDef data fill:#FFD966,stroke:#333,stroke-width:1px
    classDef ingestion fill:#C9DAF8,stroke:#333,stroke-width:1px
    classDef transformation fill:#D5A6BD,stroke:#333,stroke-width:1px
    classDef storage fill:#B6D7A8,stroke:#333,stroke-width:1px
    classDef analysis fill:#F9CB9C,stroke:#333,stroke-width:1px
    classDef config fill:#EAD1DC,stroke:#333,stroke-width:1px
    classDef test fill:#CCCCCC,stroke:#333,stroke-width:1px,stroke-dasharray: 5 5
    classDef doc fill:#FFFFFF,stroke:#333,stroke-width:1px,stroke-dasharray: 2 2
```
