Skip to main contentThe Looker Connector integration allows you to connect Google Looker Studio to the Ocient Hyperscale Data Warehouse (OHDW) for seamless retrieval and data visualization from the OHDW within Looker Studio.
Key Features
- Dynamic schema construction — Automatically builds Looker Studio schemas based on the OHDW schema.
- Custom query support — Build reports from custom queries.
- Automatic data type inference — Infers data types from sample data.
- Performance optimization — Pushes filtering and sorting operations down to the database level using the
WHERE and ORDER BY clauses.
Configuration Modes
The connector operates in two modes:
Normal Mode
In normal mode, the connector automatically generates the required query based on selected options in Looker Studio.
Custom Query Mode
In custom query mode, the connector utilizes only the specified columns or aliases from the query, determining their data types from sample query results. This flexible configuration enables tailored data integration and efficient reporting within Looker Studio.
