Skip to content

Analytics · Beta

Looker
API integration

Ship Analytics features without building the integration. Full Looker API access via Proxy, normalized data through Unified APIs, and 290+ MCP-ready tools for AI agents — all extensible to your exact use case.

Built for specific customer use cases. Issues are resolved quickly.

Talk to us
Looker

Use Cases

Why integrate with Looker

Common scenarios for SaaS companies building Looker integrations for their customers.

01

Sync governed BI metrics into your product without raw SQL

SaaS platforms can pull pre-calculated, LookML-governed metrics (like churn scores or LTV) directly from a customer's Looker instance using the Query API, ensuring numbers match what executives see on their own dashboards.

02

Automate user provisioning and role enforcement across Looker

Compliance and identity management tools can use Truto's Unified User Directory API to continuously sync users and roles between an HRIS or IdP and Looker, ensuring offboarded employees lose access immediately and privilege escalations are flagged.

03

Programmatically configure alerts and scheduled data exports

Workflow automation and incident management platforms can create Looker alerts and scheduled plans via API, triggering downstream actions like ticket creation or Slack notifications when key metrics breach defined thresholds.

04

Let end users pick Looker metrics to sync via dynamic model discovery

SaaS apps can fetch a customer's available LookML models and Explores to populate a UI picker, letting business users choose exactly which Looker dimensions and measures flow into the product — no engineering ticket required.

05

Manage embedded dashboard content and theming at scale

Analytics-forward SaaS products can programmatically create dashboards, update filters, apply custom brand themes, and manage dashboard elements to deliver white-labeled embedded Looker experiences inside their own UI.

What You Can Build

Ship these features with Truto + Looker

Concrete product features your team can ship faster by leveraging Truto’s Looker integration instead of building from scratch.

01

Automated Looker access reviews for SOC2 compliance

Continuously list all Looker users, roles, and group memberships via Truto's Unified User Directory API and flag unauthorized access or orphaned accounts in your compliance dashboard.

02

Self-serve metric sync with LookML model browser

Use the LookML Models and Explores endpoints to let your users browse their Looker semantic layer and select which governed metrics to pull into your product on a recurring schedule.

03

Threshold-based incident creation from Looker alerts

Programmatically create and manage Looker alerts tied to critical KPIs, and route triggered alert notifications into your ticketing or incident management workflow.

04

Scheduled report delivery to external destinations

Create and manage Looker scheduled plans via API so your customers can configure recurring data exports (CSV, JSON) pushed to webhooks or cloud storage without leaving your product.

05

Cross-platform user and role provisioning

Mirror your application's team structure into Looker by creating groups, assigning roles, and managing user lifecycle events — all through a single Truto API call using the Unified User Directory.

06

Dynamic embedded dashboards with customer branding

Create Looker dashboards, apply custom color collections and themes, and update filters programmatically to deliver fully branded, context-aware analytics embeds inside your SaaS product.

SuperAI

Looker AI agent tools

Comprehensive AI agent toolset with fine-grained control. Integrates with MCP clients like Cursor and Claude, or frameworks like LangChain.

list_all_looker_users

Get information about all users in Looker. Returns user details including id, display_name, email, first_name, last_name, is_disabled, and credentials information.

get_single_looker_user_by_id

Get information about the user with a specific id in Looker. Returns full user information if the caller is an admin or the user themselves; otherwise returns minimal public info including user name and avatar URL.

delete_a_looker_user_by_id

Delete the user with id in Looker. This operation deletes the user and all looks and other information owned by the user.

create_a_looker_user

Create a user with the specified information in Looker. Returns the created user's id, display_name, email, first_name, last_name, is_disabled status, locale, role_ids, group_ids, and credentials details.

update_a_looker_user_by_id

Update information about the user with a specific id in Looker. Returns the updated user object including id, first_name, last_name, email, display_name, is_disabled, locale, role_ids, group_ids, and credentials details.

list_all_looker_user_roles

Get roles of a user by user_id in Looker. Returns role id, name, permission set (id, name, permissions), and model set (id, name, models).

update_a_looker_user_role_by_id

Set roles of the user with id in Looker. Returns an array of roles including id, name, permission_set (id, name, permissions), and model_set (id, name, models).

list_all_looker_roles

Get information about all roles in Looker. Returns an array of roles with fields including id (unique identifier), name, permission_set (with id, name, permissions), model_set (with id, name, models), url, and users_url.

get_single_looker_role_by_id

Get information about the role with id in Looker. Returns fields including id, name, permission_set (id, name, permissions), model_set (id, name, models), url, and users_url.

update_a_looker_role_by_id

Update all users of the role with id in Looker. Returns an array of users with fields including id, first_name, last_name, email, is_disabled, and credentials details.

create_a_looker_role

Create a role with specified name, permission_set_id, and model_set_id in Looker. Returns the role's id, name, permission set details including permissions, and model set details.

delete_a_looker_role_by_id

Delete the role with id in Looker. Returns 204 status on successful deletion.

get_single_looker_alert_by_id

Get an alert by id in Looker. Returns alert details including applied_dashboard_filters, comparison_type, cron schedule, custom_url settings, dashboard_element_id, description, destinations, field, id, is_disabled, is_public, investigative_content, owner info, and threshold.

create_a_looker_alert

Create a new alert in Looker with required fields field, destinations, comparison_type, threshold, and cron. Returns alert details including id, field, destinations, comparison_type, threshold, cron, and dashboard_element_id.

update_a_looker_alert_by_id

Update an alert by id in Looker. Requires owner_id, field, destinations, comparison_type, threshold, and cron. Returns updated alert with fields like applied_dashboard_filters, comparison_type, cron, destinations, field, threshold, and owner_id.

delete_a_looker_alert_by_id

Delete an alert by id in Looker. Returns 204 status on successful deletion.

looker_alert_search

Get a list of alerts in Looker. Returns alert fields including id, title, description, owner_display_name, is_disabled, threshold, destinations, and investigative_content_title.

looker_alert_follow

Follow an alert by alert_id in Looker. Returns no content on success.

looker_alert_unfollow

Unfollow an alert by id in Looker. Returns no content on success.

looker_alert_select_fields

Update select fields of an alert by id in Looker. Returns the updated alert including fields like id, owner_id, is_disabled, disabled_reason, is_public, threshold, description, and destinations.

looker_alert_enqueue

Enqueue an alert by id in Looker. Returns 204 if the alert is successfully added to the queue. Includes error details and documentation_url in case of failure.

looker_alert_notifications

Get all alert notifications received by the user on email in the past 7 days in Looker. Returns notification_id, alert_condition_id, user_id, is_read, field_value, threshold_value, ran_at, and alert details including title, alert_id, investigative_content_id, dashboard_name, dashboard_id, and query_slug.

looker_alert_read_notification

Mark an alert notification as read by the user in Looker. Requires id of the alert notification. Returns notification fields including notification_id, alert_condition_id, user_id, is_read, field_value, threshold_value, ran_at, and alert details such as title, alert_id, investigative_content_id, dashboard_name, dashboard_id, and query_slug.

list_all_looker_board

Get information about all boards in Looker. Returns fields including id, title, description, created_at, updated_at, user_id, primary_homepage, board_sections, and board_items with details about each board's content and organization.

get_single_looker_board_by_id

Get information about a specific board in Looker by id. Returns fields including board id, title, description, created_at, updated_at, user_id, primary_homepage, board_sections with their details, and board_items with content metadata and display information.

create_a_looker_board

Create a new board in Looker. Returns the created board including id, title, description, user_id, created_at, updated_at, primary_homepage, and board_sections.

update_a_looker_board_by_id

