Looker

Run a look and get the results. Args: - look_id: Look ID to run - result_format: Format for results (json, csv, txt, html, md, xlsx, sql, png, jpg) - limit: Row limit for results Returns: Query results in the specified format.

Trigger a scheduled plan to run immediately (one-time execution). Args: - scheduled_plan_id: Scheduled plan ID to run Returns: The scheduled plan execution result.

Move a look to a different folder. Args: - look_id: Look ID to move - folder_id: Destination folder ID Returns: The moved look.

Copy a look to create a duplicate. Args: - look_id: Look ID to copy - folder_id: Destination folder (optional, defaults to same folder) Returns: The newly created look copy.

List all dashboards from Looker with pagination. Returns a paginated list of dashboards. Args: - limit: Number of dashboards to return (default: 20) - offset: Offset for pagination - format: Response format ('json' or 'markdown') Returns: List of dashboards with id, title, folder, created date, and view count.

Get a single dashboard by ID. Args: - dashboard_id: The dashboard ID - format: Response format ('json' or 'markdown') Returns: The dashboard details including title, description, elements, filters, and layouts.

Create a new dashboard in Looker. Args: - title: Dashboard title (required) - folder_id: Folder to create the dashboard in - description: Optional description - refresh_interval: Auto-refresh interval (e.g., "5 minutes") - background_color: Background color - show_title: Whether to show the title - show_filters_bar: Whether to show the filters bar - query_timezone: Timezone for queries Returns: The created dashboard.

Search for folders by name or parent. Args: - name: Search by name - parent_id: Filter by parent folder ID - format: Response format Returns: List of matching folders.

Update an existing dashboard. Args: - dashboard_id: Dashboard ID to update - title: New title - description: New description - folder_id: Move to new folder - refresh_interval: New refresh interval - background_color: New background color - show_title: Update show title setting - show_filters_bar: Update filters bar setting - deleted: Soft delete the dashboard Returns: The updated dashboard.

Delete a dashboard from Looker. Args: - dashboard_id: Dashboard ID to delete Returns: Confirmation of deletion.

Search for dashboards by title or folder. Args: - title: Search by title (partial match) - folder_id: Filter by folder ID - limit: Maximum results to return - format: Response format Returns: List of matching dashboards.

Copy a dashboard to create a duplicate. Args: - dashboard_id: Dashboard ID to copy - folder_id: Destination folder (optional, defaults to same folder) Returns: The newly created dashboard copy.

Move a dashboard to a different folder. Args: - dashboard_id: Dashboard ID to move - folder_id: Destination folder ID Returns: The moved dashboard.

List all folders in Looker with pagination. Returns a paginated list of folders. Args: - limit: Number of folders to return (default: 20) - offset: Offset for pagination - format: Response format ('json' or 'markdown') Returns: List of folders with id, name, parent_id, and child count.

Get a single folder by ID. Args: - folder_id: The folder ID - format: Response format ('json' or 'markdown') Returns: The folder details including name, parent, children, looks, and dashboards.

Create a new folder in Looker. Args: - name: Folder name (required) - parent_id: Parent folder ID (required) Returns: The created folder.

Update an existing folder. Args: - folder_id: Folder ID to update - name: New name - parent_id: Move to new parent folder Returns: The updated folder.

Delete a folder from Looker. Args: - folder_id: Folder ID to delete Returns: Confirmation of deletion.

Get all child folders of a folder. Args: - folder_id: Parent folder ID - format: Response format Returns: List of child folders.

Get all looks in a folder. Args: - folder_id: Folder ID - format: Response format Returns: List of looks in the folder.

Get all dashboards in a folder. Args: - folder_id: Folder ID - format: Response format Returns: List of dashboards in the folder.

Delete a scheduled plan from Looker. Args: - scheduled_plan_id: Scheduled plan ID to delete Returns: Confirmation of deletion.

List all looks from Looker with pagination. Returns a paginated list of looks. Args: - limit: Number of looks to return (default: 20) - offset: Offset for pagination - format: Response format ('json' or 'markdown') Returns: List of looks with id, title, folder, created date, and view count.

Get a single look by ID. Args: - look_id: The look ID - format: Response format ('json' or 'markdown') Returns: The look details including title, description, query, folder, and metadata.

Create a new look in Looker. Args: - title: Look title (required) - query_id: ID of the query to associate with the look - folder_id: Folder to create the look in - description: Optional description - is_run_on_load: Whether to run the query when the look loads Returns: The created look.

Update an existing look. Args: - look_id: Look ID to update - title: New title - description: New description - folder_id: Move to new folder - is_run_on_load: Update run on load setting - deleted: Soft delete the look Returns: The updated look.

Delete a look from Looker. Args: - look_id: Look ID to delete Returns: Confirmation of deletion.

Search for looks by title or folder. Args: - title: Search by title (partial match) - folder_id: Filter by folder ID - limit: Maximum results to return - format: Response format Returns: List of matching looks.

