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