Update a board definition in Looker by board id. Returns updated board with fields including id, title, description, board_sections, created_at, updated_at, user_id, and primary_homepage.

delete_a_looker_board_by_id

Delete a board by id in Looker. Returns no content on success.

looker_board_search

Get a list of boards in Looker filtered by search parameters such as title, created_at, first_name, last_name, favorited, and creator_id. Returns board fields including id, title, description, created_at, updated_at, user_id, and board_sections.

list_all_looker_board_items

Get information about all board items in Looker. Returns fields including id, title, description, url, favorite_count, and view_count for each board item.

get_single_looker_board_item_by_id

Get information about a specific board item in Looker by id. Returns fields including id, title, description, url, favorite_count, view_count, and associated content metadata.

create_a_looker_board_item

Create a new board item in Looker. Returns the created board item's id, title, description, url, and associated content metadata including dashboard_id, look_id, and lookml_dashboard_id.

update_a_looker_board_item_by_id

Update a board item by id in Looker. Returns the updated board item including fields like id, title, description, custom_title, custom_description, custom_url, dashboard_id, look_id, lookml_dashboard_id, board_section_id, order, image_url, custom_image_url, use_custom flags, favorite_count, and view_count.

delete_a_looker_board_item_by_id

Delete a board item by id in Looker. Returns 204 status on successful deletion.

list_all_looker_board_sections

Get information about all board sections in Looker. Returns fields including id, description, board_id, created_at, updated_at, deleted_at, and board_items with details such as title, url, and order.

get_single_looker_board_section_by_id

Get information about a board section by id in Looker. Returns fields including created_at, deleted_at, description, board_id, board_items with details like content metadata, custom titles, and view counts.

create_a_looker_board_section

Create a new board section in Looker. Requires a BoardSection object with board_id and description. Returns the created board section with id, title, description, board_items, created_at, and updated_at fields.

update_a_looker_board_section_by_id

Update a board section by id in Looker. Returns the updated board section including id, description, board_id, title, board_items with details like content metadata, custom titles, and timestamps.

delete_a_looker_board_section_by_id

Delete a board section by id in Looker. Returns no content on success.

list_all_looker_color_collections

Get all existing color collections in Looker. Returns an array of color collections including id, label, categoricalPalettes, sequentialPalettes, and divergingPalettes with their respective details.

get_single_looker_color_collection_by_id

Get a specific Color Collection by id in Looker. Returns id, label, categoricalPalettes, sequentialPalettes, and divergingPalettes with their colors and offsets.

list_all_looker_custom_color_collections

Get all Custom Color Collections in Looker. Returns an array of color collections with fields id, label, categoricalPalettes, sequentialPalettes, and divergingPalettes.

update_a_looker_custom_color_collection_by_id

Update a custom color collection by id in Looker. Returns the updated collection's id, label, categoricalPalettes, sequentialPalettes, and divergingPalettes.

create_a_looker_custom_color_collection

Create a new custom color collection in Looker. Returns the created color collection with id, label, categoricalPalettes, sequentialPalettes, and divergingPalettes.

delete_a_looker_custom_color_collection_by_id

Delete a custom color collection by id in Looker. Only custom collections can be deleted; standard collections cannot. Returns success or error details in the response.

list_all_looker_standard_color_collections

Get all existing Standard Color Collections in Looker. Returns an array of color collections including id, label, categoricalPalettes, sequentialPalettes, and divergingPalettes.

list_all_looker_connections

Get information about all connections in Looker. Returns an array of connections with fields including name, label, dialect details, host, port, database, schema, and authentication settings.

get_single_looker_connection_by_id

Get information about a specific connection in Looker by connection_name. Returns fields including name, dialect details, host, port, username, database, schema, and connection capabilities.

create_a_looker_connection

Create a connection using the specified configuration in Looker. Returns connection details including name, dialect, host, port, username, database, schema, and connection settings.

update_a_looker_connection_by_id

Update a connection by name in Looker. Requires connection_name as id. Returns updated connection details including name, host, port, username, database, schema, SSL settings, and other configuration fields.

delete_a_looker_connection_by_id

Delete a connection by name in Looker. Requires connection_name as id. Returns 204 status on successful deletion.

looker_connections_test

Test an existing connection by connection_name in Looker. Returns test results including name, status, message, and connection_string for the 'connect' test.

looker_connections_test_configuration

Test a connection configuration in Looker by providing a DBConnection object. Returns test results including name, status, and message for each test performed.

get_single_looker_default_color_collection_by_id

Get the default color collection in Looker. Returns id, label, categoricalPalettes (id, label, type, colors), sequentialPalettes (id, label, type, stops with color and offset), and divergingPalettes (id, label, type, stops with color and offset).

update_a_looker_default_color_collection_by_id

Set the global default Color Collection by collection_id in Looker. Returns the updated Color Collection object including id, label, and palettes.

list_all_looker_ssh_servers

Get information about all SSH Servers in Looker. Returns ssh_server_id, ssh_server_name, ssh_server_host, ssh_server_port, ssh_server_user, finger_print, sha_finger_print, public_key, and status for each server.

get_single_looker_ssh_server_by_id

Get information about an SSH Server by id in Looker. Returns ssh_server_id, ssh_server_name, ssh_server_host, ssh_server_port, ssh_server_user, finger_print, sha_finger_print, public_key, and status fields.

create_a_looker_ssh_server

Create an SSH Server in Looker. Returns ssh_server_id, ssh_server_name, ssh_server_host, ssh_server_port, ssh_server_user, finger_print, sha_finger_print, public_key, and status in the response.

update_a_looker_ssh_server_by_id

Update an SSH Server by id in Looker. Returns ssh_server_id, ssh_server_name, ssh_server_host, ssh_server_port, ssh_server_user, finger_print, sha_finger_print, public_key, and status fields in the response.

delete_a_looker_ssh_server_by_id

Delete an SSH Server by id in Looker. Returns 204 status on successful deletion.

looker_ssh_servers_test

Test the SSH Server connection using id. Returns ssh_server_id, ssh_server_name, ssh_server_host, ssh_server_port, ssh_server_user, finger_print, sha_finger_print, public_key, and status fields in the response.

list_all_looker_ssh_tunnels

Get information about all SSH Tunnels in Looker. Returns tunnel_id, ssh_server_id, ssh_server_name, ssh_server_host, ssh_server_port, ssh_server_user, last_attempt, local_host_port, database_host, database_port, and status for each tunnel.

get_single_looker_ssh_tunnel_by_id

Get information about an SSH Tunnel by id in Looker. Returns tunnel_id, ssh_server_id, ssh_server_name, ssh_server_host, ssh_server_port, ssh_server_user, last_attempt, local_host_port, database_host, database_port, and status.

create_a_looker_ssh_tunnel

Create an SSH Tunnel in Looker. Returns tunnel_id, ssh_server_id, ssh_server_name, ssh_server_host, ssh_server_port, ssh_server_user, last_attempt, local_host_port, database_host, database_port, and status fields in the response.

update_a_looker_ssh_tunnel_by_id

Update an SSH Tunnel by id in Looker. Returns tunnel_id, ssh_server_id, ssh_server_name, ssh_server_host, ssh_server_port, ssh_server_user, last_attempt, local_host_port, database_host, database_port, and status fields in the response.

delete_a_looker_ssh_tunnel_by_id

Delete an SSH Tunnel by id in Looker. Returns 204 status on successful deletion.

looker_ssh_tunnels_test

Test the SSH Tunnel with id in Looker. Returns tunnel_id, ssh_server_id, ssh_server_name, ssh_server_host, ssh_server_port, ssh_server_user, last_attempt, local_host_port, database_host, database_port, and status indicating the current connection status.

