Tutorial of Creating a Looker Connection to Ascend

Ascend integrates with Looker through Ascend's JDBC connection. Looker directly link to Ascend Components. Each Ascend Component is mapped as a table in Looker.

2186

Create a Service Account and Generate Keys

Before you can connect to Looker you will need to create a Service Account and generate an API Token.

Creating a Service Account with permission 'Read Only' allows access to read data from any component in that Data Service. The permission 'Data Feed Read Only' will limit access to read data from only the data feeds.

Creating a Looker Connection to Ascend

  1. In Looker, navigate to "Admin" and "Connections" to create a new Connection.
  2. Add a new Connection of type "Database Connection".
  3. Fill in the Connection Configuration.
  4. Test the connection to ensure validity.
  5. Add the connection.
  6. Start exploring, querying, and analyzing your Ascend data.
2068

Looker Connection Configuration

The table below maps all the required Looker Configuration parameters to Ascend's required setting.

Looker Property NameAscend Connection Value
NameChoose a desired name for the Connection
DialectApache Spark 2.0
Remote Hostascend-subdomain.sql.ascend.io
Port10000
Databasedefault
Username / PasswordThe username and password generated from a Service Account's API Token
Persistent Derived TablesFalse
SSLTrue