These instructions explain how to connect your Looker account to superQuery’s query optimization engine.
When connected, your queries will pass through superQuery — where it will be automatically optimized — before being executed in BigQuery.
The result: a significant reduction in query costs and execution time.
General
- Click on the Integrations link in the sidebar of superQuery:
- Enable your desired connection by clicking “Connect”
- After clicking “Connect” you’ll see the username and password screen, like so:
- Whitelist your IP Address if necessary
- Copy the hostname and port from this window into your service of choice.
- server: bi.superquery.io
- port: 3306
6. Finalize the connection.
Prerequisites
Client
- For this integration, you will need to subscribe to Looker.
Connect Looker to superQuery
- Log in to Looker
- Go to the Admin tab
- In the Database section, click on Connections
- Click New Connection
- Fill in the details below:
Host: bi.superquery.io Port: 3306 - Click Add Connection
- Boom! You’re all set.
Now you can start building your own beautiful dashboards.
Query on! 🙂