looker_ssh_tunnels_public_key

Get the SSH public key created for this instance in Looker. Returns the public_key string used to identify the instance to a remote SSH server.

list_all_looker_dialects

Get information about all dialects in Looker. Returns fields such as name, label, default port, installed status, supported driver name and versions, and supported options indicating capabilities of each dialect.

list_all_looker_external_oauth_applications

Get all External OAuth Applications in Looker. Returns id, name, client_id, tenant_id, dialect_name, and created_at for each application.

create_a_looker_external_oauth_application

Create an External OAuth Application in Looker with name, client_id, client_secret, tenant_id, and dialect_name. Returns id, name, client_id, tenant_id, dialect_name, and created_at.

update_a_looker_external_oauth_application_by_id

Update External OAuth Application client secret by client_id in Looker. Returns id, name, client_id, tenant_id, dialect_name, and created_at fields in the response.

get_single_looker_favorite_content_by_id

Get favorite content by id in Looker. Returns id, user_id, content_metadata_id, look_id, dashboard_id, and associated look and dashboard details.

create_a_looker_favorite_content

Create favorite content in Looker with user_id and content_metadata_id. Returns id, user_id, content_metadata_id, look_id, dashboard_id, and associated look and dashboard details.

delete_a_looker_favorite_content_by_id

Delete favorite content by id in Looker. Returns 204 status on successful deletion.

looker_favorite_contents_search

Search favorite contents by id, user_id, content_metadata_id, dashboard_id, look_id, or board_id in Looker. Returns id, user_id, content_metadata_id, look_id, dashboard_id, board_id, and associated look and dashboard details.

list_all_looker_content_metadata

Get all content metadata with optional parent_id in Looker. Returns id, name, parent_id, dashboard_id, look_id, folder_id, content_type, inherits, inheriting_id, and slug fields for each content metadata.

get_single_looker_content_metadatum_by_id

Get information about an individual content metadata record in Looker by id. Returns fields including id, name, parent_id, dashboard_id, look_id, folder_id, content_type, inherits, inheriting_id, and slug.

update_a_looker_content_metadatum_by_id

Update content metadata by id in Looker. Returns updated content metadata including id, name, parent_id, dashboard_id, look_id, folder_id, content_type, inherits, inheriting_id, and slug.

list_all_looker_content_metadata_access

Get all content metadata access records for a content metadata item in Looker. Requires content_metadata_id. Returns id, content_metadata_id, permission_type, group_id, and user_id fields.

create_a_looker_content_metadata_access

Create content metadata access with content_metadata_id, permission_type, and either group_id or user_id in Looker. Returns id, content_metadata_id, permission_type, group_id, user_id, and can operations.

update_a_looker_content_metadata_access_by_id

Update type of access for content metadata in Looker by content_metadata_access_id. Returns id, content_metadata_id, permission_type, group_id, and user_id fields reflecting the updated access.

delete_a_looker_content_metadata_access_by_id

Delete content metadata access by id in Looker. Returns no content on success.

list_all_looker_datagroups

Get information about all datagroups in Looker. Returns an array of datagroups with fields including id, model_name, name, created_at, stale_before, trigger_check_at, trigger_error, trigger_value, and triggered_at.

get_single_looker_datagroup_by_id

Get information about a datagroup by id in Looker. Returns id, model_name, name, stale_before, trigger_value, triggered_at, trigger_error, created_at, and trigger_check_at fields.

update_a_looker_datagroup_by_id

Update a datagroup by id in Looker. Returns the datagroup's id, model_name, name, stale_before timestamp, trigger_check_at timestamp, trigger_error message, trigger_value, and triggered_at timestamp.

list_all_looker_folders

Get information about all folders in Looker. Returns all personal folders with fields including id, name, parent_id, content_metadata_id, created_at, creator_id, child_count, and flags indicating folder type.

get_single_looker_folder_by_id

Get information about the folder with a specific id in Looker. Returns folder details including name, parent_id, content_metadata_id, created_at, creator_id, child_count, and various folder type flags.

create_a_looker_folder

Create a folder with specified name and parent_id in Looker. Returns folder id, name, parent_id, creator_id, created_at, child_count, and folder type flags. Requires permission to edit parent folder and create folders.

update_a_looker_folder_by_id

Update the folder with id in Looker. Returns folder details including name, parent_id, id, content_metadata_id, created_at, creator_id, child_count, and various folder type flags.

delete_a_looker_folder_by_id

Delete the folder with id including any children folders in Looker. This operation deletes all looks and dashboards in the folder. Returns 204 on success or error details on failure.

looker_folders_search

Search folders by name, id, parent_id, or creator_id in Looker. Returns folder details including id, name, parent_id, creator_id, child_count, and flags indicating folder type such as is_personal or is_shared_root.

list_all_looker_folder_children

Get the children of a folder in Looker by folder id. Returns folder children including id, name, parent_id, created_at, creator_id, child_count, and flags indicating folder type and permissions.

looker_folder_children_search

Get the children of a folder in Looker by folder id. Returns folder children with fields including id, name, parent_id, child_count, and metadata about embed and personal folder status.

get_single_looker_folder_parent_by_id

Get the parent folder of a folder in Looker by folder id. Returns fields including id, name, parent_id, created_at, creator_id, child_count, and folder type flags.

list_all_looker_folder_ancestors

Get the ancestors of a folder in Looker by folder id. Returns an array of folders with fields including id, name, parent_id, created_at, and flags indicating folder type and permissions.

list_all_looker_folder_looks

Get all looks in a folder in Looker by folder id. Returns look id, title, description, user_id, created_at, updated_at, favorite_count, view_count, query_id, and folder details. Excludes looks in trash.

list_all_looker_folder_dashboards

Get dashboards in a folder in Looker by folder id. Returns dashboard id, title, description, created_at, updated_at, user_name, favorite_count, and other dashboard details.

list_all_looker_groups

Get information about all groups in Looker. Returns group id, name, user_count, can_add_to_content_metadata, contains_current_user, externally_managed, external_group_id, include_by_default, and can operations fields.

get_single_looker_group_by_id

Get information about a specific group in Looker by id. Returns fields including id, name, user_count, include_by_default, externally_managed, external_group_id, contains_current_user, can_add_to_content_metadata, and can.

create_a_looker_group

Create a new group in Looker. Requires group name. Returns group id, name, user_count, include_by_default, externally_managed, external_group_id, can_add_to_content_metadata, and contains_current_user.

update_a_looker_group_by_id

Update a group by id in Looker. Returns the group's id, name, user_count, include_by_default, external_group_id, externally_managed, can_add_to_content_metadata, and contains_current_user fields.

delete_a_looker_group_by_id

Delete a group by id in Looker. Returns 204 status on successful deletion.

looker_groups_search

Get all group records matching search criteria in Looker. Returns fields including id, name, external_group_id, externally_managed, include_by_default, and user_count.

looker_groups_search_roles

Search groups with roles in Looker using search criteria. Returns group id, name, external_group_id, externally_managed, user_count, and associated roles with id, name, permission set, and model set.

looker_groups_search_hierarchy

Get all group records matching search criteria in Looker. Returns group id, name, external_group_id, externally_managed, user_count, parent_group_ids, and role_ids fields. Supports filter_or for OR logic.

list_all_looker_subgroups

Get all subgroups of a group in Looker by group id. Returns fields including id, name, user_count, external_group_id, externally_managed, include_by_default, can_add_to_content_metadata, and contains_current_user.

create_a_looker_subgroup

Add a new group to a group in Looker using group_id. Returns the added group's id, name, user_count, and membership details.

delete_a_looker_subgroup_by_id

