Multi-Tenant Data Lake + Semantic Layer

Medallion architecture · tenant isolation · semantic metrics catalog

Total Rows

13.1M

Tenants

5

Tables

418

Semantic Metrics

6

Medallion Architecture

Raw → Bronze → Silver → Gold

Raw Zone

Landing · immutable · schema-on-read

Rows4,820,000
Tables142
Freshness2m
→

Bronze

Cleansed · deduped · typed

Rows4,310,000
Tables138
Freshness4m
→

Silver

Conformed · joined · tenant-scoped

Rows3,120,000
Tables96
Freshness6m
→

Gold

Semantic marts · metric-ready

Rows890,000
Tables42
Freshness8m

Tenant Isolation

strict row-level security per tenant_id

Ailysi HQ

t-001

1,820,000 rows18 martsstricthealthy

Abiworkers

t-002

1,240,000 rows14 martsstricthealthy

SCCD Center

t-003

860,000 rows9 martsstricthealthy

Partner Gold-12

t-004

410,000 rows6 martsstrictsyncing

HealthcareOS Tenant

t-005

320,000 rows5 martsstricthealthy

Data Source Ingestion

Social OS

bronze

SocialPost · SocialAccount

124,000 rec2mrealtime

Worker OS

silver

TadbeerApplicant · Deployment

340,000 rec5m15m

Compliance OS

silver

ComplianceRecord · AuditLog

96,000 rec10mhourly

Financial OS

gold

CommissionLedger · Invoice

88,000 rec12mhourly

Partner OS

gold

PartnerAgent · PayoutRequest

64,000 rec8m15m

Design OS

bronze

ContentAsset · CreativeMemory

42,000 rec3mrealtime

Semantic Layer · Metric Explorer

Monthly Recurring Revenue

Select a metric and run a query to see the semantic layer in action.