Skip to main content

Looker

Looker connector for managing dashboards, looks, queries, folders, users, groups, roles, boards, scheduled plans, alerts, connections, LookML models, and workspaces.

Categories: Business Intelligence, Analytics

What you can ask​

  • Pull yesterday's revenue from the Daily KPIs look and post in #leadership.
  • List Looks shared externally in the last 30 days for a security review.
  • Find dashboards with no views in the last 60 days.

Set up​

Looker connects with credentials from your Looker account. Have these values ready:

  • Instance URL
  • Client ID
  • Client secret
  1. Go to Organization > Connectors and find Looker.
  2. Click Enable and choose which tools to allow.
  3. Each member enters their own values the first time they use it.

To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.

Tools​

Looker offers 163 tools. Admins choose which ones agents can use. See Tool permission groups.

Read (81)​

View and search information without changing it.

ToolWhat it does
get_alertGet a Looker alert by ID.
get_all_board_itemsGet all board items across all sections.
get_all_board_sectionsGet all board sections across all boards.
get_boardGet a Looker board by ID.
get_board_itemGet a Looker board item by ID.
get_board_sectionGet a Looker board section by ID.
get_connectionGet a Looker database connection by name.
get_current_userGet the currently authenticated Looker user.
get_dashboardGet a Looker dashboard by ID.
get_dashboard_aggregate_table_lookmlGet aggregate table LookML for each query on a dashboard.
get_dashboard_elementGet a dashboard element by ID.
get_dashboard_filterGet a dashboard filter by ID.
get_dashboard_layoutGet a dashboard layout by ID.
get_dashboard_layout_componentGet a dashboard layout component by ID.
get_dashboard_lookmlGet the LookML YAML representation of a user-defined dashboard.
get_folderGet a Looker folder by ID.
get_folder_childrenGet child folders of a Looker folder.
get_folder_dashboardsGet all dashboards in a Looker folder.
get_folder_looksGet all looks in a Looker folder.
get_groupGet a Looker group by ID.
get_groups_in_groupGet all groups that are members of a Looker group.
get_lookGet a Looker look by ID.
get_lookml_exploreGet a LookML explore with its dimensions, measures, and relationships.
get_lookml_modelGet a LookML model by name.
get_merge_queryGet a Looker merge query definition by ID.
get_model_setGet a Looker model set by ID.
get_permission_setGet a Looker permission set by ID.
get_queryGet a Looker query definition by ID.
get_query_by_slugGet a Looker query by its slug identifier (found in Looker URLs).
get_query_taskCheck the status of an async Looker query task.
get_query_task_multi_resultsGet results of multiple completed async Looker query tasks at once.
get_query_task_resultsGet results of a completed async Looker query task.
get_roleGet a Looker role by ID.
get_role_groupsGet all groups assigned to a Looker role.
get_role_usersGet all users assigned to a Looker role.
get_scheduled_planGet a Looker scheduled plan by ID.
get_sessionGet the current API session.
get_sql_queryGet a SQL Runner query by its slug.
get_userGet a Looker user by ID.
get_user_attribute_valuesGet all user attribute values for a Looker user.
get_user_credentials_emailGet email credentials for a Looker user.
get_user_rolesGet roles assigned to a Looker user.
get_users_in_groupGet all users in a Looker group with pagination.
get_workspaceGet a Looker workspace by ID ('production' or 'dev').
list_boardsList Looker boards with offset pagination.
list_connectionsList Looker database connections.
list_dashboard_elementsList all elements (tiles) on a Looker dashboard.
list_dashboard_filtersList all filters on a Looker dashboard.
list_dashboard_layout_componentsList all layout components for a dashboard layout.
list_dashboard_layoutsList all layouts for a Looker dashboard.
list_dashboardsList Looker dashboards with offset pagination.
list_foldersList Looker folders with offset pagination.
list_groupsList Looker groups with offset pagination.
list_lookml_modelsList available LookML models and their explores.
list_looksList Looker looks with offset pagination.
list_model_setsList all Looker model sets.
list_permission_setsList all Looker permission sets.
list_permissionsList all available Looker permissions.
list_rolesList Looker roles.
list_running_queriesList all currently running Looker queries.
list_scheduled_plansList Looker scheduled plans with offset pagination.
list_usersList Looker users with offset pagination.
list_workspacesList all Looker workspaces (production and dev).
run_inline_queryRun an inline Looker query without saving it.
run_lookRun a Looker look and return results.
run_queryRun a saved Looker query and return results.
run_sql_queryExecute a SQL Runner query and return results.
search_alertsSearch Looker alerts with offset pagination.
search_boardsSearch Looker boards by title, creator, or favorites.
search_dashboardsSearch Looker dashboards by title or folder.
search_foldersSearch Looker folders by name or parent.
search_groupsSearch Looker groups by name, external group ID, or management flags.
search_groups_with_hierarchySearch Looker groups and include parent group hierarchy in results.
search_groups_with_rolesSearch Looker groups and include role information in results.
search_lookml_dashboardsSearch LookML dashboards in production.
search_looksSearch Looker looks by title, description, or folder.
search_rolesSearch Looker roles by name with pagination.
search_roles_with_user_countSearch Looker roles by name, including user count per role.
search_usersSearch Looker users by email, first name, last name, disabled status, or group.
search_users_namesSearch Looker users by name or email pattern.
validate_credentialValidate Looker credentials by fetching the current user.