Delete a subgroup identified by deleting_group_id from a group identified by id in Looker. Returns no content on success.

list_all_looker_group_users

Get all users directly included in a group in Looker by group_id. Returns user details including id, display_name, email, first_name, last_name, is_disabled, and credentials information.

create_a_looker_group_user

Add a user to a group in Looker by specifying group id and user_id. Returns the added user's details including id, display_name, email, first_name, last_name, is_disabled, and credentials information.

delete_a_looker_group_user_by_id

Remove a user from a group in Looker. Requires group_id and user_id. Returns 204 status on success or error details on failure.

update_a_looker_user_attribute_group_value_by_id

Set the value of a user attribute for a group in Looker. Requires group_id and user_attribute_id. Returns the updated group attribute relation including id, group_id, user_attribute_id, value, value_is_hidden, and rank.

delete_a_looker_user_attribute_group_value_by_id

Delete user attribute value for group using group_id and user_attribute_id in Looker. Returns 204 on success or error details on failure.

list_all_looker_homepage

Get all primary homepage sections in Looker. Returns fields including id, title, description, created_at, updated_at, homepage_items with details like content metadata, custom titles, and URLs.

list_all_looker_integration_hubs

Get information about all integration hubs in Looker. Returns id, url, label, official status, fetch_error_message, has_authorization_token, legal_agreement_signed, legal_agreement_required, and legal_agreement_text fields for each hub.

get_single_looker_integration_hub_by_id

Get information about a specific Integration Hub in Looker by id. Returns fields including id, url, label, official status, fetch_error_message, legal agreement details, and authorization token status.

create_a_looker_integration_hub

Create a new integration hub in Looker. Returns hub id, url, label, official status, fetch error message if any, authorization token status, and legal agreement details.

update_a_looker_integration_hub_by_id

Update an integration hub by id in Looker. Returns updated hub fields including id, url, label, official status, fetch_error_message, has_authorization_token, legal agreement status, and legal agreement text.

delete_a_looker_integration_hub_by_id

Delete an integration hub by id in Looker. Returns no content on success.

looker_integration_hubs_accept

Accept the legal agreement for a specific integration hub in Looker using id. Returns integration hub details including id, label, url, legal agreement status, and error messages if any.

list_all_looker_integration

Get information about all integrations in Looker. Returns fields including id, integration_hub_id, label, description, enabled status, params, icon_url, uses_oauth, and privacy_link.

get_single_looker_integration_by_id

Get information about a specific integration in Looker by id. Returns fields including id, integration_hub_id, label, description, enabled status, params with details, icon_url, oauth usage, and privacy_link.

update_a_looker_integration_by_id

Update parameters on a Looker integration using integration id. Returns updated integration including id, label, description, enabled status, params with name, value, and sensitivity, supported formats, and oauth usage.

looker_integration_fetch

Get the integration form for the integration with id in Looker. Returns fields including name, label, description, type, default, oauth_url, interactive, required, and options for user input.

looker_integration_test

Test the integration settings for integration with id. Returns success status, message, and delegate OAuth test results including connection name, installation target id, installation id, and success.

list_all_looker_looks

Get all active Looks in Looker. Returns an array of abbreviated Look objects including id, title, user_id, created_at, description, model, folder, and other metadata. Soft-deleted Looks are excluded.

get_single_looker_look_by_id

Get detailed information about a Look by id in Looker. Returns fields including id, title, description, user_id, created_at, updated_at, folder info, query details, and URLs related to the Look.

create_a_looker_look

Create a look with query_id and optional space_id in Looker. Returns the created look including id, title, user_id, created_at, description, query_id, folder_id, updated_at, and view_count.

update_a_looker_look_by_id

Modify a look by id in Looker. Update properties such as title, description, query_id, folder_id, and deleted status. Returns the updated look with fields including id, title, description, user_id, created_at, deleted, and query details.

delete_a_looker_look_by_id

Permanently delete a look by id in Looker. This operation removes the look from the database with no undo option. The response confirms successful deletion or returns error details.

looker_looks_run

Run a look's query by look_id in Looker and return results in json_bi format including row data and metadata describing fields, pivots, and table calculations.

looker_looks_copy

Create a copy of an existing look identified by id in Looker, placing it in the folder specified by folder_id. Returns the copied look with fields including id, title, user_id, created_at, description, favorite_count, model, folder, and query details.

looker_looks_move

Move a look identified by id to a specified folder using folder_id in Looker. Returns the moved look with fields including id, title, user_id, created_at, description, model, folder, and query details.

list_all_looker_lookml_models

Get information about all LookML models in Looker. Returns fields including name (unique identifier), label (UI-friendly name), project_name, explores (with name, description, label, hidden status), and model capabilities.

get_single_looker_lookml_model_by_id

Get information about a specific LookML model by id in Looker. Returns fields including name, label, project_name, explores (with name, description, label, hidden, group_label, has_content), allowed_db_connection_names, and unlimited_db_connections.

create_a_looker_lookml_model

Create a LookML model with specified configuration in Looker. Requires model name, project_name, and other model details. Returns the created model's name, label, project_name, explores, allowed_db_connection_names, and unlimited_db_connections status.

update_a_looker_lookml_model_by_id

Update a LookML model by name in Looker. Requires id as the model name. Returns updated model fields including name, label, project_name, explores with their name, description, label, hidden status, and allowed_db_connection_names.

delete_a_looker_lookml_model_by_id

Delete a LookML model by name in Looker. Requires id as the lookml_model_name. Returns 204 status on successful deletion.

get_single_looker_lookml_model_explore_by_id

Get information about a LookML model explore in Looker using lookml_model_name and explore_name. Returns fields including id, name, description, label, title, permissions, connection_name, project_name, model_name, view_name, sql_table_name, fields, joins, and errors.

list_all_looker_themes

Get an array of all existing themes in Looker. Returns fields including id, name, begin_at, end_at, and settings which contain theme customization details.

get_single_looker_theme_by_id

Get a theme by id in Looker. Returns fields including id, name, begin_at, end_at, and settings with theme colors and display options. Custom themes require enabling by Looker.

create_a_looker_theme

Create a new theme in Looker with a specified name and settings. Returns the theme's id, name, begin_at, end_at, and settings including colors and display options. Theme name must be alphanumeric or underscores.

update_a_looker_theme_by_id

Update the theme by id in Looker. Requires id and theme settings. Returns updated theme with fields id, name, begin_at, end_at, and settings including colors, fonts, and display toggles.

delete_a_looker_theme_by_id

Delete a specific theme by id in Looker. This operation permanently deletes the identified theme. Only theme id is required. Custom themes must be enabled by Looker to use this feature.

looker_themes_search

Get an array of theme objects matching search criteria in Looker. Supports filtering by id, name, begin_at, and end_at timestamps. Returns fields including id, name, begin_at, end_at, and settings with theme details.

looker_themes_active

Get active themes in Looker. Returns an array of active themes with fields including id, name, begin_at, end_at, and settings which define theme appearance and behavior. Note: Custom themes require enabling by Looker.

looker_themes_validate

Validate a theme with the specified information in Looker. Returns any validation errors or 200 OK if valid. The response includes error details such as field, code, and message if validation fails.

get_single_looker_default_theme_by_id

Get the active default theme in Looker. Returns the theme's id, name, active period timestamps, and detailed settings including colors, fonts, and display toggles.

update_a_looker_default_theme_by_id

Set the global default theme by name in Looker. Requires the name of an active theme with no expiration. Returns the new default theme object including id, name, begin_at, end_at, and settings.

list_all_looker_user_attributes

