Snowflake 전체 아키텍처

Account: XKRAHMI-KE11019 / User: hkkim / 2026-09-21
4
Databases
19
Schemas
314
Tables+Views
10.6M
Total Rows
2.3 GB
Storage
5
Agents
9
Semantic Views
7
Search Services

1. DB-Schema Map

flowchart TB
  subgraph ACC["Account XKRAHMI-KE11019"]
    subgraph DB1["STUDIO_REALIVE_POC_DB"]
      direction LR
      AI["AI - 49 obj, 16MB"]
      CORE["CORE - 120 obj, 456MB"]
      ONT["ONTOLOGY - 11 obj"]
      TOPS["TICKET_OPS - 11 obj"]
      MI["MARKET_INTEL - 16 obj, 1.6GB"]
      RS["RAW_SOCIAL - 5 obj, 1.9GB"]
      RAW["RAW - 21 obj, 58MB"]
      OF["OPENFLOW - 5 obj, 20MB"]
      AG["APP_GRAPH_UI - 13 views"]
    end
    subgraph DB2["FANDOM_LISTENING"]
      direction LR
      BRZ["BRONZE - 32 obj, 5MB"]
      SLV["SILVER - 5 DT, 2.3MB"]
      GLD["GOLD - 8 obj"]
      ORC["ORCHESTRATION - 3 obj"]
      NCT["X_NCT10TH - 15 obj, 291MB"]
    end
    DB3["SNOWFLAKE_LEARNING_DB"]
    DB4["USER$HKKIM"]
  end
  

2. Schema Detail

STUDIO_REALIVE_POC_DB (9 schemas, 251 objects, 2.0 GB)

SchemaTablesViewsRowsSizeRoleAI Services
AI43666,57716 MBAEON Collab, Chunks, Agent SPs AEON_AGENT AEON_ROLE_AGENT
AEON_COLLAB_SV COLLAB_SEARCH 62K
CORE69515,285,520456 MBKnowledge Graph ViewsSV base tables
ONTOLOGY8356,5523.5 MBBiz Model, Contracts, Slack DEMO_AGENT
SV_CONTRACTS SV_SLACK_ACTIVITY SV_MD_SALES SV_VR_TICKET
TICKET_OPS742,4850.1 MBTicket Sales, Expenses SV_TRIP_EXPENSES
MARKET_INTEL1424,183,9841.6 GBSERP, Social Buzz-
RAW_SOCIAL504,810,6251.9 GBSM Artist Buzz Raw-
RAW210121,56558 MBSlack/Gmail/Calendar JSON-
OPENFLOW50102,53020 MBOpenflow Slack Connector SLACK_SEARCH 94K SUSP
APP_GRAPH_UI013--Streamlit Graph Viewer-

FANDOM_LISTENING (5 schemas, 63 objects, 300 MB)

SchemaTablesViewsRowsSizeRoleAI Services
BRONZE32028,5925 MBApify/BD/Agent SP Raw-
SILVER5 DT010,1782.3 MBCleaned Dynamic Tables-
GOLD801,8840.2 MBSentiment/Ranking DTs-
ORCHESTRATION309,8591.6 MBPipeline, Stream, Task, Agent DATA_COLLECTOR
POC_FAN_SEARCH 10K SUSP
X_NCT10TH114635,377291 MBNCT 10th Quetai/Apify/Analysis-

3. Agent - Tool - Data Connection

flowchart LR
  subgraph AGENTS["Cortex Agents x5"]
    AEON["AEON_AGENT\n13 tools"]
    ROLE["AEON_ROLE\n2 tools"]
    DC["DATA_COLLECTOR\n9 tools"]
    DEMO["DEMO_AGENT\n7 tools"]
  end
  subgraph SV["Semantic Views x9"]
    SV_AC["AEON_COLLAB_SV"]
    SV_TK["SV_VR_TICKET"]
    SV_MD["SV_MD_SALES"]
    SV_CT["SV_CONTRACTS"]
    SV_SA["SV_SLACK_ACT"]
    SV_TE["SV_EXPENSES"]
  end
  subgraph CSS["Search Services x7"]
    CS["COLLAB_SEARCH\n62K ACTIVE"]
    PFS["POC_FAN_SEARCH\n10K SUSP"]
  end
  subgraph DATA["Base Data"]
    CORE_V["CORE Views\n5.3M rows"]
    TK["TICKET_OPS\n2.5K rows"]
    ONT_T["ONTOLOGY\nTables"]
    MSG["AI Chunks\n62K rows"]
    POC_U["POC_UNIFIED\n10K rows"]
  end
  AEON --> SV_AC
  AEON --> CS
  ROLE --> SV_AC
  DEMO --> SV_TK
  DEMO --> SV_MD
  DEMO --> SV_CT
  DEMO --> SV_SA
  DEMO --> SV_TE
  DEMO --> CS
  DC --> SV_TK
  DC --> SV_CT
  DC --> SV_SA
  DC --> PFS
  DC --> CS
  SV_AC --> CORE_V
  SV_TK --> TK
  SV_MD --> TK
  SV_CT --> ONT_T
  SV_SA --> ONT_T
  SV_TE --> TK
  CS --> MSG
  PFS --> POC_U
  

