Share on facebook
Share on linkedin
Share on twitter
Share on reddit

Connecting Looker to superQuery

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 

  1. Click on the Integrations link in the sidebar of superQuery:

  2. Enable your desired connection by clicking “Connect”
  3. After clicking “Connect” you’ll see the username and password screen, like so:

looker

 

  1.  Whitelist your IP Address if necessary
  2.  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

  1. Log in to Looker
  2. Go to the Admin tab

  3. In the Database section, click on Connections
  4. Click New Connection
  5. Fill in the details below:
    Host: bi.superquery.io Port: 3306

    looker-superQuery-newConnection

  6. Click Add Connection
  7. Boom! You’re all set.

Now you can start building your own beautiful dashboards. 
Query on! 🙂

Ready to run perfect queries?

Free to get started. No credit card required.

  • © 2019 superQuery. All rights reserved.