Get all user attributes in Looker. Returns an array of user attributes including id, name, label, type, default_value, is_system, is_permanent, value_is_hidden, user_can_view, user_can_edit, and hidden_value_domain_whitelist.

get_single_looker_user_attribute_by_id

Get information about a user attribute by id in Looker. Returns id, name, label, type, default_value, is_system, is_permanent, value_is_hidden, user_can_view, user_can_edit, and hidden_value_domain_whitelist fields.

create_a_looker_user_attribute

Create a new user attribute in Looker. Requires unique name and label. Returns id, name, label, type, default_value, is_system, is_permanent, value_is_hidden, user_can_view, user_can_edit, and hidden_value_domain_whitelist fields.

update_a_looker_user_attribute_by_id

Update a user attribute by id in Looker. Returns fields including id, name, label, type, default_value, is_system, is_permanent, value_is_hidden, user_can_view, user_can_edit, and hidden_value_domain_whitelist.

delete_a_looker_user_attribute_by_id

Delete a user attribute by id in Looker. Returns 204 status on successful deletion.

list_all_looker_user_attribute_group_value

Get all values of a user attribute defined by user groups in precedence order in Looker. Requires user_attribute_id as id. Returns group_id, value, rank, and value_is_hidden indicating if the value is accessible.

update_a_looker_user_attribute_group_value_by_id

Set user attribute group values for user_attribute_id in Looker. Returns an array of group values including id, group_id, user_attribute_id, value_is_hidden, rank, and value fields reflecting the updated group value definitions.

list_all_looker_workspaces

Get all workspaces available to the calling user in Looker. Returns workspace id, projects with project id, name, git configuration, and dependency status.

get_single_looker_workspace_by_id

Get information about a specific workspace in Looker by workspace id. Returns workspace id, git status, selected branches of all projects, and project details including git configuration and validation policies.

get_single_looker_session_auth_by_id

Get information about the current API session in Looker. Returns workspace_id indicating the active workspace and sudo_user_id if the session represents a user sudo'ing as another.

update_a_looker_session_auth_by_id

Update the active workspace for the current API session in Looker by setting workspace_id. Returns the updated session with workspace_id and sudo_user_id fields.

looker_reports_search

Get an array of Report objects matching specified search criteria in Looker. Returns fields including id, title, user_id, created_at, updated_at, last_viewed_at, favorite, favorite_count, view_count, folder details, url, user_name, deleted_at, last_accessed_at, deleter_user_id, deleter_user_name, and schedule_count.

get_single_looker_artifact_usage_by_id

Get the maximum configured size and currently used storage in bytes of the entire artifact store in Looker. Returns max_size and usage fields representing storage limits and usage.

list_all_looker_artifact_namespace

Get all artifact namespaces and the count of artifacts in each namespace in Looker. Returns namespace and count fields for each artifact namespace.

list_all_looker_artifact

Get one or more artifacts by namespace and key in Looker. Returns fields key, value, content_type, version, namespace, created_at, updated_at, value_size, created_by_userid, and updated_by_userid in the response.

update_a_looker_artifact_by_id

Create or update one or more artifacts in Looker using namespace. Requires key and value for creation, and version for updates. Returns key, value, content_type, version, namespace, created_at, updated_at, value_size, created_by_userid, updated_by_userid.

delete_a_looker_artifact_by_id

Delete one or more artifacts by namespace and key in Looker. Requires namespace and a comma-delimited list of keys. Response confirms deletion or returns error details.

looker_artifact_search

Get an array of artifacts matching the key pattern and size range in Looker. Requires namespace. Returns key, value, content_type, version, namespace, created_at, updated_at, value_size, created_by_userid, and updated_by_userid fields.

looker_artifact_purge

Delete all artifacts in the specified namespace in Looker. Requires namespace. This operation permanently deletes all artifacts in the namespace.

get_single_looker_cloud_storage_by_id

Get the current Cloud Storage configuration in Looker. Returns fields including type (backup type), custom_s3_bucket (bucket name), custom_s3_bucket_region (bucket region), and url (link to this configuration).

update_a_looker_cloud_storage_by_id

Update the current Cloud Storage Configuration in Looker. Returns the updated backup configuration including type, custom_s3_bucket, custom_s3_bucket_region, and url.

get_single_looker_custom_welcome_email_by_id

Get the current status and content of custom welcome emails in Looker. Returns enabled (boolean), content (HTML string), subject (email subject text), and header (email header text) fields.

update_a_looker_custom_welcome_email_by_id

Update custom welcome email content with enabled, content, subject, and header fields in Looker. Optionally send a test email to the current user after saving. Returns updated email settings including enabled, content, subject, and header.

looker_custom_welcome_email_send

Send a test welcome email to the currently logged in user in Looker with the provided subject, header, and content. The response returns the sent email's subject, header, and content.

get_single_looker_digest_email_by_id

Get the value indicating whether digest emails are enabled in Looker. Returns is_enabled boolean field showing the status.

update_a_looker_digest_email_by_id

Update the setting for enabling or disabling digest emails in Looker. Returns the is_enabled field indicating the current status of digest emails.

looker_digest_emails_deliver

Trigger the generation of digest email records and send them to Looker's internal system. Returns configuration_delivered indicating if content was successfully generated and delivered.

list_all_looker_public_egress

Get the list of public egress IP addresses for a hosted customer's instance in Looker. Returns egress_ip_addresses array containing the IP addresses.

get_single_looker_internal_help_resources_content_by_id

Get internal help resources content in Looker. Returns organization_name as the menu item text and markdown_content as the content displayed in the internal help resources page or modal.

update_a_looker_internal_help_resources_content_by_id

Update internal help resources content in Looker. Requires organization_name and markdown_content. Returns updated organization_name and markdown_content fields.

get_single_looker_internal_help_resource_config_by_id

Get the status of internal help resources in Looker. Returns 'enabled' boolean indicating if internal help resources content is shown in the help menu.

update_a_looker_internal_help_resource_config_by_id

Update internal help resources settings in Looker. Requires the enabled flag to show the internal help resources link and content in the help menu. Returns the updated enabled status and operations allowed.

list_all_looker_legacy_feature

Get all legacy features in Looker. Returns an array of legacy features with fields including id, name, description, enabled status, version info, and documentation URL.

get_single_looker_legacy_feature_by_id

Get information about the legacy feature with id in Looker. Returns fields including id, name, description, enabled status, version info, documentation_url, and disable dates.

update_a_looker_legacy_feature_by_id

Update information about the legacy feature with id in Looker. Returns fields including id, name, description, enabled status, version info, documentation_url, and disable/end-of-life dates.

list_all_looker_locales

Get a list of locales that Looker supports. Returns code, native_name, and english_name for each locale.

list_all_looker_mobile_settings

Get all mobile settings in Looker. Returns mobile_force_authentication (force authentication enabled), mobile_app_integration (mobile access enabled), and mobile_feature_flags (feature flag names and states).

get_single_looker_setting_by_id

Get Looker settings including instance_config, feature_flags, license_features, marketplace settings, embed configuration, and other key configuration flags. Returns all current settings for the Looker instance.

update_a_looker_setting_by_id

Update Looker settings with the provided configuration. Returns the updated settings including instance_config, marketplace_automation, custom_welcome_email, timezone, embed_config, and other key configuration fields.

get_single_looker_smtp_setting_by_id

Get current SMTP status in Looker. Returns overall cluster status (is_valid), total node count (node_count), and per-node status including is_valid, message, and hostname.

update_a_looker_smtp_setting_by_id

Set SMTP settings in Looker with address, from, user_name, password, port, enable_starttls_auto, ssl_version, and default_smtp.

list_all_looker_timezones

Get a list of timezones that Looker supports. Returns value (timezone identifier), label (description), and group (timezone group) for each timezone.

