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 KPIslook 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
- Go to Organization > Connectors and find Looker.
- Click Enable and choose which tools to allow.
- 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.
| Tool | What it does |
|---|---|
get_alert | Get a Looker alert by ID. |
get_all_board_items | Get all board items across all sections. |
get_all_board_sections | Get all board sections across all boards. |
get_board | Get a Looker board by ID. |
get_board_item | Get a Looker board item by ID. |
get_board_section | Get a Looker board section by ID. |
get_connection | Get a Looker database connection by name. |
get_current_user | Get the currently authenticated Looker user. |
get_dashboard | Get a Looker dashboard by ID. |
get_dashboard_aggregate_table_lookml | Get aggregate table LookML for each query on a dashboard. |
get_dashboard_element | Get a dashboard element by ID. |
get_dashboard_filter | Get a dashboard filter by ID. |
get_dashboard_layout | Get a dashboard layout by ID. |
get_dashboard_layout_component | Get a dashboard layout component by ID. |
get_dashboard_lookml | Get the LookML YAML representation of a user-defined dashboard. |
get_folder | Get a Looker folder by ID. |
get_folder_children | Get child folders of a Looker folder. |
get_folder_dashboards | Get all dashboards in a Looker folder. |
get_folder_looks | Get all looks in a Looker folder. |
get_group | Get a Looker group by ID. |
get_groups_in_group | Get all groups that are members of a Looker group. |
get_look | Get a Looker look by ID. |
get_lookml_explore | Get a LookML explore with its dimensions, measures, and relationships. |
get_lookml_model | Get a LookML model by name. |
get_merge_query | Get a Looker merge query definition by ID. |
get_model_set | Get a Looker model set by ID. |
get_permission_set | Get a Looker permission set by ID. |
get_query | Get a Looker query definition by ID. |
get_query_by_slug | Get a Looker query by its slug identifier (found in Looker URLs). |
get_query_task | Check the status of an async Looker query task. |
get_query_task_multi_results | Get results of multiple completed async Looker query tasks at once. |
get_query_task_results | Get results of a completed async Looker query task. |
get_role | Get a Looker role by ID. |
get_role_groups | Get all groups assigned to a Looker role. |
get_role_users | Get all users assigned to a Looker role. |
get_scheduled_plan | Get a Looker scheduled plan by ID. |
get_session | Get the current API session. |
get_sql_query | Get a SQL Runner query by its slug. |
get_user | Get a Looker user by ID. |
get_user_attribute_values | Get all user attribute values for a Looker user. |
get_user_credentials_email | Get email credentials for a Looker user. |
get_user_roles | Get roles assigned to a Looker user. |
get_users_in_group | Get all users in a Looker group with pagination. |
get_workspace | Get a Looker workspace by ID ('production' or 'dev'). |
list_boards | List Looker boards with offset pagination. |
list_connections | List Looker database connections. |
list_dashboard_elements | List all elements (tiles) on a Looker dashboard. |
list_dashboard_filters | List all filters on a Looker dashboard. |
list_dashboard_layout_components | List all layout components for a dashboard layout. |
list_dashboard_layouts | List all layouts for a Looker dashboard. |
list_dashboards | List Looker dashboards with offset pagination. |
list_folders | List Looker folders with offset pagination. |
list_groups | List Looker groups with offset pagination. |
list_lookml_models | List available LookML models and their explores. |
list_looks | List Looker looks with offset pagination. |
list_model_sets | List all Looker model sets. |
list_permission_sets | List all Looker permission sets. |
list_permissions | List all available Looker permissions. |
list_roles | List Looker roles. |
list_running_queries | List all currently running Looker queries. |
list_scheduled_plans | List Looker scheduled plans with offset pagination. |
list_users | List Looker users with offset pagination. |
list_workspaces | List all Looker workspaces (production and dev). |
run_inline_query | Run an inline Looker query without saving it. |
run_look | Run a Looker look and return results. |
run_query | Run a saved Looker query and return results. |
run_sql_query | Execute a SQL Runner query and return results. |
search_alerts | Search Looker alerts with offset pagination. |
search_boards | Search Looker boards by title, creator, or favorites. |
search_dashboards | Search Looker dashboards by title or folder. |
search_folders | Search Looker folders by name or parent. |
search_groups | Search Looker groups by name, external group ID, or management flags. |
search_groups_with_hierarchy | Search Looker groups and include parent group hierarchy in results. |
search_groups_with_roles | Search Looker groups and include role information in results. |
search_lookml_dashboards | Search LookML dashboards in production. |
search_looks | Search Looker looks by title, description, or folder. |
search_roles | Search Looker roles by name with pagination. |
search_roles_with_user_count | Search Looker roles by name, including user count per role. |
search_users | Search Looker users by email, first name, last name, disabled status, or group. |
search_users_names | Search Looker users by name or email pattern. |
validate_credential | Validate Looker credentials by fetching the current user. |
Write (30)
Create or send data.
| Tool | What it does |
|---|---|
add_group_to_group | Add a group as a member of another Looker group. |
add_user_to_group | Add a user to a Looker group. |
copy_dashboard | Copy a Looker dashboard to a different folder. |
copy_look | Copy a Looker look to a different folder. |
create_alert | Create a Looker alert with comparison type, field, threshold, and optional destinations. |
create_board | Create a Looker board with title and description. |
create_board_item | Add an item to a board section. |
create_board_section | Create a section within a Looker board. |
create_connection | Create a Looker database connection. |
create_dashboard | Create a Looker dashboard with title, description, and folder. |
create_dashboard_element | Create a dashboard element (tile). |
create_dashboard_filter | Create a dashboard filter. |
create_dashboard_layout | Create a dashboard layout. |
create_folder | Create a Looker folder with name and parent folder. |
create_group | Create a Looker group with name and optional parent group. |
create_look | Create a Looker look with title, description, folder, and query. |
create_lookml_model | Create a LookML model with a name, project, and database connections. |
create_merge_query | Create a merge query that combines results from multiple Looker queries. |
create_model_set | Create a Looker model set with name and models. |
create_permission_set | Create a Looker permission set with name and permissions. |
create_query | Create a Looker query with model, view, fields, filters, and sorts. |
create_query_task | Run a Looker query asynchronously. |
create_role | Create a Looker role with name, permission set, and model set. |
create_scheduled_plan | Create a Looker scheduled plan to deliver look or dashboard results on a schedule. |
create_sql_query | Create a SQL Runner query with raw SQL. |
create_user | Create a Looker user. |
create_user_credentials_email | Create email credentials for a Looker user. |
import_dashboard_from_lookml | Create a dashboard from LookML YAML code. |
import_lookml_dashboard | Import a LookML dashboard into a folder as a user-defined dashboard. |
send_user_credentials_email_password_reset | Send a password reset email to a Looker user. |
Delete or overwrite (52)
Remove or replace existing data.
| Tool | What it does |
|---|---|
delete_alert | Delete a Looker alert by ID. |
delete_board | Delete a Looker board by ID. |
delete_board_item | Delete a Looker board item by ID. |
delete_board_section | Delete a Looker board section by ID. |
delete_connection | Delete a Looker database connection by name. |
delete_dashboard | Delete a Looker dashboard by ID. |
delete_dashboard_element | Delete a dashboard element by ID. |
delete_dashboard_filter | Delete a dashboard filter by ID. |
delete_dashboard_layout | Delete a dashboard layout by ID. |
delete_folder | Delete a Looker folder by ID. |
delete_group | Delete a Looker group by ID. |
delete_group_from_group | Remove a member group from a Looker group. |
delete_look | Delete a Looker look by ID. |
delete_lookml_model | Delete a LookML model by name. |
delete_model_set | Delete a Looker model set by ID. |
delete_permission_set | Delete a Looker permission set by ID. |
delete_role | Delete a Looker role by ID. |
delete_scheduled_plan | Delete a Looker scheduled plan by ID. |
delete_user | Delete a Looker user by ID. |
delete_user_attribute_group_value | Delete a group-level user attribute value in Looker. |
delete_user_attribute_user_value | Remove a user-level attribute value override for a Looker user. |
delete_user_credentials_email | Delete email credentials for a Looker user. |
kill_query | Terminate a running Looker query by its task ID. |
move_dashboard | Move a Looker dashboard to a different folder. |
move_look | Move a Looker look to a different folder. |
remove_user_from_group | Remove a user from a Looker group. |
set_role_groups | Set groups for a Looker role. |
set_role_users | Set users for a Looker role. |
set_user_attribute_group_value | Set the value of a user attribute for a Looker group. |
set_user_attribute_user_value | Set a user attribute value for a Looker user. |
set_user_roles | Set roles for a Looker user. |
sync_lookml_dashboard | Sync all linked user-defined dashboards to match a LookML dashboard. |
update_alert | Update a Looker alert threshold or enabled status. |
update_board | Update a Looker board title or description. |
update_board_item | Update a Looker board item. |
update_board_section | Update a Looker board section title or description. |
update_connection | Update a Looker database connection host, port, database, or credentials. |
update_dashboard | Update a Looker dashboard title, description, folder, timezone, refresh interval, or visibility. |
update_dashboard_element | Update a dashboard element title, text, query, or display settings. |
update_dashboard_filter | Update a dashboard filter name, title, type, default value, or required setting. |
update_dashboard_layout | Update a dashboard layout active status or dimensions. |
update_dashboard_layout_component | Update a dashboard layout component position. |
update_folder | Update a Looker folder name. |
update_group | Update a Looker group name or content metadata access. |
update_look | Update a Looker look title, description, folder, query, visibility, or owner. |
update_lookml_model | Update a LookML model's project or database connections. |
update_model_set | Update a Looker model set name or models. |
update_permission_set | Update a Looker permission set name or permissions. |
update_role | Update a Looker role name, permission set, or model set. |
update_scheduled_plan | Update a Looker scheduled plan name, cron expression, or enabled status. |
update_session_workspace | Switch the API session workspace to 'production' or 'dev'. |
update_user | Update a Looker user's name, email, roles, or status. |