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 usUse Cases
Why integrate with Looker
Common scenarios for SaaS companies building Looker integrations for their customers.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
How It Works
From zero to integrated
Go live with Looker in under an hour. No boilerplate, no maintenance burden.
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.
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.
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.
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