list_all_looker_api_version

Get information about all API versions supported by this Looker instance. Returns supported_versions array with version, full_version, status, and swagger_url for each version.

get_single_looker_api_specification_by_id

Get an API specification for this Looker instance using api_version and specification. Returns the specification as a JSON document in Swagger 2.x format.

list_all_looker_dashboards

Get all active dashboards in Looker. Returns an array of abbreviated dashboard objects excluding deleted ones. Key fields returned include id, title, description, model, folder, and refresh interval.

get_single_looker_dashboard_by_id

Get full details of a dashboard by id in Looker. Returns fields including id, title, description, created_at, updated_at, user_name, favorite_count, view_count, dashboard_elements, dashboard_filters, and dashboard_layouts.

create_a_looker_dashboard

Create a new dashboard in Looker with required fields title and space_id. Returns the dashboard's id, title, description, created_at, updated_at, user_id, folder info, and url.

update_a_looker_dashboard_by_id

Update a dashboard by id in Looker. Modify string and integer properties such as title, description, refresh_interval, and appearance. Nested objects like filters and elements cannot be updated here. Returns the updated dashboard object including id, title, description, refresh_interval, and appearance.

delete_a_looker_dashboard_by_id

Delete a dashboard by id in Looker. This operation permanently removes the dashboard and it cannot be recovered. Use update_dashboard to soft delete instead.

looker_dashboards_search

Search user-defined dashboards in Looker by id, slug, title, description, content_favorite_id, folder_id, deleted status, user_id, view_count, content_metadata_id, curate, last_viewed_at. Returns dashboard id, title, description, user_id, folder, view_count, favorite_count, created_at, updated_at, and other metadata.

looker_dashboards_move

Move a dashboard to a specified folder in Looker. Requires dashboard_id and folder_id which must exist and be different from the current folder. Returns the moved dashboard with fields like id, title, description, folder, and updated_at.

looker_dashboards_copy

Create a copy of an existing dashboard by dashboard_id in Looker. Requires dashboard_id and folder_id if specified. Returns the copied dashboard with fields like id, title, description, folder, created_at, updated_at, and dashboard_elements.

list_all_looker_dashboard_elements

Get all dashboard elements on a dashboard with a specific dashboard_id in Looker. Returns elements with fields including id, title, type, query details, and look information.

get_single_looker_dashboard_element_by_id

Get information about the dashboard element with id in Looker. Returns fields including id, dashboard_id, title, type, body_text, look details, query details, and timestamps.

create_a_looker_dashboard_element

Create a dashboard element with dashboard_id in Looker. Returns the created dashboard element including id, dashboard_id, title, type, and query details.

update_a_looker_dashboard_element_by_id

Update the dashboard element with id in Looker. Returns updated dashboard element including id, dashboard_id, title, type, subtitle_text, refresh_interval, and associated look or query details.

delete_a_looker_dashboard_element_by_id

Delete a dashboard element by id in Looker. Returns 204 status on successful deletion.

looker_dashboard_elements_search

Get an array of DashboardElement objects matching search criteria in Looker. Supports filtering by dashboard_id, look_id, title, and deleted status. Returns fields including id, dashboard_id, look, title, and deleted.

list_all_looker_dashboard_filters

Get all dashboard filters for a dashboard with a specific id in Looker. Returns fields including id, dashboard_id, name, title, type, default_value, model, explore, dimension, field info, row, listens_to_filters, allow_multiple_values, required, and ui_config.

get_single_looker_dashboard_filter_by_id

Get information about the dashboard filter with id in Looker. Returns id, dashboard_id, name, title, type, default_value, model, explore, dimension, field, row, listens_to_filters, allow_multiple_values, required, and ui_config.

create_a_looker_dashboard_filter

Create a dashboard filter with dashboard_id, name, title, and type in Looker. Returns id, dashboard_id, name, title, type, default_value, model, explore, dimension, row, listens_to_filters, allow_multiple_values, required, and ui_config fields.

update_a_looker_dashboard_filter_by_id

Update the dashboard filter with id in Looker. Returns the updated filter including id, dashboard_id, name, title, type, default_value, model, explore, dimension, row, listens_to_filters, allow_multiple_values, required, and ui_config fields.

delete_a_looker_dashboard_filter_by_id

Delete a dashboard filter by id in Looker. Returns 204 status on successful deletion.

list_all_looker_dashboard_layout

Get all dashboard layouts for a dashboard with dashboard_id in Looker. Returns id, dashboard_id, type, active status, column_width, width, deleted status, dashboard_title, and dashboard_layout_components with their details including element titles and visualization types.

get_single_looker_dashboard_layout_by_id

Get information about the dashboard layout with id in Looker. Returns id, dashboard_id, type, active status, column_width, width, deleted status, dashboard_title, and dashboard_layout_components including their id, dashboard_element_id, position, size, deleted status, element_title, element_title_hidden, and vis_type.

create_a_looker_dashboard_layout

Create a dashboard layout with dashboard_id, type, active, column_width, and width in Looker. Returns id, dashboard_id, type, active, column_width, width, deleted, dashboard_title, and dashboard_layout_components with component details.

update_a_looker_dashboard_layout_by_id

Update the dashboard layout with id in Looker. Returns updated dashboard layout including id, dashboard_id, type, active status, column_width, width, deleted status, dashboard_title, and dashboard_layout_components with their details.

delete_a_looker_dashboard_layout_by_id

Delete a dashboard layout by id in Looker. Returns 204 status on successful deletion.

list_all_looker_dashboard_layout_component

Get all dashboard layout components for a dashboard layout with id in Looker. Returns id, dashboard_layout_id, dashboard_element_id, row, column, width, height, deleted status, element_title, element_title_hidden, and vis_type fields.

get_single_looker_dashboard_layout_component_by_id

Get information about the dashboard layout component with id in Looker. Returns id, dashboard_layout_id, dashboard_element_id, row, column, width, height, deleted status, element_title, element_title_hidden, and vis_type fields.

update_a_looker_dashboard_layout_component_by_id

Update the dashboard layout component with id in Looker. Returns fields including id, dashboard_layout_id, dashboard_element_id, row, column, width, height, deleted, element_title, element_title_hidden, and vis_type.

create_a_looker_data_action

Perform a data action in Looker using the action JSON and form_values. Returns webhook_id, success status, refresh_query flag, validation_errors, and an optional message describing the action result.

looker_data_actions_fetch

Create a data action form in Looker. Returns fields including name, label, description, type, default, oauth_url, interactive, required, and options for user input.

list_all_looker_projects

Get all projects visible to the current user in Looker. Returns project id, name, git configuration details, and validation status for each project.

get_single_looker_project_by_id

Get project details by id in Looker. Returns fields including id, name, uses_git, git_remote_url, git_username, git_production_branch_name, pull_request_mode, validation_required, and dependency_status.

create_a_looker_project

Create a project with the required name in Looker. Returns project id, name, git configuration status, validation policies, and dependency status.

update_a_looker_project_by_id

Update a project's configuration in Looker using project id. Returns updated project fields including id, name, uses_git, git_remote_url, git_service_name, validation_required, and dependency_status.

looker_projects_validate

Validate all LookML files in a project in Looker by project id. Returns a list of errors including code, severity, kind, message, file_path, line_number, and model_id found during validation.

looker_projects_manifest

Get the manifest of a project in Looker by project_id. Returns fields including name (manifest project name), imports (dependency details), and localization_settings (default locale and localization level).

looker_projects_lock_all

Install all LookML dependencies for a project using Looker. Requires project id. Returns 204 if dependencies are successfully installed or 400 with an error message.

