looker-query

tools:
    query:
        kind: looker-query
        source: looker-source
        description: |
          This tool runs a query against a LookML model and returns the results in JSON format.

          Required Parameters:
          - model_name: The name of the LookML model (from `get_models`).
          - explore_name: The name of the explore (from `get_explores`).
          - fields: A list of field names (dimensions, measures, filters, or parameters) to include in the query.

          Optional Parameters:
          - pivots: A list of fields to pivot the results by. These fields must also be included in the `fields` list.
          - filters: A map of filter expressions, e.g., `{"view.field": "value", "view.date": "7 days"}`.
            - Do not quote field names.
            - Use `not null` instead of `-NULL`.
            - If a value contains a comma, enclose it in single quotes (e.g., "'New York, NY'").
          - sorts: A list of fields to sort by, optionally including direction (e.g., `["view.field desc"]`).
          - limit: Row limit (default 500). Use "-1" for unlimited.
          - query_timezone: specific timezone for the query (e.g. `America/Los_Angeles`).

          Note: Use `get_dimensions`, `get_measures`, `get_filters`, and `get_parameters` to find valid fields.

          The result of the query tool is JSON