Looker

Create a Looker alert with comparison type, field, threshold, and optional destinations. Monitors dashboard elements …

Get a Looker alert by ID. Returns comparison type, threshold, field, and notification settings.

Update a Looker alert threshold or enabled status. Use is_disabled to enable or disable.

Delete a Looker alert by ID. This stops all future notifications.

Search Looker alerts with offset pagination. Returns matching alerts.

List Looker boards with offset pagination. Returns board titles, descriptions, and metadata.

Search Looker boards by title, creator, or favorites. Title filter uses substring matching by default. Include % in y…

Create a Looker board with title and description. Boards organize looks and dashboards into collections.

Get a Looker board by ID. Returns title, description, sections, and items.

Update a Looker board title or description. Use get_board to verify changes.

Delete a Looker board by ID. This action is permanent. Use get_board to verify before deleting.

Get all board sections across all boards. Use get_board to get sections for a specific board.

Create a section within a Looker board. Sections group board items. Use list_boards to find board IDs.

Get a Looker board section by ID. Returns section title, description, and items.

Update a Looker board section title or description. Use get_board_section to verify changes.

Delete a Looker board section by ID. This action is permanent and removes all items in the section.

Get all board items across all sections. Use get_board or get_board_section to get items for a specific board/section.

Add an item to a board section. Link a dashboard, look, or custom URL. Use get_all_board_sections to find section IDs.

Get a Looker board item by ID. Returns linked dashboard/look info and custom fields.

Update a Looker board item. Change linked dashboard/look or custom title/description/URL.

Delete a Looker board item by ID. This removes the item from its section permanently.

List Looker database connections. Requires admin permissions. Returns connection names, dialects, and hosts.

Create a Looker database connection. Requires admin permissions. Specify name, dialect, host, port, database, and cre…

Get a Looker database connection by name. Requires admin permissions. Use list_connections to find valid names.

Update a Looker database connection host, port, database, or credentials. Requires admin permissions.

Delete a Looker database connection by name. This action is permanent. Requires admin permissions.

List all elements (tiles) on a Looker dashboard. Returns element titles, types, and query IDs.

Create a dashboard element (tile). Specify dashboard_id, type (‘vis’, ‘text’), and query_id or body_text. Use create_…

Get a dashboard element by ID. Returns title, type, query, and display settings.

Update a dashboard element title, text, query, or display settings.

Delete a dashboard element by ID. This removes the tile from the dashboard.

List all filters on a Looker dashboard. Returns filter names, types, and default values.

