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.

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.