> ## Documentation Index
> Fetch the complete documentation index at: https://docs.oleria.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Looker

> Connect Looker to Oleria to bring users, service accounts, groups, roles, API keys, OAuth apps, System Activity events, and Conversational Analytics agents from your Looker instance into your identity and access graph.

Connect Looker to Oleria to see who has access to your Looker instance: its users and service accounts, the groups and roles that grant their permissions, and the API keys and OAuth apps that can act in Looker. Oleria reads identity and access data with the API key of a Looker service account or user that holds the Admin role, so you can see where access is over-provisioned and act on it directly from Oleria.

This integration supports Looker (original) instances hosted by Google and Looker (Google Cloud core) instances, connected through their `looker.com` or `looker.app` address.

> [!NOTE]
>
> Looker Studio (formerly Google Data Studio) is a different product. This integration doesn't connect to Looker Studio, and access to Looker Studio reports isn't covered by it.

## What Oleria discovers

Once connected, Oleria continuously discovers and maps the following from your Looker instance:

* **Accounts** - every Looker user, with name, email address, and when the user last signed in. Disabled users are shown as disabled. Users with a verified two-factor authentication device are shown with multi-factor authentication (MFA) required. Users with a two-factor credential that's enabled but not yet verified are shown with MFA enrollment required. Users who sign in through SAML, OpenID Connect, Google, LDAP, Looker OpenID, or workforce identity federation are shown with single sign-on (SSO) configured. Embed users and Looker support employees are shown as external users. Users who hold a role with admin permissions are marked as administrators.
* **Non-human identities (NHIs)** - Looker service accounts, the API keys Looker returns for each user and service account (each shown as a credential owned by the user or service account it belongs to), and the OAuth client apps registered on the instance. For each OAuth app, Oleria shows the users who activated it, because the app acts in Looker on their behalf. Oleria never sees an API key's secret.
* **User groups** - every group, its direct members, and the groups nested inside it. Groups mirrored from your identity provider are marked as synced groups. Groups that Looker adds every new user to, such as **All Users**, are shown as built-in groups.
* **Roles** - every role, with its permission set and model set, and the users and groups that hold it.
* **Activity** - events from Looker's System Activity: sign-ins, failed sign-ins, sign-outs, and administrative changes to users, groups, roles, API keys, and OAuth apps, including sessions where an admin acted as another user. Oleria keeps every other System Activity event too, under its Looker event name.
* **AI agents** - when agent discovery is enabled for your workspace, the Conversational Analytics agents on your instance. See [AI agents](#ai-agents).

Oleria refreshes users, groups, and roles on its [regular sync schedule](https://docs.oleria.com/integrations/overview.md#sync-model). Activity syncs separately and trails real time by about 15 minutes.

> [!NOTE]
>
> Oleria doesn't import dashboards, Looks, folders, database connections, or the access to them. It imports LookML models and Explores only as the data sources of AI agents, when agent discovery is enabled, and not the access to them. This integration covers identity and access governance only.

## Prerequisites

* A Looker service account or user for Oleria to connect as, with the **Admin** role, held directly or through a group. Looker returns the API keys, service accounts, and OAuth apps of other users only to admins, and every remediation action needs admin permissions, so Oleria refuses the credentials of a user without them. Admin permissions also include reading System Activity.
* Admin access to Looker, to create the service account and its API key.
* A Looker instance at a `looker.com` or `looker.app` address. See [Known limitations](#known-limitations).
* If your Looker instance restricts access with an IP allowlist, Oleria's IP addresses added to it. Contact [support@oleria.com](mailto:support@oleria.com) for the current list. Otherwise Looker refuses Oleria's sign-in.
* Admin access to the Oleria workspace.

> [!WARNING]
>
> Connect with a dedicated Looker service account instead of a named person's account. If the account is disabled, deleted, or loses the Admin role, syncs and actions stop working.

## Create an API key in Looker

**1. Create or open a service account**

In Looker, go to **Admin** -> **Users**. Open the service account Oleria will connect as, or select **Add** -> **Service Account** to create one, and give it the **Admin** role.

**2. Create the API key**

On the service account's **Edit User** page, in the **API Keys** section, select **Manage**, then **Create New API Key**.

**3. Copy the credentials**

Copy the client ID and the client secret.

To connect as an admin user instead, a Looker admin must first allow that user to manage their own API keys. The user then creates the key from their own **Account** page: **API Keys** -> **Manage** -> **Create New API Key**. Admins can't create API keys for standard (human) users. See [Known limitations](#known-limitations).

> [!NOTE]
>
> The exact location of these settings can change over time. If the steps above don't match what you see, refer to Looker's own documentation.

## Connect Looker to Oleria

**1. Find Looker in Oleria**

Go to your Oleria workspace, select **Integrations**, select the **Available** tab, and search for **Looker**.

**2. Complete the connection form**

Select the **Looker** card and fill in the form:

| Field | Description |
| :- | :- |
| Instance URL | Required. Your Looker address, for example `https://yourcompany.looker.com` or `https://<id>.looker.app`. Oleria also accepts the API address ending in `/api/4.0`. It can't be changed after the integration is connected. |
| Client ID | Required. The client ID of the API key. |
| Client secret | Required. The client secret of the API key. Oleria stores it encrypted after it validates the credentials. |

**3. Authenticate**

Select **Authenticate**. Oleria signs in with the API key and checks that its user has admin permissions before it saves the connection.

## Verify the integration

Confirm the Looker instance appears on the **Connected** tab of your Oleria **Integrations** page with a status of **Healthy**. After the first sync completes, check that users, groups, and roles appear in your Oleria workspace. System Activity events appear after the first activity sync.

> [!NOTE]
>
> When you edit the integration, you can change the client ID and client secret, for example to rotate the API key, and select **Update**. Leave **Client secret** blank to keep the stored secret. If you change the client ID, enter its client secret too. You can't change the instance URL. To connect a different Looker instance, add a new integration.

## AI agents

When agent discovery is enabled for your workspace, Oleria discovers the Conversational Analytics agents on your Looker instance and shows them in the **Agents** inventory. To enable agent discovery, contact [support@oleria.com](mailto:support@oleria.com).

Looker offers agents only when a Looker admin has turned on the **Gemini in Looker** setting and its Conversational Analytics setting for the instance. If Looker refuses Oleria's request for agents, Oleria shows no Looker agents, and the rest of the sync still completes. Agent discovery needs no permission beyond the admin permissions in [Prerequisites](#prerequisites).

### What Oleria discovers about agents

| Detail | What Oleria shows |
| :- | :- |
| **Agent** | Each agent's name, description, the user who created it, and when it was created and last changed. Oleria shows whether it's a Conversational Analytics agent or a LookML agent. Deleted agents aren't shown. |
| **Data sources** | The Explores and LookML models the agent answers questions from. The agent queries them as the user chatting with it, with that user's access. |
| **Instructions** | The LookML agent definition the agent takes its instructions from, if it has one. Oleria doesn't read the instruction text. |
| **Parent agent** | The primary agent the agent belongs to, if it has one. |
| **Who Can Use** | The users and groups the agent is shared with through content access. View access lets them chat with the agent. Edit access also lets them change and share it. Sharing an agent doesn't give access to its Explores. |

If Looker refuses Oleria's request for one agent's content access, that agent is shown without the users and groups it's shared with.

## Remediation actions

Beyond discovery, Oleria can act on Looker access to remediate risk. Every action needs the Admin permissions described in [Prerequisites](#prerequisites).

| Action | What it does | Reversible? |
| :- | :- | :- |
| **Disable user accounts** | Disables a Looker user. Service accounts are refused: use **Disable NHI accounts** for them. | Yes - enables the user again. |
| **Enable user accounts** | Enables a disabled Looker user. Service accounts are refused. | Yes - disables the user again. |
| **Add user to group** | Adds the user to the group as a direct member. | Yes - removes the direct membership. |
| **Remove user from group** | Removes the user's direct membership in the group. | Yes - adds the direct membership back. |
| **Add user to role** | Adds the role to the user's directly assigned roles. The user's other roles stay as they are, but a role change made in Looker at the same moment can be overwritten. | Yes - removes the role again. |
| **Remove user from role** | Removes the role from the user's directly assigned roles. As with **Add user to role**, a role change made in Looker at the same moment can be overwritten. | Yes - assigns the role again. |
| **Disable NHI accounts** | Disables a service account, or disables an OAuth client app so Looker refuses every request from it. API keys are refused, because Looker can't disable an API key, only delete it. | Yes - enables the service account or OAuth app again. |
| **Revoke user session tokens** | Ends every web session of the user, so the user must sign in again in the browser. The user's API keys and OAuth app access keep working until you disable the user. If Oleria ends only some of the sessions, the action fails and reports how many it ended. | No - ended sessions can't be restored. |
| **Create user** | Creates a user with a first name, last name, and email address. Looker has no API to set a password, so Oleria ignores any password. Looker doesn't send the user a setup email: send one from Looker, or the user can't sign in. The user is created disabled unless the action activates it. The action fails if you include groups: create the user first, then use **Add user to group**. | Yes - deletes the user, as long as it still has the same email address. |
| **Create group** | Creates a group with the name you choose. | Yes - deletes the group, as long as it still has the same name and has no members, nested groups, or roles. |
| **Delete user** | Deletes a user or service account. | No - Looker can't restore a deleted user. |

Keep these limits in mind when you use these actions:

* Oleria reads the user, group, role, or identity before it changes anything. If it no longer exists in Looker, the action fails. The exception is **Remove user from role**: Oleria reads the user's roles, not the role itself, so if the role was deleted in Looker, the action succeeds with no change. If it's already in the requested state, Oleria makes no change and the action succeeds. For example, **Revoke user session tokens** succeeds without a change for a user with no open web sessions.
* If Looker returns an error but the target still ends up in the requested state, the action succeeds.
* Reverting an action undoes only the change that action made. When Oleria can't tell whether a change was made by the action or by someone else in Looker, it doesn't revert the change if the revert would give access back, such as re-enabling a user or service account, re-adding a membership, or re-enabling an OAuth app, and it doesn't revert **Create user** or **Create group**. Undo the change manually in Looker if needed.
* Oleria won't disable, delete, or revoke the sessions of the connection's own user or service account, or change its groups or roles, because that could disconnect the integration.
* Oleria won't create a user whose email address, or a group whose name, already exists in Looker.
* Groups mirrored from your identity provider, and roles of users whose roles your identity provider manages, can't be changed from Oleria. Change them in your identity provider. Oleria also can't add a user to a group when the user's SSO settings don't allow direct group membership, or change the roles of a user whose SSO settings don't allow directly assigned roles.
* **Remove user from role** removes only the direct assignment. If the user also holds the role through a group, the role stays in effect, and Oleria notes this on the action. If the user holds the role only through a group, the removal fails. To remove it, remove the user from the group, or the group from the role.
* **Remove user from group** works the same way. If the user also belongs to the group through a nested group, Oleria removes the direct membership and notes that the user is still a member. If the user belongs only through a nested group, the removal fails. Remove the user from the nested group instead.
* To stop an API key, disable the user or service account it belongs to.
* Oleria can't change permission sets or model sets.

## Known limitations

* **API keys of standard users.** Oleria shows a standard user's API keys only when Looker's user API returns them to the connection's admin. Starting with Looker 26.8 for Looker (original) and Looker 25.18 for Looker (Google Cloud core), admins can no longer manage standard users' API keys. A standard user whose API keys Looker doesn't return is shown without API access.
* **No account creation date or password change date.** Looker's API doesn't report when a user was created or last changed their password. User creation appears as activity.
* **No last-activity date for API keys, service accounts, or OAuth apps.** Looker doesn't report when an API key was last used, and service accounts sign in only with API keys, so Oleria can't flag a dormant non-human identity from its account data.
* **Instance-wide two-factor enforcement isn't shown.** Looker's API doesn't report whether two-factor authentication is required for the instance.
* **Embed secrets aren't inventoried.** Looker's API can create and delete embed secrets but can't list them.
* **Activity history is limited to 90 days.** Oleria reads at most the last 90 days of events. Looker trims its event log to the most recent 1 million events, so a busy instance can hold less.
* **API call quotas.** Each sync uses API calls for every group and role, and every Activity sync runs System Activity queries, with the first 90-day import using the most. Looker (Google Cloud core) Standard edition's monthly quotas can run out within days. Check your edition's quotas before connecting.
* **Looker-hosted instances only.** Oleria connects only to `looker.com` and `looker.app` addresses on the standard HTTPS port. Older instances that serve the API only on port 19999, and customer-hosted Looker deployments, aren't supported.
* **Custom domains and private IP addresses aren't supported.** A Looker (Google Cloud core) instance reachable only through a custom domain or a private IP address can't be connected.

## Contact us

For questions about this integration, contact us at [support@oleria.com](mailto:support@oleria.com).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.