Data Warehousing

Data warehousing on DataNature is delivered directly on the open lakehouse — no separate warehouse and no data movement. Business-ready Gold data, modelled as dimensional and fact tables, is queried through a massively-parallel OLAP engine and exposed to analysts through DataNature BI and the governed semantic layer.

Foundation

• Gold layer — domain-modelled, certified, version-controlled datasets optimised for analytical performance.
• Apache Iceberg — ACID transactions, schema and partition evolution, time-travel for lookback, and predicate pushdown for efficient scans.
• Trino (MPP OLAP) — massively-parallel, fast interactive SQL, with query federation across sources.

Interfaces & Governance

• Integrated query editor for SQL exploration; DataNature BI (Apache Superset) for native dashboards on governed Gold data.
• Bring-your-own Power BI or Tableau through the semantic layer; Voir Chat (NLQ) for natural-language querying.
• All access governed by Atlas — least-privilege RBAC at row/column level, PII masking, lineage, and audit; time-travel supports reproducible, regulator-ready reporting.