looker-get-dimensions
A “looker-get-dimensions” tool returns all the dimensions from a given explore in a given model in the source.
2 minute read
About
A looker-get-dimensions tool returns all the dimensions from a given explore
in a given model in the source.
looker-get-dimensions accepts two parameters, the model and the explore.
Compatible Sources
This tool can be used with the following database sources:
| Source Name |
|---|
| Looker Source |
Example
kind: tool
name: get_dimensions
type: looker-get-dimensions
source: looker-source
description: |
This tool retrieves a list of dimensions defined within a specific Looker explore.
Dimensions are non-aggregatable attributes or characteristics of your data
(e.g., product name, order date, customer city) that can be used for grouping,
filtering, or segmenting query results.
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 dimension includes a `suggestions` field, its contents are valid values
that can be used directly as filters for that dimension.
- 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.
- If a dimension includes a `value_format` or `value_format_name` field, it
describes how the dimension's values should be displayed (for example as a
currency amount or a percentage). Format any values returned for that
dimension accordingly instead of reporting the raw number.
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",
"value_format": "excel style format string",
"value_format_name": "named value format"
}
value_format is the Excel-style format string defined by the LookML
value_format
parameter, and value_format_name is the name of the format defined by the
LookML
value_format_name
parameter. Both keys are omitted when the field does not define them.
Reference
| field | type | required | description |
|---|---|---|---|
| type | string | true | Must be “looker-get-dimensions”. |
| source | string | true | Name of the source the SQL should execute on. |
| description | string | true | Description of the tool that is passed to the LLM. |
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.