Create a dashboard filter. Requires dashboard_id, name, title, and type (‘date_filter’, ‘number_filter’, ‘string_filt…

Get a dashboard filter by ID. Returns name, type, default value, and configuration.

Update a dashboard filter name, title, type, default value, or required setting.

Delete a dashboard filter by ID. This removes the filter from the dashboard.

List all layout components for a dashboard layout. Returns element positions (row, column, width, height).

Get a dashboard layout component by ID. Returns element ID and position (row, column, width, height).

Update a dashboard layout component position. Set row, column, width, and height to arrange tiles on the dashboard.

List all layouts for a Looker dashboard. Returns layout types, active status, and dimensions.

Create a dashboard layout. Specify dashboard_id, type, and dimensions.

Get a dashboard layout by ID. Returns type, active status, and dimensions.

Update a dashboard layout active status or dimensions.

Delete a dashboard layout by ID.

List Looker dashboards with offset pagination. Returns titles, IDs, and metadata. Use offset from page_info for next …

Create a Looker dashboard with title, description, and folder. Use list_folders to find valid folder IDs.

Get a Looker dashboard by ID. Returns title, elements, filters, and metadata. Use list_dashboards or search_dashboard…

Update a Looker dashboard title, description, folder, timezone, refresh interval, or visibility. Use get_dashboard to…

Delete a Looker dashboard by ID. This action is permanent. Use get_dashboard to verify before deleting.

Copy a Looker dashboard to a different folder. Returns the new dashboard. Use list_folders to find valid folder IDs.

Move a Looker dashboard to a different folder. Use list_folders to find valid folder IDs.

Search Looker dashboards by title or folder. Text filters use substring matching by default. Include % in your value …

List Looker folders with offset pagination. Returns folder names, IDs, and hierarchy. Use offset from page_info for n…

Create a Looker folder with name and parent folder. Use list_folders to find valid parent folder IDs.

Get a Looker folder by ID. Returns name, parent, child count, and metadata.

Update a Looker folder name. Use get_folder to verify changes.

Delete a Looker folder by ID. This action is permanent. Use get_folder to verify before deleting.

Search Looker folders by name or parent. Text filters use substring matching by default. Include % in your value for …

Get child folders of a Looker folder. Returns sub-folders with pagination.

Get all looks in a Looker folder. Returns looks with their titles, IDs, and metadata.

Get all dashboards in a Looker folder. Returns dashboards with their titles, IDs, and metadata.

List Looker groups with offset pagination. Requires admin permissions. Returns group names and user counts.

Create a Looker group with name and optional parent group. Requires admin permissions.

Get a Looker group by ID. Requires admin permissions. Returns name, user count, and metadata.

Update a Looker group name or content metadata access. Requires admin permissions. Use get_group to verify changes.

Delete a Looker group by ID. This action is permanent. Requires admin permissions.

Search Looker groups by name, external group ID, or management flags. Supports sorting and pagination. Requires admin…

Search Looker groups and include role information in results. Filter by name, external group ID, or management flags…

Search Looker groups and include parent group hierarchy in results. Filter by name, external group ID, or management …

Get all groups that are members of a Looker group. Supports sorting. Requires admin permissions. Use list_groups to f…

Add a group as a member of another Looker group. Requires admin permissions. Use list_groups to find valid group IDs.

Remove a member group from a Looker group. This action is permanent. Requires admin permissions.

Get all users in a Looker group with pagination. Supports sorting. Requires admin permissions. Use list_groups to fin…

Add a user to a Looker group. Requires admin permissions. Use list_users to find valid user IDs and list_groups for g…

Remove a user from a Looker group. This action is permanent. Requires admin permissions.

Set the value of a user attribute for a Looker group. Requires admin permissions. Use list_groups and list user attri…

Delete a group-level user attribute value in Looker. This action is permanent. Requires admin permissions.

List Looker looks with offset pagination. Returns titles, IDs, and metadata. Use offset from page_info for next page.

Create a Looker look with title, description, folder, and query. Use list_folders to find valid folder IDs. Use creat…

Get a Looker look by ID. Returns title, description, query details, and metadata. Use list_looks or search_looks to f…

Update a Looker look title, description, folder, query, visibility, or owner. Use get_look to verify changes.

Delete a Looker look by ID. This action is permanent. Use get_look to verify before deleting.

Copy a Looker look to a different folder. Returns the new look. Use list_folders to find valid folder IDs.

Move a Looker look to a different folder. Use list_folders to find valid folder IDs.

Run a Looker look and return results. Supports json, csv, and other formats. Use list_looks to find valid IDs.

Search Looker looks by title, description, or folder. Text filters use substring matching by default. Include % in yo…

Import a LookML dashboard into a folder as a user-defined dashboard. The imported dashboard will be linked to the Loo…

Sync all linked user-defined dashboards to match a LookML dashboard. Updates elements, filters, and layout to match t…

Search LookML dashboards in production. Filter by title (supports % wildcards) or folder. Returns dashboard IDs and L…

Create a dashboard from LookML YAML code. The dashboard is NOT linked to any LookML dashboard. Provide valid LookML Y…

Get the LookML YAML representation of a user-defined dashboard. Useful for exporting or duplicating dashboards via Lo…

Get aggregate table LookML for each query on a dashboard. Useful for optimizing dashboard performance with persistent…

List available LookML models and their explores. Use model names with create_query or run_inline_query to build queries.

Create a LookML model with a name, project, and database connections. Use list_connections to find valid connection n…

Get a LookML model by name. Returns explores, project, and label. Use list_lookml_models to find valid names.

Update a LookML model’s project or database connections. Use list_lookml_models to find valid names.

Delete a LookML model by name. This action is permanent. Use get_lookml_model to verify before deleting.

Get a LookML explore with its dimensions, measures, and relationships. Use get_lookml_model to find valid explore names.

Create a Looker query with model, view, fields, filters, and sorts. Use list_lookml_models to find valid model names…

Get a Looker query definition by ID. Returns model, view, fields, filters, and sorts.

Get a Looker query by its slug identifier (found in Looker URLs). Returns the full query definition.

Run a saved Looker query and return results. Use create_query first to get an ID. Supports json, csv, and other formats.

Run an inline Looker query without saving it. Specify model, view, fields, filters, and sorts directly. Use list_look…

Run a Looker query asynchronously. Returns a task ID to check status with get_query_task and fetch results with get_q…

Check the status of an async Looker query task. Returns status (pending, running, complete, error). Use create_query_…

Get results of a completed async Looker query task. Task must have status ‘complete’. Use get_query_task to check sta…

Get results of multiple completed async Looker query tasks at once. All tasks must be complete. Pass a list of task IDs.

Create a merge query that combines results from multiple Looker queries. Each source query needs a query_id and optio…

Get a Looker merge query definition by ID. Returns source queries and merge configuration.

List all currently running Looker queries. Shows query ID, user, runtime, and status. Useful for monitoring and ident…

Terminate a running Looker query by its task ID. Use list_running_queries to find task IDs of queries to kill.

Create a SQL Runner query with raw SQL. Specify connection_name OR model_name (mutually exclusive). Use list_connecti…

Get a SQL Runner query by its slug. Returns the SQL text and connection details.

Execute a SQL Runner query and return results. Use create_sql_query first to get a slug. Supports json, csv, and othe…

List Looker roles. Requires admin permissions. Returns role names, permission sets, and model sets.

Create a Looker role with name, permission set, and model set. Requires admin permissions.

Get a Looker role by ID. Requires admin permissions. Use list_roles to find valid IDs.

Update a Looker role name, permission set, or model set. Requires admin permissions.

Delete a Looker role by ID. This action is permanent. Requires admin permissions.

Search Looker roles by name with pagination. Requires admin permissions. Use offset from page_info for next page.

Search Looker roles by name, including user count per role. Requires admin permissions. Use offset from page_info for…

Get all users assigned to a Looker role. Supports pagination. Use direct_association_only to exclude users assigned v…

Set users for a Looker role. Replaces all current user assignments. Requires admin permissions. Use list_users to fin…

Get all groups assigned to a Looker role. Requires admin permissions. Use list_roles to find valid role IDs.

Set groups for a Looker role. Replaces all current group assignments. Requires admin permissions. Use list_groups to …

Create a Looker permission set with name and permissions. Use list_permissions to see available permissions.

List all Looker permission sets. Returns names and permissions for each set. Requires admin permissions.

Get a Looker permission set by ID. Returns permissions in the set. Use list_permission_sets to find valid IDs.

Update a Looker permission set name or permissions. Requires admin permissions. Use list_permissions to see available…

Delete a Looker permission set by ID. This action is permanent. Requires admin permissions.

Create a Looker model set with name and models. Use list_lookml_models to see available models.

List all Looker model sets. Returns names and models for each set. Requires admin permissions.

Get a Looker model set by ID. Returns models in the set. Use list_model_sets to find valid IDs.

Update a Looker model set name or models. Requires admin permissions. Use list_lookml_models to see available models.

Delete a Looker model set by ID. This action is permanent. Requires admin permissions.

List all available Looker permissions. Useful to see what permissions exist before creating permission sets.

List Looker scheduled plans with offset pagination. Returns schedule names, cron expressions, and associated content.

Create a Looker scheduled plan to deliver look or dashboard results on a schedule. Provide look_id or dashboard_id, c…

Get a Looker scheduled plan by ID. Returns name, schedule, destinations, and status.

Update a Looker scheduled plan name, cron expression, or enabled status.

Delete a Looker scheduled plan by ID. This stops all future deliveries.

List Looker users with offset pagination. Requires admin permissions. Use offset from page_info for next page.

Create a Looker user. Requires admin permissions. Optionally assign roles with role_ids. Use list_roles to find valid…

Get a Looker user by ID. Returns name, email, roles, and status. Requires admin permissions. Use list_users or search…

Update a Looker user’s name, email, roles, or status. Requires admin permissions. Use get_user to verify changes.

Delete a Looker user by ID. This action is permanent. Requires admin permissions.

Search Looker users by email, first name, last name, disabled status, or group. Text filters use substring matching b…

Get the currently authenticated Looker user. Returns your name, email, roles, and permissions.

Search Looker users by name or email pattern. Simpler than search_users for quick lookups. Requires admin permissions.

Get roles assigned to a Looker user. Requires admin permissions. Use list_users or search_users to find valid user IDs.

Set roles for a Looker user. Replaces all current roles. Requires admin permissions. Use list_roles to find valid rol…

Get all user attribute values for a Looker user. Returns attribute values with their source (User, Group, or Default).

Set a user attribute value for a Looker user. Overrides group or default values. Use get_user_attribute_values to see…

Remove a user-level attribute value override for a Looker user. The attribute will fall back to group or default value.

Send a password reset email to a Looker user. The user must have email credentials configured.

Create email credentials for a Looker user. Required before the user can log in with email/password.

Get email credentials for a Looker user. Returns email address and login status.

Delete email credentials for a Looker user. The user will no longer be able to log in with email/password.

Validate Looker credentials by fetching the current user. Returns success status and message.

List all Looker workspaces (production and dev). Returns workspace IDs and their associated projects.

Get a Looker workspace by ID (‘production’ or ‘dev’). Returns workspace details and associated projects.

Get the current API session. Returns the active workspace ID (‘production’ or ‘dev’) and sudo user if impersonating.

Switch the API session workspace to ‘production’ or ‘dev’. Affects which LookML content is used for subsequent API ca…