Skip to main content
Connect Looker so Endgame can use the results of the Looker queries you choose. Endgame runs your saved queries once a day and includes what it finds in Endgame chats.

​
Before you start

  • You need to be an Endgame admin and a Looker admin.
  • You’ll need three things from Looker: a client ID, a client secret, and your tenant URL. See Get your Looker API credentials.

​
Get your Looker API credentials

  1. In Looker, click Admin in the left-hand menu.
  2. Click Users, then click your own name.
  3. Scroll down to API Keys and click Edit Keys.
  4. Click New API Key.
  5. Copy the Client ID and Client Secret and keep them somewhere safe. Looker only shows the client secret once.
Your tenant URL is the address you use to open Looker, such as https://your-company.looker.com. It must start with https:// and end in looker.com.

​
Connect Looker

  1. In Settings > Organization > Integrations, find Looker and click Connect. You can search for “Looker”, or choose Available to show only integrations you haven’t connected yet.
  2. Enter your Client ID, Client secret, and Tenant URL, then click Connect.
Connect Looker dialog with empty Client ID, Client secret and Tenant URL fields

Connecting Looker needs your client ID, client secret, and tenant URL.

Endgame opens the Looker page so you can add the queries you want it to use.

​
Add a query

  1. In Looker, open the Explore for the data you want Endgame to use.
  2. Click the gear icon at the top right, then click Share.
  3. From the Short URL, copy everything after the last /. That’s the query ID.
  4. In Endgame, on the Looker page, click Add query next to Saved queries.
  5. Paste the Query ID. Endgame shows a preview of the first 10 rows so you can check it’s the right one.
  6. Add a Description, which is required, and optionally a Title. Then click Add.
A title and description help Endgame understand what the data means, and help you tell your queries apart later. Once you add a query, Endgame starts bringing in its data.
Add query dialog with a query ID, title and description entered and a data preview of the query's rows

The Add query dialog previews a query's data before you add it.

Saved queries table with three queries showing Query ID, Title, Description and Date added, and an Add query button

Saved queries lists the Looker queries Endgame uses.

Looker queries usually describe your whole organization, so Endgame treats them as organization-wide data rather than tying them to one account.

​
Delete a query

In Saved queries, hover over the query, click the trash icon, and then click Delete. Endgame stops using that query’s data.

​
Update credentials or disconnect

Use the Connection section at the bottom of the Looker page. See Manage a connected integration.
  • Update credentials opens the same dialog as connecting, with nothing prefilled.
  • Disconnect stops syncing your saved queries, and Endgame imports no new Looker data.

​
Need help or have feedback?

We’d love to hear from you! You can reach us at support@endgame.io.