Looker Studio Direct Connection
What this covers
Shape A connects Looker Studio (formerly Data Studio) directly to Tessallite through Studio's PostgreSQL connector. Use it for SQL-shaped reporting without operating or licensing a Looker instance.
Looker Studio -> PostgreSQL connector -> Tessallite Gateway :5433 -> query routerThe gateway support is internally tested, but live Studio connection and query capture remain pending. Treat this guide as setup preview until live validation evidence is recorded.
Prerequisites and settings
- A deployed Tessallite model and user credentials.
- A gateway TCP endpoint reachable from Looker Studio.
GATEWAY_SSL_ENABLED=truewith a trusted certificate and key.
| Setting | Value |
|---|---|
| Host | Public gateway TCP hostname |
| Port | 5433 |
| Database | Workspace slug |
| Credentials | Tessallite user credentials |
| SSL | Required for supported internet-facing Data Studio validation |
Follow Google's current PostgreSQL connector networking and allowlisting instructions for the deployment region.
If Studio is indistinguishable from an ordinary PostgreSQL client in startup metadata and SQL shape, it continues to function but cannot be labeled automatically in diagnostics without an observed stable signature.
When to use the optional Looker-hosted workflow
Shape A is relational and does not consume generated LookML hints such as drill_fields, always_filter, or suggest_dimension. Those features require a separate Looker instance; see the optional Looker-hosted workflow.