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.

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.

Looker Connection Configuration

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

Looker Property Name

Ascend Connection Value

Name

Choose a desired name for the Connection

Dialect

Apache Spark 2.0

Remote Host

ascend-subdomain.sql.ascend.io

Port

10000

Database

default

Username / Password

The username and password generated from a Service Account's API Token

Persistent Derived Tables

False

SSL

True


Did this page help you?