Write (30)​

Create or send data.

ToolWhat it does
add_group_to_groupAdd a group as a member of another Looker group.
add_user_to_groupAdd a user to a Looker group.
copy_dashboardCopy a Looker dashboard to a different folder.
copy_lookCopy a Looker look to a different folder.
create_alertCreate a Looker alert with comparison type, field, threshold, and optional destinations.
create_boardCreate a Looker board with title and description.
create_board_itemAdd an item to a board section.
create_board_sectionCreate a section within a Looker board.
create_connectionCreate a Looker database connection.
create_dashboardCreate a Looker dashboard with title, description, and folder.
create_dashboard_elementCreate a dashboard element (tile).
create_dashboard_filterCreate a dashboard filter.
create_dashboard_layoutCreate a dashboard layout.
create_folderCreate a Looker folder with name and parent folder.
create_groupCreate a Looker group with name and optional parent group.
create_lookCreate a Looker look with title, description, folder, and query.
create_lookml_modelCreate a LookML model with a name, project, and database connections.
create_merge_queryCreate a merge query that combines results from multiple Looker queries.
create_model_setCreate a Looker model set with name and models.
create_permission_setCreate a Looker permission set with name and permissions.
create_queryCreate a Looker query with model, view, fields, filters, and sorts.
create_query_taskRun a Looker query asynchronously.
create_roleCreate a Looker role with name, permission set, and model set.
create_scheduled_planCreate a Looker scheduled plan to deliver look or dashboard results on a schedule.
create_sql_queryCreate a SQL Runner query with raw SQL.
create_userCreate a Looker user.
create_user_credentials_emailCreate email credentials for a Looker user.
import_dashboard_from_lookmlCreate a dashboard from LookML YAML code.
import_lookml_dashboardImport a LookML dashboard into a folder as a user-defined dashboard.
send_user_credentials_email_password_resetSend a password reset email to a Looker user.

Delete or overwrite (52)​

Remove or replace existing data.

ToolWhat it does
delete_alertDelete a Looker alert by ID.
delete_boardDelete a Looker board by ID.
delete_board_itemDelete a Looker board item by ID.
delete_board_sectionDelete a Looker board section by ID.
delete_connectionDelete a Looker database connection by name.
delete_dashboardDelete a Looker dashboard by ID.
delete_dashboard_elementDelete a dashboard element by ID.
delete_dashboard_filterDelete a dashboard filter by ID.
delete_dashboard_layoutDelete a dashboard layout by ID.
delete_folderDelete a Looker folder by ID.
delete_groupDelete a Looker group by ID.
delete_group_from_groupRemove a member group from a Looker group.
delete_lookDelete a Looker look by ID.
delete_lookml_modelDelete a LookML model by name.
delete_model_setDelete a Looker model set by ID.
delete_permission_setDelete a Looker permission set by ID.
delete_roleDelete a Looker role by ID.
delete_scheduled_planDelete a Looker scheduled plan by ID.
delete_userDelete a Looker user by ID.
delete_user_attribute_group_valueDelete a group-level user attribute value in Looker.
delete_user_attribute_user_valueRemove a user-level attribute value override for a Looker user.
delete_user_credentials_emailDelete email credentials for a Looker user.
kill_queryTerminate a running Looker query by its task ID.
move_dashboardMove a Looker dashboard to a different folder.
move_lookMove a Looker look to a different folder.
remove_user_from_groupRemove a user from a Looker group.
set_role_groupsSet groups for a Looker role.
set_role_usersSet users for a Looker role.
set_user_attribute_group_valueSet the value of a user attribute for a Looker group.
set_user_attribute_user_valueSet a user attribute value for a Looker user.
set_user_rolesSet roles for a Looker user.
sync_lookml_dashboardSync all linked user-defined dashboards to match a LookML dashboard.
update_alertUpdate a Looker alert threshold or enabled status.
update_boardUpdate a Looker board title or description.
update_board_itemUpdate a Looker board item.
update_board_sectionUpdate a Looker board section title or description.
update_connectionUpdate a Looker database connection host, port, database, or credentials.
update_dashboardUpdate a Looker dashboard title, description, folder, timezone, refresh interval, or visibility.
update_dashboard_elementUpdate a dashboard element title, text, query, or display settings.
update_dashboard_filterUpdate a dashboard filter name, title, type, default value, or required setting.
update_dashboard_layoutUpdate a dashboard layout active status or dimensions.
update_dashboard_layout_componentUpdate a dashboard layout component position.
update_folderUpdate a Looker folder name.
update_groupUpdate a Looker group name or content metadata access.
update_lookUpdate a Looker look title, description, folder, query, visibility, or owner.
update_lookml_modelUpdate a LookML model's project or database connections.
update_model_setUpdate a Looker model set name or models.
update_permission_setUpdate a Looker permission set name or permissions.
update_roleUpdate a Looker role name, permission set, or model set.
update_scheduled_planUpdate a Looker scheduled plan name, cron expression, or enabled status.
update_session_workspaceSwitch the API session workspace to 'production' or 'dev'.
update_userUpdate a Looker user's name, email, roles, or status.
⌘J