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:
-
In Design Center, determine the name of the deployed catalog you want to connect to:
- Open the Deployed Catalogs panel, then open the catalog you want to connect to.
- Click the Connect tab. The Connection Settings page opens.
- Locate the JDBC field and make a note of the catalog name.
This appears after the
/host:port/
portion of the URL.
-
In Looker, open the Admin panel, then select Connections in the Database section.
-
Click Add Connection.
-
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.
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.