Skip to main content
Version: I2023.3.0

Creating 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 Looker-enabled license, and you know how to manage licenses in AtScale. For details, see Viewing and Updating Licenses.

Creating Looker connection to AtScale​

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

  2. Choose 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: Choose "Apache Hive 2".

    • Host:Port: For host, use the address of the server you just created and use "11111" as the port (or the port for your AtScale organization).

    • Database: The published project name.

      You can find it in AtScale by choosing Published Project > Cube Name > CONNECT Tab. 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.

      For example, given the JDBC URL jdbc:hive2://bitool1.atscale.com:11111/AdventureWorksDW2012Multidimensional-EE, the Looker "Database" field name should be set to "AdventureWorksDW2012Multidimensional-EE".

    • Username: a valid AtScale username.

    • Password: a valid AtScale password for the username account.

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