list_all_looker_git_branches

Get all git branches for the project specified by project_id in Looker. Returns branch details including name, remote, owner_name, readonly status, commit timestamp, and ahead/behind counts.

get_single_looker_git_branch_by_id

Get the specified Git Branch by project_id and id in Looker. Returns branch details including name, remote, owner_name, readonly status, commit timestamps, and ahead/behind commit counts.

create_a_looker_git_branch

Create and checkout a new git branch in the project identified by project_id in Looker. Returns branch details including name, remote, owner_name, readonly status, commit timestamp, and ahead/behind counts.

update_a_looker_git_branch_by_id

Update a Git branch for project_id in Looker. Returns branch details including name, remote, readonly status, commit timestamp, ahead/behind counts, and error messages if present. Only allowed in development mode.

delete_a_looker_git_branch_by_id

Delete git branch specified by id from local and remote of project repository identified by project_id in Looker.

list_all_looker_project_file

Get all project files for project_id in Looker. Returns file id, path, title, type, extension, mime_type, editable state, and git status including action, conflict, revertable, and text.

get_single_looker_project_file_by_id

Get information about a specific project file in Looker using project_id and file_id. Returns id, path, title, type, extension, mime_type, editable state, and git_status including action, conflict, revertable, and text.

list_all_looker_git_connection_test

Get all git connection tests for project id in Looker. Returns tests with id and description fields describing each test's purpose and order of execution.

looker_git_connection_test_run

Run the named git connection test on the git service used by the project with project_id and test id in Looker. Returns status ('pass' or 'fail'), message, and id fields in the response.

list_all_looker_lookml_test

Get all LookML tests for a project in Looker using project_id. Returns test details including model_name, name, explore_name, query_url_params, file, and line number.

looker_lookml_test_run

Run all LookML tests in the project identified by id using Looker. Returns test results including model_name, test_name, assertions_count, assertions_failed, errors, warnings, and success status.

get_single_looker_deploy_key_by_id

Get the SSH public deploy key for a project's git repository in Looker. Requires project_id. Returns the public key as a string.

create_a_looker_deploy_key

Create a deploy key for a Looker project using project_id. Returns the public key of the generated SSH key pair for authenticating git requests from Looker to a remote git repository.

list_all_looker_repository_credentials

Get all repository credentials for a project in Looker using root_project_id. Returns id, root_project_id, remote_url, git_username, ssh_public_key, and is_configured fields for each credential.

create_a_looker_repository_credential

Create repository credential with root_project_id and credential_id in Looker. Returns id, root_project_id, remote_url, git_username, ssh_public_key, and is_configured indicating credential setup status.

delete_a_looker_repository_credential_by_id

Delete repository credential with root_project_id and id in Looker. Returns 204 on success or error details on failure.

create_a_looker_tag_ref

Create a tag for the most recent commit or a specific commit SHA in Looker project identified by project_id. Returns project details including id, name, uses_git, git_remote_url, and dependency_status.

get_single_looker_query_by_id

Get details about a specific query by id in Looker. Returns fields including id, model, view, fields, filters, sorts, limit, and visualization config.

create_a_looker_query

Create a new query in Looker with specified model, view, fields, filters, and other parameters. Returns the query object including id, model, view, fields, filters, sorts, limit, and URLs. Queries are immutable and duplicates return existing query.

looker_query_run

Run a saved query in Looker using id and result_format. Returns the query results in the specified format such as json, csv, or image. Supports parameters like limit and cache options.

looker_query_run_inline

Run an inline query in Looker with specified result_format. Requires a JSON body defining model, view, fields, filters, sorts, and limit. Returns query results in the requested format.

looker_query_run_url

Run an URL encoded query in Looker with model_name, view_name, and result_format. Returns query results in the specified format such as json, csv, or xlsx.

list_all_looker_async_query

Get results of multiple async queries in Looker using query_task_ids. Returns execution status for incomplete tasks and status 'expired' for expired results. Response includes query results or status for each task.

get_single_looker_async_query_by_id

Get async query task details by id in Looker. Returns fields including id, query_id, status, runtime, result_format, and associated look_id and dashboard_id.

create_a_looker_async_query

Create an async query task in Looker to run a previously created query asynchronously using query_id. Returns the query task id and details including status, runtime, and result_format.

get_single_looker_merge_query_by_id

Get a merge query by id in Looker. Returns fields including id, column_limit, dynamic_fields, pivots, result_maker_id, sorts, source_queries (with query_id, query_slug), merge_fields (with field_name, source_field_name, name, total), and vis_config.

create_a_looker_merge_query

Create a new merge query in Looker by providing a MergeQuery object. Returns the created merge query with fields including id, column_limit, pivots, result_maker_id, sorts, source_queries, merge_fields, total, and vis_config.

list_all_looker_running_query

Get information about all running queries in Looker. Returns an array of running queries including id, user details, query details, SQL query, status, runtime, and timestamps for each running query.

delete_a_looker_running_query_by_id

Kill a running query in Looker by query_task_id. Returns 204 status on success indicating the query was successfully killed.

get_single_looker_sql_runner_query_by_id

Get a SQL Runner query by slug in Looker. Returns fields including slug, last_runtime (seconds), run_count, browser_limit, sql text, last_run_at timestamp, connection details (name, dialect, supports_cost_estimate), model_name, creator info (id, first_name, last_name), and explore_url.

create_a_looker_sql_runner_query

Create a SQL Runner Query with either connection_name or model_name and sql. Returns fields including slug, last_runtime, run_count, sql, last_run_at, connection details, model_name, creator info, vis_config, and result_maker_id in Looker.

looker_sql_runner_query_run

Run a SQL Runner query in Looker using slug and result_format. Returns the query result in the specified format.

create_a_looker_look_render_task

Create a new render task to render a look to an image in Looker. Requires look_id and result_format. Returns render task object with id, status, created_at, finalized_at, width, height, result_format, runtime, and status_detail fields.

create_a_looker_query_render_task

Create a new render task to render an existing query to an image in Looker. Requires query_id and result_format. Returns render task object including id, status, created_at, runtime, and output dimensions.

create_a_looker_dashboard_render_task

Create a new dashboard render task with dashboard_id and result_format in Looker. Returns render task object including id, status, created_at, finalized_at, runtime, and output dimensions.

get_single_looker_render_task_by_id

Get information about a render task in Looker using id. Returns fields including status, created_at, finalized_at, result_format, runtime, and user_id to track task progress and output details.

looker_render_task_result

Get the document or image produced by a completed render task in Looker using id. Returns binary content of the rendered result or 202 if not finished. Use render_task(id) to check status before polling results.

list_all_looker_permission_sets

Get information about all permission sets in Looker. Returns id, name, permissions, all_access, built_in, and url fields for each permission set.

get_single_looker_permission_set_by_id

Get information about the permission set with id in Looker. Returns id, name, permissions, all_access, built_in, url, and can fields describing the permission set details and user operations.

create_a_looker_permission_set

Create a permission set with the specified information in Looker. Returns the created permission set including id, name, permissions, and built_in status. Providing save_content permission grants save_looks and save_dashboards abilities.

update_a_looker_permission_set_by_id

Update information about the permission set with id in Looker. Returns the updated permission set including id, name, permissions, all_access, built_in, and url fields.

delete_a_looker_permission_set_by_id

Delete the permission set with id in Looker. Returns 204 status on successful deletion.

looker_permission_sets_search

Get permission sets matching search criteria in Looker. Returns id, name, all_access, built_in, permissions, and url fields for each permission set.

list_all_looker_model_sets

Get information about all model sets in Looker. Returns an array of model sets with fields including id (unique identifier), name (model set name), models (list of models), and url (link to the item).

