Spensara Spensara Knowledge Base & Documentation Repository

Repository Docs & Knowledge Base

Consolidated Spensara documentation repository (722 Markdown & architecture documents in ../repository)
Built Word Documents (.docx): Spensara Overview (.docx) Capability Assessment (.docx) Brink POS Ingestion Analysis (.docx) The Borg Ingestion Architecture (.docx)
architecture/c4/docs/C4/views.c4 2,680 bytes · Updated Oct 23, 2026 10:44 AM EDT
Raw File
views {
  view index {
    title 'Top-level overview'
    include *
    exclude element.tag = #integration_use_case
  }

  view kdsaioverview of kdsai {
    title 'KDS.AI System Context'
    include *
    include customersystem.**

    rank source {
        user,
        customersystem
    }

    // admin in this view is not relevant, so we exclude it to reduce clutter
    exclude admin
    exclude element.tag = #integration_use_case
  }

  // =========================================================================
  // ETL pipeline views
  // =========================================================================

  view etloverview of kdsai.etl {
    title 'ETL / Pipeline - Internal Components'
    description '
    Detail view of the simplified ETL pipeline.
    Shows the ingestion API, queue, ETL worker, S3 raw storage,
    S3 load files, S3 curated storage, and tenant Redshift databases.
    Includes UNLOAD to curated Parquet for cross-tenant query support.
    '

    include *
    include kdsai.warehouseDb
    exclude element.tag = #integration_use_case

    autoLayout TopBottom
  }

  view etl_with_sources of kdsai.etl {
    title 'ETL / Pipeline - With Data Sources'
    description '
    Simplified customer data ingestion flow.
    Shows the four standard ingestion modes feeding the ETL pipeline,
    which routes data into tenant Redshift databases and UNLOADs
    curated Parquet to S3 for cross-tenant Athena queries.
    '

    include *
    exclude element.tag = #integration_use_case

    // Include the data sources feeding into ETL
    include customersystem.**

    // Include downstream consumers and cross-tenant layer
    include kdsai.warehouseDb
    include kdsai.aibackend
    include kdsai.athena
    include kdsai.glueCatalog

    autoLayout TopBottom
  }

  // =========================================================================
  // Cross-tenant query layer views
  // =========================================================================

  view crosstenant of kdsai {
    title 'ETL / Cross-Tenant Query Layer'
    description '
    Dual-path query architecture.
    Single-tenant: AI agent queries Redshift tenant database directly.
    Cross-tenant: AI agent queries Athena over curated S3 Parquet,
    with Glue Data Catalog providing partition-projection table definitions.
    Platform injects tenant_id access control at query time.
    '

    include kdsai.aibackend
    include kdsai.warehouseDb
    include kdsai.athena
    include kdsai.glueCatalog
    include kdsai.etl.curatedStorage

    autoLayout TopBottom
  }
}