Skip to main content

Creating a Looker Connection

This topic describes how to create a Looker connection to AtScale.

Before you begin

  • Deploy an AtScale catalog, so there is a query end-point available.
  • Ensure you have a Looker-enabled AtScale license. For more information, see Viewing and Updating Licenses.

Creating a Looker connection to AtScale

To create a Looker connection to AtScale:

  1. In Design Center, determine the name of the deployed catalog you want to connect to:

    1. Open the Deployed Catalogs panel, then open the catalog you want to connect to.
    2. Click the Connect tab. The Connection Settings page opens.
    3. Locate the JDBC field and make a note of the catalog name. This appears after the /host:port/ portion of the URL.
  2. In Looker, open the Admin panel, then select Connections in the Database section.

  3. Click Add Connection.

  4. Complete the following fields, using default values for the others:

    • Name: Enter a name to uniquely identify this connection in your LookML code.

      Write this name down, because you will have to enter the exact name when configuring Looker in AtScale.

    • Dialect: Select PostgreSQL 9.5+.

    • Host: Enter the address of the database host.

    • Port: Enter 15432.

    • Database: Enter the name of the deployed catalog that you obtained above.

    • Username: Enter a valid AtScale username.

    • Password: Enter the password for the AtScale user defined by Username.

For more information about creating new connections in Looker, see Connecting Looker to your database.

info

Attention

Important: Using port 15432 for the Looker connection may cause the AtScale engine to restart repeatedly. If this occurs, go to Settings > Organization in AtScale and change the Port setting to 15732. You must restart the AtScale engine for the change to take effect.