get_single_looker_model_set_by_id

Get information about the model set with id in Looker. Returns id, name, models, url, built_in, all_access, and can fields.

create_a_looker_model_set

Create a model set with the specified information in Looker. Returns the created model set including id, name, models, and url.

update_a_looker_model_set_by_id

Update information about the model set with id in Looker. Returns the updated model set including id, name, models, and permissions.

delete_a_looker_model_set_by_id

Delete the model set with id in Looker. Returns 204 on successful deletion or error details if the model set cannot be deleted.

looker_model_sets_search

Get model sets matching search criteria in Looker. Returns id, name, models, all_access, built_in, and url fields for each model set. Supports filtering by id, name, all_access, built_in, and combining criteria with filter_or.

list_all_looker_scheduled_plans

Get all scheduled plans with optional user_id to filter by user or all_users to include all users in Looker. Returns fields including name, user_id, enabled, look_id, dashboard_id, filters_string, crontab, timezone, destinations, and next_run_at.

get_single_looker_scheduled_plan_by_id

Get information about a specific scheduled plan in Looker by id. Returns fields including name, user_id, enabled status, look_id, dashboard_id, filters_string, crontab, timezone, destinations, next_run_at, and last_run_at.

create_a_looker_scheduled_plan

Create a scheduled plan in Looker with required fields name and one of look_id, dashboard_id, lookml_dashboard_id, or query_id, plus crontab or datagroup and at least one scheduled_plan_destination. Returns the created scheduled plan including id, name, user_id, enabled, and scheduling details.

update_a_looker_scheduled_plan_by_id

Update a scheduled plan by id in Looker. Returns the updated scheduled plan including fields like name, user_id, enabled, look_id, dashboard_id, filters_string, crontab, timezone, scheduled_plan_destination, and next_run_at.

delete_a_looker_scheduled_plan_by_id

Delete a scheduled plan by id in Looker. Normal users can only delete their own plans; admins can delete any. This action is irreversible.

looker_scheduled_plans_search

Get scheduled plans matching search criteria in Looker. Use user_id to filter by user. Returns fields including name, user_id, enabled, look_id, dashboard_id, filters_string, crontab, timezone, and scheduled_plan_destination details.

get_single_looker_credentials_email_by_id

Get email/password credential for user with id in Looker. Returns fields including email, user_id, created_at, is_disabled, logged_in_at, password_reset_url, account_setup_url, and flags for URL expiration.

create_a_looker_credentials_email

Create Email/Password Credential for user with id in Looker. Returns created credential including email, creation timestamp, user_id, disabled status, login timestamp, password reset and account setup URLs with expiration status, and credential type.

update_a_looker_credentials_email_by_id

Update Email/Password Credential for user with id in Looker. Returns fields including email, forced_password_reset_at_next_login, is_disabled, created_at, logged_in_at, password_reset_url, account_setup_url, and their expiration statuses.

delete_a_looker_credentials_email_by_id

Delete email/password credential for the specified user in Looker. Requires user_id. Returns 204 on successful deletion or error details on failure.

looker_credentials_email_search

Get all credentials_email records matching search criteria in Looker. Returns fields including id, email, user_id, created_at, is_disabled, and URLs for password reset and account setup.

list_all_looker_credentials_api

Get all API credentials for the specified user in Looker. Requires user_id. Returns id, client_id, created_at, is_disabled, type, and url for each credential.

get_single_looker_credentials_api_by_id

Get API Credential for user_id and id in Looker. Returns id, client_id, created_at, is_disabled, type, and url fields describing the API credential.

create_a_looker_credentials_api

Create API credential for user with user_id in Looker. Returns id, client_id, client_secret, created_at, is_disabled, type, and url of the new credential.

delete_a_looker_credentials_api_by_id

Delete API Credential for user_id and id in Looker. Returns 204 status on successful deletion.

Why Truto

Why use Truto’s MCP server for Looker

Other MCP servers give you a static tool list for one app. Truto gives you a managed, multi-tenant MCP infrastructure across 650+ integrations.

01

Auto-generated, always up to date

Tools are dynamically generated from curated documentation — not hand-coded. As integrations evolve, tools stay current without manual maintenance.

02

Fine-grained access control

Scope each MCP server to read-only, write-only, specific methods, or tagged tool groups. Expose only what your AI agent needs — nothing more.

03

Multi-tenant by design

Each MCP server is scoped to a single connected account with its own credentials. The URL itself is the auth token — no shared secrets, no credential leaking across tenants.

04

Works with every MCP client

Standard JSON-RPC 2.0 protocol. Paste the URL into Claude, ChatGPT, Cursor, or any MCP-compatible agent framework — tools are discovered automatically.

05

Built-in auth, rate limits, and error handling

Tool calls execute through Truto’s proxy layer with automatic OAuth refresh, rate-limit handling, and normalized error responses. No raw API plumbing in your agent.

06

Expiring and auditable servers

Create time-limited MCP servers for contractors or automated workflows. Optional dual-auth requires both the URL and a Truto API token for high-security environments.

Unified APIs

Unified APIs for Looker

Skip writing code for every integration. Use Truto’s category-specific Unified APIs out of the box or customize the mappings with AI.

Unified User Directory API

Roles

The Role object represents a role of a User.

View Docs

Users

The User object represents a User.

View Docs

How It Works

From zero to integrated

Go live with Looker in under an hour. No boilerplate, no maintenance burden.

01

Link your customer’s Looker account

Use Truto’s frontend SDK to connect your customer’s Looker account. We handle all OAuth and API key flows — you don’t need to create the OAuth app.

02

We handle authentication

Don’t spend time refreshing access tokens or figuring out secure storage. We handle it and inject credentials into every API request.

03

Call our API, we call Looker

Truto’s Proxy API is a 1-to-1 mapping of the Looker API. You call us, we call Looker, and pass the response back in the same cycle.

04

Unified response format

Every response follows a single format across all integrations. We translate Looker’s pagination into unified cursor-based pagination. Data is always in the result attribute.

FAQs

Common questions about Looker on Truto

Authentication, rate limits, data freshness, and everything else you need to know before you integrate.

What authentication method does the Looker integration use?

Looker's API uses OAuth2-based client credentials (API3 keys — a client_id and client_secret pair). Truto handles token generation and refresh automatically, so your end users just provide their API3 credentials during the connection flow.

Which Looker resources are covered by Truto's Unified User Directory API?

The Unified User Directory API maps to Looker's Users and Roles resources. You can list, create, update, and delete users, list and manage user roles, and perform full CRUD on roles — all through a standardized schema that works across other integrated platforms.

Can I run Looker queries and retrieve data through Truto?

Yes. You can create queries, run them synchronously or asynchronously, run inline queries, and execute SQL Runner queries. These endpoints let you pull governed, LookML-defined metrics without writing raw SQL against the underlying database.

How does Truto handle pagination for large Looker result sets?

Truto manages pagination automatically across all list endpoints (users, dashboards, looks, folders, etc.), so you receive complete result sets without implementing offset or cursor logic yourself.

Can I manage Looker groups and group membership through the integration?

Yes. The integration supports full CRUD on groups, adding and removing users from groups, managing subgroups, searching group hierarchies, and updating user attribute values at the group level.

What content management operations are supported beyond dashboards?

In addition to dashboards (with elements, filters, layouts, and layout components), the integration supports Looks (including run, copy, and move), Boards (with board items and sections), Folders (with search, children, ancestors), content metadata, and favorite content management.

Looker

Get Looker integrated into your app

Our team understands what it takes to make a Looker integration successful. A short, crisp 30 minute call with folks who understand the problem.

Talk to us