Creating a Looker Connection

To use Looker with AtScale, the first step is adding a new connection to the AtScale instance.

Before you begin

  1. Publish an AtScale project, so that there is a query end-point available.
  2. Ensure you have a Looker-enabled license, and you know how to manage licenses in AtScale. For details, see Viewing and Updating Licenses.


Note: If you upgraded AtScale to I2023.4.1 or later and you use Looker 23.16+, you must perform some additional steps to update your Looker connection to use PostgresSQL. For more information, see Changes Related to Upgrades.

Creating a Looker connection to AtScale

  1. In the Admin panel in Looker, choose Connections in the Database section.

  2. Click Add Connection.

  3. Fill in the following fields, using default values for the other settings:

    • Name: Create a name that you will use 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 PostgresSQL 9.5+.

    • Host: Enter the address of the database host.

    • Port: Enter 15432.

    • Database: Enter the published project name.

      You can find this information on the Connect tab of a published model in AtScale. Under Interface, see JDBC and copy the database name of the JDBC URL that is listed as a subdirectory after the //host:port/ portion of JDBC URL.

    • 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.


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.