Connecting Data Studio to superQuery

Share on facebook
Share on google
Share on linkedin
Share on twitter
These instructions explain how to connect your Data Studio 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”data-studio-connect
  3. After clicking “Connect” you’ll see the username and password screen, like so:

data-studio

  1.  Whitelist your IP Address if necessary
  2.  Copy the hostname and port from this window into your service of choice.
    • server: proxy.superquery.io
    • port: 3306

6.  Finalize the connection.

Prerequisite

  • For this integration, you will need to subscribe to Data Studio.

Connecting Data Studio to SuperQuery

  1. Log in to Data Studio
  2. Go to CONNECT TO DATA
  3. Search for MySQL connector

  4. Fill in the details below
    jdbc:mysql://proxy.superquery.io:3306/<project.dataset>?characterEncoding=latin1
  5. Insert your MySQL credentials
    Get your user and password from integrations section at superQuery IDE as described in the General prerequisites section.
  6. Click AUTHENTICATE.
  7. You are all set

Boom! You’re all set.

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

Close Menu