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
- Security → How Authentication and Token Exchange Work for SQL
- Platform Developer → Deploying the SQL Stack
- Tenant Platform → How the BFF API Works