4. End-to-End Data Flow

flowchart TD
  subgraph EXT["External Sources"]
    SLACK["Slack API"]
    GMAIL["Gmail/Calendar"]
    APIFY["Apify"]
    BD["Bright Data"]
    QUETA["Quetai"]
    ASP["Agent SP"]
  end
  subgraph RAW_L["Raw Layer"]
    R1["RAW 122K rows"]
    R2["OPENFLOW 103K"]
    R3["RAW_SOCIAL 4.8M"]
    R4["BRONZE 29K"]
    R5["X_NCT10TH 636K"]
    R6["MARKET_INTEL 4.2M"]
  end
  subgraph PROC["Processing"]
    P1["CORE KG 5.3M"]
    P2["AI Chunks 67K"]
    P3["SILVER DT 10K"]
    P4["GOLD DT 1.9K"]
    P5["ONTOLOGY 57K"]
    P6["TICKET_OPS 2.5K"]
  end
  subgraph SERVE["Serving"]
    S1["Semantic Views x9"]
    S2["Cortex Search x7"]
    S3["Agents x5"]
    S4["Cowork"]
    S5["Streamlit"]
    S6["Slack Bot"]
  end
  SLACK --> R1
  SLACK --> R2
  GMAIL --> R1
  APIFY --> R4
  BD --> R4
  BD --> R6
  QUETA --> R5
  ASP --> R4
  ASP --> R6
  R1 --> P1
  R2 --> P2
  P1 --> P2
  R4 --> P3
  P3 --> P4
  R3 --> R6
  P2 --> S2
  P1 --> S1
  P5 --> S1
  P6 --> S1
  S1 --> S3
  S2 --> S3
  S3 --> S4
  S3 --> S6
  S1 --> S5
  

5. Warehouses

WarehouseSizeGenAuto-SuspendStatusUsage
SNOWFLAKE_LEARNING_WHXSGen2300sSTARTEDDefault, Agent/Search/Task
STUDIO_REALIVE_POC_WHXSGen260sSUSPENDEDAEON PoC
OPENFLOW_WHXSGen260sSUSPENDEDOpenflow Slack
COMPUTE_WHXSGen2300sSUSPENDEDGeneral
SYSTEM$STREAMLIT_NOTEBOOK_WHXSGen260sSUSPENDEDStreamlit/Notebook

6. AI Services

Cortex Agents

AgentSchemaModelToolsRole
AEON_AGENTAIclaude-sonnet-513AEON Collaboration (Routing V9)
AEON_ROLE_AGENTAI-2Role/R&R only
AEON_P9_FRESHNESSAI--P9 Experiment
DATA_COLLECTORORCHESTRATIONclaude-sonnet-4-59External Collection + Internal Query
DEMO_EXECUTIVE_ASSISTANTONTOLOGYauto7Executive Assistant (Ticket+MD+Expense+Slack+Web)

Semantic Views

Semantic ViewSchemaBase TablesAgent
AEON_COLLAB_SEMANTIC_VIEWAICORE 5 views (membership/event/file/msg/person)AEON_AGENT
SV_VR_TICKET_SALESONTOLOGYTICKET_SALES, VENUE_DAILY, V_SALES_CURVE, V_CITY_BENCHMARKDEMO / DC
SV_MD_SALESONTOLOGYMD sales + orders + benchmarkDEMO
SV_CONTRACTSONTOLOGYONTOLOGY.CONTRACTSDEMO / DC
SV_SLACK_ACTIVITYONTOLOGYONTOLOGY.VR_SLACK_ACTIVITYDEMO / DC
SV_TRIP_EXPENSESTICKET_OPSTICKET_OPS.TRIP_EXPENSESDEMO

Cortex Search Services

ServiceSchemaStatusRowsSourceAgent
COLLAB_SEARCHAIACTIVE62,353MESSAGE_CHUNK + DOCUMENT_CHUNKAEON / DEMO / DC
AEON_FRESH_V1AISUSP1,741V_AEON_FRESH_SOURCE_V1-
AEON_FRESH_V2AISUSP1,741(same)-
AEON_P9_FRESHAISUSP1,377AEON_P9_FRESH_SOURCE-
SLACK_CORTEX_SEARCHOPENFLOWSUSP94,279SLACK_MESSAGES + DOCS_CHUNKS-
POC_FAN_SEARCHORCHESTRATIONSUSP9,859SEARCH_POC_UNIFIEDDATA_COLLECTOR
CKE_SNOWFLAKE_DOCSSNOWFLAKE_DOCSACTIVE66,794Snowflake Documentation-
ACTIVE Search Services: COLLAB_SEARCH (62K) + CKE_SNOWFLAKE_DOCS (67K) only. 5 services are SUSPENDED.