Create a new query object in Looker. Args: - model: LookML model name (required) - view: Explore/view name (required) - fields: Array of field names to include (required) - filters: Object mapping field names to filter values - sorts: Array of field names to sort by (prefix with "-" for descending) - limit: Row limit (as string) - pivots: Array of field names to pivot on - total: Whether to include totals Returns: The created query object with its ID.

Get details of an existing query by ID. Args: - query_id: Query ID Returns: The query object with model, view, fields, filters, etc.

Run an existing query and get results. Args: - query_id: Query ID to run - result_format: Format for results (json, csv, txt, html, md, xlsx, sql, png, jpg) - limit: Row limit for results Returns: Query results in the specified format.

Create and run a query in one step without saving it. This is the most common way to query data from Looker programmatically. Args: - model: LookML model name (required) - view: Explore/view name (required) - fields: Array of field names to include (required) - filters: Object mapping field names to filter values - sorts: Array of field names to sort by - limit: Row limit - result_format: Format for results (default: json) Returns: Query results in the specified format.

Create a raw SQL query in Looker. Args: - sql: SQL query string (required) - connection_name: Database connection name - model_name: LookML model name (for context) Returns: The created SQL query object with its slug.

Get details of an existing SQL query by slug. Args: - slug: SQL query slug Returns: The SQL query object.

Run an existing SQL query and get results. Args: - slug: SQL query slug to run - result_format: Format for results (json, csv, txt) Returns: Query results in the specified format.

List all LookML models available in Looker. Returns: List of models with their explores.

Get details of a specific LookML model. Args: - model_name: LookML model name Returns: Model details including explores, connections, and project.

Get details of a specific explore including all available fields. This is useful for discovering what dimensions and measures are available to query. Args: - model_name: LookML model name - explore_name: Explore name Returns: Explore details including dimensions, measures, filters, and joins.

Search for content (looks, dashboards) across Looker. Args: - terms: Search terms - limit: Maximum results to return - types: Content types to include (e.g., "look,dashboard") Returns: List of matching content items.

List all scheduled plans in Looker. Returns a list of scheduled plans. Args: - user_id: Filter by owner user ID - format: Response format ('json' or 'markdown') Returns: List of scheduled plans with id, name, enabled status, schedule, and destinations.

Get a single scheduled plan by ID. Args: - scheduled_plan_id: The scheduled plan ID - format: Response format ('json' or 'markdown') Returns: The scheduled plan details including schedule, destinations, and settings.

Search for users by email or name. Args: - email: Search by email - first_name: Search by first name - last_name: Search by last name - format: Response format Returns: List of matching users.

Create a new scheduled plan for a look or dashboard. Args: - name: Plan name - look_id: Look ID to schedule (mutually exclusive with dashboard_id) - dashboard_id: Dashboard ID to schedule (mutually exclusive with look_id) - crontab: Cron schedule expression (e.g., "0 9 * * 1" for Mondays at 9am) - timezone: Timezone for the schedule - title: Email subject/title - enabled: Whether the schedule is enabled - require_results: Only send if there are results - require_no_results: Only send if there are no results - require_change: Only send if results have changed - scheduled_plan_destination: Array of destinations (email, webhook, etc.) Returns: The created scheduled plan.

Update an existing scheduled plan. Args: - scheduled_plan_id: Scheduled plan ID to update - name: New name - title: New title - crontab: New cron schedule - timezone: New timezone - enabled: Update enabled status - require_results: Update require results setting - require_no_results: Update require no results setting - require_change: Update require change setting Returns: The updated scheduled plan.

Get all scheduled plans for a specific look. Args: - look_id: Look ID - format: Response format Returns: List of scheduled plans associated with the look.

Get all scheduled plans for a specific dashboard. Args: - dashboard_id: Dashboard ID - format: Response format Returns: List of scheduled plans associated with the dashboard.

List all alerts in Looker. Args: - look_id: Filter by look ID - dashboard_id: Filter by dashboard ID - format: Response format Returns: List of alerts.

Get a single alert by ID. Args: - alert_id: Alert ID Returns: The alert details.

List all users in Looker with pagination. Returns a paginated list of users. Args: - limit: Number of users to return (default: 20) - offset: Offset for pagination - format: Response format ('json' or 'markdown') Returns: List of users with id, name, email, and status.

Get a single user by ID. Args: - user_id: The user ID - format: Response format ('json' or 'markdown') Returns: The user details including name, email, roles, groups, and credentials.

Get the currently authenticated user (me). Returns: The current user's details.

Create a new user in Looker. Args: - first_name: First name - last_name: Last name - email: Email address - is_disabled: Whether the user is disabled - locale: User locale Returns: The created user.

Update an existing user. Args: - user_id: User ID to update - first_name: New first name - last_name: New last name - email: New email - is_disabled: Update disabled status - locale: Update locale Returns: The updated user.

Delete a user from Looker. Args: - user_id: User ID to delete Returns: Confirmation of deletion.