looker-get-measures

A “looker-get-measures” tool returns all the measures from a given explore in a given model in the source.

About

A looker-get-measures tool returns all the measures from a given explore in a given model in the source.

It’s compatible with the following sources:

looker-get-measures accepts two parameters, the model and the explore.

Example

kind: tools
name: get_measures
type: looker-get-measures
source: looker-source
description: |
  This tool retrieves a list of measures defined within a specific Looker explore.
  Measures are aggregatable metrics (e.g., total sales, average price, count of users)
  that are used for calculations and quantitative analysis in your queries.

  Parameters:
  - model_name (required): The name of the LookML model, obtained from `get_models`.
  - explore_name (required): The name of the explore within the model, obtained from `get_explores`.

  Output Details:
  - If a measure includes a `suggestions` field, its contents are valid values
    that can be used directly as filters for that measure.
  - If a `suggest_explore` and `suggest_dimension` are provided, you can query
    that specified explore and dimension to retrieve a list of valid filter values.

The response is a json array with the following elements:

{
  "name": "field name",
  "description": "field description",
  "type": "field type",
  "label": "field label",
  "label_short": "field short label",
  "tags": ["tags", ...],
  "synonyms": ["synonyms", ...],
  "suggestions": ["suggestion", ...],
  "suggest_explore": "explore",
  "suggest_dimension": "dimension"
}

Reference

fieldtyperequireddescription
typestringtrueMust be “looker-get-measures”.
sourcestringtrueName of the source the SQL should execute on.
descriptionstringtrueDescription of the tool that is passed to the LLM.