Skip to main content

Connect from external business intelligence applications

While Imply Polaris includes built-in visualization capabilities, you can integrate Polaris with your existing business intelligence tools to explore, query, and share your data.

This topic describes how to connect Polaris to the following applications:

Prerequisites

To integrate Polaris with business intelligence tools, you need an API key with the AccessQueries permission. See Authenticate with API keys to obtain an API key. Visit Permissions reference for more information on permissions.

Also, make sure you have the following information required to complete the connection string:

  • REGION: The cloud region of your Polaris project.
  • CLOUD_PROVIDER: The cloud service provider for your Polaris infrastructure.
  • PROJECT_ID: The unique identifier for your Polaris project.

Authentication credentials

When establishing a connection to Polaris from an external application, you may be required to enter authentication credentials. You can use any string value as the username. For the password, enter your Polaris API key.

Tableau Desktop

Tableau provides a platform for analyzing, visualizing, and building reports from data. You can access your Polaris data from Tableau by establishing a Java Database Connectivity (JDBC) connection between Polaris and Tableau Desktop.

To connect Tableau Desktop to Polaris, follow these steps:

  1. Download the Avatica JDBC driver. We recommend using Avatica JDBC driver version 1.23.0 or later. Note that starting with Avatica 1.21.0, you may need to set the transparent_reconnection property to true if you notice intermittent query failures.

  2. Place the JAR file in the appropriate folder for your operating system. For example on a Mac, place the file in ~/Library/Tableau/Drivers. See the Tableau documentation for more details.

  3. Start Tableau Desktop. On the Connect pane, under To a Server, select Other Databases (JDBC).

  4. Set the following options:

    • URL: Specify the following JDBC connection string: jdbc:avatica:remote:url=https://PROJECT_ID.jdbc.REGION.CLOUD_PROVIDER.api.imply.io.
    • Dialect: Select SQL92.
    • Username: Leave this field blank.
    • Password: Pass in your API key.

    The following screen capture shows the configuration in Tableau Desktop version 2023.1.0:

    Tableau Desktop configuration

  5. Click Sign In. If the button is grayed out, verify that you entered the correct JDBC connection URL. Tableau directs you to the data source page when it successfully makes the connection.

  6. On the left pane, under Database, select druid.

  7. For Schema, select druid.

  8. Tableau displays the tables available in Polaris:

    Tableau Desktop connect a database

Looker

Looker is a business intelligence and data analytics platform. Connecting Looker to Polaris enables you to query your data directly from Looker.

To connect Looker to Polaris over JDBC, follow these steps:

  1. Download the Avatica JDBC driver. We recommend using Avatica JDBC driver version 1.23.0 or later. Note that starting with Avatica 1.21.0, you may need to set the transparent_reconnection property to true if you notice intermittent query failures.

  2. In the Admin section of Looker, navigate to Database > Connections > Add Connection.

  3. Set the following options:

    • Name: Assign a label to your connection.

    • Dialect: Select Apache Druid 0.18+.

    • Host: Specify the hostname in the format PROJECT_ID.jdbc.REGION.CLOUD_PROVIDER.api.imply.io.

    • Port: Enter port number 443.

    • Database: Specify database name druid.

    • Username: Assign any string.

    • Password: Pass in your API key.

      The following screen capture shows the configuration in Looker version 23.6.66: Looker connect a database

      Specify the other fields as desired, or leave them at default values.

  4. Click Test to verify the connection.

  5. Click Connect to save these settings.

    Looker connections

  6. Test the connection in SQL Runner. Navigate to SQL Runner, and select your connection and the druid schema. You should see your Polaris tables in the Tables menu.

    If you get the Couldn't Load Tables error due to authentication failure, verify that you have a valid API key in the Password field of the Looker connection.

Apache Superset

Apache Superset is a business intelligence web application that helps you explore and visualize data. You connect your Superset instance to Polaris using the SQLAlchemy connector.

To use Polaris in Superset, follow these steps:

  1. In Superset, go to Data > Connect a database and select Apache Druid from the list of supported databases.

  2. Enter the following SQLAlchemy connection string in the Add Database dialog:

    druid+https://apikey:POLARIS_API_KEY@ORGANIZATION_NAME.REGION.CLOUD_PROVIDER.api.imply.io:443/v1/projects/PROJECT_ID/query/sql

    In the connection string, replace POLARIS_API_KEY with your API key.

    For example:

    druid+https://apikey:pok_baQlrmvprWGAL...W3Lbmih@example_organization.us-east-1.aws.api.imply.io:443/v1/projects/12375ffx-f7x4-4f0x-a1a6-3b3424987ee0/query/sql

    The following screen capture shows the configuration in Superset version 2.0:

    Superset configuration

  3. Click Connect. Once connected, you should be able to retrieve and query Polaris tables from Superset.

    Superset connect a database

Grafana

You can install a plugin in Grafana to add the ability to query and visualize data stored in Polaris.

See Integrate with Grafana for more information, instructions, and examples.

Learn more

See the following topics for more information: