Semantic SQL

The Semantic SQL system addresses common data warehouse challenges where similar concepts are represented by different column names across various tables and teams. It introduces a concept registry that allows columns to be tagged with semantic meanings at runtime, facilitating automatic JOIN path discovery between tables. Beyond semantic mapping, the system enforces robust access control via PostgreSQL Row-Level Security and application-layer checks, ensuring that users only access authorized rows and tables regardless of the SQL they write. It also features AST-based SQL validation to prevent unsafe queries, along with query caching and comprehensive audit logging, making it suitable for secure and efficient data exploration in complex, multi-team environments.

Key Features

Use Cases