# snowflake-labs/sf-samples architecture

> Architecture diagram of the GitHub repository snowflake-labs/sf-samples, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-06-04). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/snowflake-labs/sf-samples
- Repository: https://github.com/snowflake-labs/sf-samples

## Overview

##### Project type and purpose
- This is a monorepo of Snowflake sample code (“Snowflake Samples”), not a single application.
- Its purpose is to provide self-contained tutorials and demos for various Snowflake features (SQL snippets, Python/Snowpark apps, Streamlit UIs, Docker examples, Jupyter notebooks, etc.).

##### File structure
- Top level:
- .gitignore, LICENSE, README.md (global docs)
- samples/ (one subdirectory per sample/demo)
- Under samples/: each directory is a standalone sample. Subsamples vary:
- SQL-only demos (e.g., workload-optimization-queries)
- Python apps using Snowpark (e.g., cortex-analyst, cortex-nemoguardrails)
- Streamlit UIs that connect to Snowflake
- Jupyter notebooks demonstrating data science or pipeline use cases
- Dockerized code examples and client-library samples
- There is no single build or deployment script—each sample carries its own setup, config files, and README.

##### README for additional insights
- Confirms that this is simply a collection of independent tutorials.
- Instructs contributors to add new samples within the samples/ directory.

A. Repository Structure Layer
- How samples are grouped by technology type (SQL, Python, Streamlit, Notebooks, Docker).
B. Typical Sample Flow Layer
For any given sample (pick one as an exemplar, e.g., FSI_asset_management_demo):
- External Data Inputs (CSV, PDF, TIFF) →
[Data Ingestion Scripts (SQL, Python)] →
[Snowflake Data Warehouse (tables/stages)] →
[Processing (Snowpark stored procs, RAG notebooks)] →
[Presentation/Visualization (Streamlit UI)] →
[User].

##### Main components & interactions
- GitHub Repo / Version Control
- Developer Environment (local IDE / Conda env / Docker)
- Snowflake Cloud Account
- Database / Warehouses
- Stages for file ingestion
- Snowpark compute (Python UDFs, stored procedures)
- Sample code modules
- SQL scripts (ingest, transform, governance)
- Python apps (connectors, Snowpark calls)
- Streamlit frontends
- Jupyter notebooks for analytics & demos
- Data sources (CSV, PDF, external APIs)

##### Architectural patterns & design principles
- Monorepo housing independent modules—each sample is decoupled.
- “Infrastructure as code” via .sql setup scripts and Dockerfiles.
- Use of Snowflake services: stages for landing, tasks for automation, Snowpark for compute, external functions/UDFs.

##### Technologies & frameworks
- Snowflake SQL (stages, tasks, stored procs)
- Snowpark for Python
- Streamlit for UI demos
- Jupyter Notebooks (.ipynb)
- Docker for containerized examples
- YAML/JSON for config & manifest files

## Diagram (Mermaid)

