compiler
Execute query with transparent caching
Execute a query with transparent caching.
Compiles the resolved query to SQL, checks the cache for existing results, executes against the warehouse on cache miss, and stores the result for future requests. Cache failures are invisible to the caller.
RLS: Filtered to current client (ClientRLSDB).
post/api/v1/compiler/execute
Query parameters
sourcestring nullable
Headers
X-Kater-CLI-IDstring nullable
Request body
Example request
{
"resolved_query": {
"chart_hints": [
{
"config": {
"color_by": "ref(created_date)",
"size": "ref(created_date)",
"stack_by": "ref(created_date)",
"x_axis": "ref(created_date)",
"y_axis": "ref(created_date)"
}
}
],
"filters": [
{
"exists": {
"from": "ref(dim_customer.sale_price)"
},
"not_exists": {
"from": "ref(dim_customer.sale_price)"
}
}
],
"resolved_chart": {
"config": {
"color_by": "ref(created_date)",
"size": "ref(created_date)",
"stack_by": "ref(created_date)",
"x_axis": "ref(created_date)",
"y_axis": "ref(created_date)"
}
},
"resolved_variables": [
{
"allowed_values": {
"from_column": "ref(dim_customer.sale_price)"
}
}
],
"select_from": [
{
"ref": "ref(dim_customer.sale_price)"
}
],
"source_query": "ref(dim_customer.sale_price)",
"topic": "ref(dim_customer.sale_price)"
}
}Response
Successful Response