%%{ init: { 'flowchart': { 'curve': 'basis' } } }%%

flowchart LR

    classDef red      fill:#f66,color:#600,stroke:#600,stroke-width:4px;
    classDef blue     fill:#88f,color:#006,stroke:#006,stroke-width:4px;
    classDef green    fill:#6f6,color:#040,stroke:#040,stroke-width:4px;
    
    classDef yellow   fill:#ff6,color:#660,stroke:#660,stroke-width:4px;
    classDef mag      fill:#f4f,color:#404,stroke:#404,stroke-width:4px;
    classDef cyan     fill:#6ff,color:#066,stroke:#066,stroke-width:4px;

    classDef seagreen fill:#6f8,color:#153,stroke:#153,stroke-width:4px;
    classDef orange   fill:#fa0,color:#620,stroke:#620,stroke-width:4px;
    classDef gold     fill:#fd0,color:#750,stroke:#750,stroke-width:4px;
    classDef silver   fill:#cce,color:#335,stroke:#335,stroke-width:4px;
    classDef white    fill:#fff,color:#000,stroke:#000,stroke-width:4px;

    subgraph Google
        ga[(Google Analytics)]; class ga seagreen
        ads[(Google Ads)]; class ads seagreen
        sa[(Google\n Search Ads)]; class sa seagreen
        dv[(Display\n Video 360)]; class dv seagreen
        cm[(Campaign\n Manager)]; class cm seagreen
        yt[(YouTube\n Channel)]; class yt seagreen

        gbq[(Google Big Query)]; class gbq seagreen

        ga --> gbq
        dv-..-> gbq
        ads -.-> gbq
        cm-..-> gbq
        sa -.-> gbq
        yt-..-> gbq
    end

    subgraph Floor and Decor
        subgraph Azure Storage
            bz[[Bronze\n Parquet files/\n External Tables]]; class bz yellow
            gbq -- "Azure \nData \nFactory" --> bz
        end

        subgraph Databricks
            ag[Silver \nManaged Tables]; class ag silver
            au[Gold \nManaged Tables]; class au gold
            bz --Databricks\n Notebook--> ag
            ag -. Databricks\n Notebook .-> au
            
        end
    end