SQL Lab
SQL Lab is the browser-based query editor available to data analysts and engineers. Queries run against the tenant's data sources directly — results stay inside the cluster and are never stored on Cogrion infrastructure.
Services Behind This Feature
| Service | Role |
|---|---|
| BFF API | Proxies all requests from the Cogrion UI to Superset. Performs token exchange so the user's session token is translated into a Superset-scoped token before the request is forwarded. |
| Superset | The SQL engine layer. Manages query execution, query history, saved queries, and results. Runs inside the tenant cluster. |
| Trino | The distributed query engine that Superset dispatches queries to. Handles the actual data retrieval across connected data sources. |
| Ranger | Enforces access policies on every query reaching Trino. Row-level and column-level restrictions are applied transparently before results are returned. |
Go Deeper
- How Authentication and Token Exchange Work for SQL — token exchange model from browser to Trino
- SQL Auth: Superset, Trino & Ranger — full end-to-end auth and policy enforcement flow
- Keycloak → Ranger Role Sync — how role assignments become Ranger policies
- Deploying the SQL Stack — platform developer reference
- How the BFF API Works — token exchange and request proxying internals