A valid request URL is required to generate request examples{
"results": {
"parameterReferences": [
"<string>"
],
"query": "<string>",
"compilationErrors": [
"<string>"
],
"pivotQuery": "<string>"
},
"status": "ok"
}{
"error": {
"name": "<string>",
"statusCode": 123,
"data": "<unknown>",
"message": "<string>"
},
"status": "error"
}Compile query
Compile a metric query for an explore
A valid request URL is required to generate request examples{
"results": {
"parameterReferences": [
"<string>"
],
"query": "<string>",
"compilationErrors": [
"<string>"
],
"pivotQuery": "<string>"
},
"status": "ok"
}{
"error": {
"name": "<string>",
"statusCode": 123,
"data": "<unknown>",
"message": "<string>"
},
"status": "error"
}Body
Custom calculations to perform on query results
- Option 1
- Option 2
- Option 3
Show child attributes
Show child attributes
Maximum number of rows to return
Sort configuration for query results
Show child attributes
Show child attributes
Filter rules to apply to the query
Show child attributes
Show child attributes
List of metric field IDs to include
List of dimension field IDs to include
The name of the explore to query
Show child attributes
Show child attributes
Dimension field IDs used as pivot columns (from chart's pivotConfig.columns). Used by row_total() to determine non-pivot dimensions for GROUP BY.
Timezone for date/time values (e.g., 'America/Los_Angeles', 'UTC')
Override formatting options for existing dimensions
Show child attributes
Show child attributes
Override formatting options for existing metrics
Show child attributes
Show child attributes
Custom dimensions defined inline
- Option 1
- Option 2
- Option 3
- Option 4
- Option 5
Show child attributes
Show child attributes
Custom metrics defined inline (ad-hoc metrics not in the dbt model)
Show child attributes
Show child attributes
Show child attributes
Show child attributes
Construct a type with a set of properties K of type T
Show child attributes
Show child attributes
Was this page helpful?