```mermaid
flowchart TD
  %% Colors
  classDef sql fill:#cce5ff,stroke:#333,stroke-width:1px
  classDef python fill:#d4edda,stroke:#333,stroke-width:1px
  classDef ui fill:#fff3cd,stroke:#333,stroke-width:1px
  classDef notebook fill:#e2e3e5,stroke:#333,stroke-width:1px
  classDef infra fill:#f8d7da,stroke:#333,stroke-width:1px
  classDef data fill:#d1ecf1,stroke:#333,stroke-width:1px
  classDef repo fill:#f0f0f0,stroke:#333,stroke-width:2px

  subgraph "GitHub Repository: snowflake-samples" 
    direction TB
    README["README.md"]:::repo
    LICENSE["LICENSE"]:::repo
    GITIGNORE[".gitignore"]:::repo

    subgraph "samples/" 
      direction TB

      subgraph "SQL-only Demos" 
        direction TB
        WQ1["workload-optimization-queries/AccountUsage/Cost"]:::sql
        WQ2["workload-optimization-queries/AccountUsage/Implementation"]:::sql
        WQ3["workload-optimization-queries/AccountUsage/Performance"]:::sql
        WQ4["workload-optimization-queries/InformationSchema/Cost"]:::sql
        WQ5["workload-optimization-queries/InformationSchema/Implementation"]:::sql
        WQ6["workload-optimization-queries/InformationSchema/Performance"]:::sql
      end

      subgraph "Python/Snowpark Apps" 
        direction TB
        PA1["cortex-analyst/Advanced SiS Demo"]:::python
        PA2["cortex-nemoguardrails"]:::python
        PA3["vehicle-insurance-agentic-ai"]:::python
      end

      subgraph "Streamlit UIs" 
        direction TB
        UI1["FSI_asset_management_demo/02_streamlit/snow_invest.py"]:::ui
        UI2["operation_cortex/streamlit.py"]:::ui
        UI3["streamlit-in-snowflake/import-from-folder/streamlit_app.py"]:::ui
        UI4["streamlit-in-snowflake/multiple-pages/streamlit_app.py"]:::ui
      end

      subgraph "Jupyter Notebooks" 
        direction TB
        NB1["custom_ml_pipelines/00_SETUP.ipynb"]:::notebook
        NB2["dcdf_incremental_processing/pipeline_alerts_level_1.ipynb"]:::notebook
        NB3["ml/ml_jobs/xgb_classifier_nb/single_node_xgb.ipynb"]:::notebook
        NB4["snowfake-cortex/cortexRAG/quickstart.ipynb"]:::notebook
      end

      subgraph "Dockerized Examples" 
        direction TB
        DK1["cortex-nemoguardrails/Dockerfile"]:::infra
        DK2["sap_accounts_receivable_dbt/Dockerfile"]:::infra
        DK3["sap_accounts_receivable_dbt/dbt_project.yml"]:::infra
      end

      subgraph "Data Ingestion & Setup Scripts" 
        direction TB
        DS1["FSI_asset_management_demo/01_demo_config/00_demo_setup.sql"]:::infra
        DS2["FSI_asset_management_demo/01_demo_config/03_duedil_docai_setup.sql"]:::infra
        DS3["cortex-analyst/Advanced SiS Demo/sis_setup/create_app.sql"]:::infra
      end

      subgraph "Configuration & Manifest Files" 
        direction TB
        CF1["cortex-analyst/Advanced SiS Demo/environment.yml"]:::infra
        CF2["cortex-nemoguardrails/requirements.txt"]:::infra
        CF3["energy-price-forecasting-native-app/energy_price_forecasting_nativeapp/manifest.yml"]:::infra
        CF4["streamlit-in-snowflake/sis-deploy/environment.yml"]:::infra
      end

      subgraph "Data Sources" 
        direction TB
        DSRC1["FSI_asset_management_demo/00_Inputs/csv/"]:::data
        DSRC2["FSI_asset_management_demo/00_Inputs/duedil_docai/PDF/"]:::data
        DSRC3["FSI_asset_management_demo/00_Inputs/duedil_docai/TIFF/"]:::data
        DSRC4["iceberg_cortex/*.csv"]:::data
      end

    end
  end

  %% Typical Sample Flow
  subgraph "Typical Sample Flow: FSI_asset_management_demo" 
    direction TB
    DataInputs["External Data Inputs"]:::data
    Ingest["Data Ingestion Scripts"]:::infra
    Warehouse["Snowflake Data Warehouse"]:::repo
    Compute["Processing (Snowpark, Notebooks)"]:::python
    Viz["Presentation/Visualization (Streamlit UI)"]:::ui
    User["User"]:::repo

    DataInputs -->|ingest| Ingest
    Ingest -->|load data| Warehouse
    Warehouse -->|compute| Compute
    Compute -->|serve| Viz
    Viz -->|view| User
  end

  %% Click events
  click README "https://github.com/snowflake-labs/sf-samples/blob/main/README.md"
  click LICENSE "https://github.com/snowflake-labs/sf-samples/tree/main/LICENSE"
  click GITIGNORE "https://github.com/snowflake-labs/sf-samples/blob/main/.gitignore"
  click WQ1 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/workload-optimization-queries/AccountUsage/Cost/"
  click WQ2 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/workload-optimization-queries/AccountUsage/Implementation/"
  click WQ3 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/workload-optimization-queries/AccountUsage/Performance/"
  click WQ4 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/workload-optimization-queries/InformationSchema/Cost/"
  click WQ5 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/workload-optimization-queries/InformationSchema/Implementation/"
  click WQ6 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/workload-optimization-queries/InformationSchema/Performance/"
  click PA1 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/cortex-analyst/Advanced SiS Demo/"
  click PA2 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/cortex-nemoguardrails/"
  click PA3 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/vehicle-insurance-agentic-ai/"
  click UI1 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/FSI_asset_management_demo/02_streamlit/snow_invest.py"
  click UI2 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/operation_cortex/streamlit.py"
  click UI3 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/streamlit-in-snowflake/import-from-folder/streamlit_app.py"
  click UI4 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/streamlit-in-snowflake/multiple-pages/streamlit_app.py"
  click NB1 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/custom_ml_pipelines/00_SETUP.ipynb"
  click NB2 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/dcdf_incremental_processing/pipeline_alerts_level_1.ipynb"
  click NB3 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/ml/ml_jobs/xgb_classifier_nb/single_node_xgb.ipynb"
  click NB4 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/snowfake-cortex/cortexRAG/quickstart.ipynb"
  click DK1 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/cortex-nemoguardrails/Dockerfile"
  click DK2 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/sap_accounts_receivable_dbt/Dockerfile"
  click DK3 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/sap_accounts_receivable_dbt/dbt_project.yml"
  click DS1 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/FSI_asset_management_demo/01_demo_config/00_demo_setup.sql"
  click DS2 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/FSI_asset_management_demo/01_demo_config/03_duedil_docai_setup.sql"
  click DS3 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/cortex-analyst/Advanced SiS Demo/sis_setup/create_app.sql"
  click CF1 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/cortex-analyst/Advanced SiS Demo/environment.yml"
  click CF2 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/cortex-nemoguardrails/requirements.txt"
  click CF3 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/energy-price-forecasting-native-app/energy_price_forecasting_nativeapp/manifest.yml"
  click CF4 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/streamlit-in-snowflake/sis-deploy/environment.yml"
  click DSRC1 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/FSI_asset_management_demo/00_Inputs/csv/"
  click DSRC2 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/FSI_asset_management_demo/00_Inputs/duedil_docai/PDF/"
  click DSRC3 "https://github.com/snowflake-labs/sf-samples/tree/main/samples/FSI_asset_management_demo/00_Inputs/duedil_docai/TIFF/"
  click DSRC4 "https://github.com/snowflake-labs/sf-samples/blob/main/samples/iceberg_cortex/*.csv"
```
