---
title: "Execute a query against a semantic model"
method: POST
path: "/v3/teams/{team_id}/integrations/{integration_id}/semantic-models/query"
tags: ["v3", "Semantic Modeling"]
---

# Execute a query against a semantic model

`POST /v3/teams/{team_id}/integrations/{integration_id}/semantic-models/query`

Execute a Cube query against an semantic model and return the generated SQL.

The semantic model is loaded from GCS and the query is parsed to generate
the corresponding SQL query.

## Path parameters

- `team_id` string, uuid, required
- `integration_id` string, uuid, required

## Request body

- SemanticModelQueryRequest — Request schema for semantic model query.
  - `query` CubeQuerySchema, required — Schema for Cube query request.
    - `dimensions` string[], nullable
    - `measures` string[], nullable
    - `filters` CubeQueryFilterSchema[], nullable
      - `member` string, nullable
      - `dimension` string, nullable
      - `measure` string, nullable
      - `operator` 'equals' | 'notEquals' | 'contains' | 'notContains' | 'gt' | 'gte' | 'lt' | 'lte' | 'set' | 'notSet' | 'inDateRange' | 'notInDateRange' | 'beforeDate' | 'afterDate' | 'startsWith' | 'endsWith'
      - `values` string[], nullable
    - `timeDimensions` CubeQueryTimeDimensionSchema[], nullable
      - `dimension` string, required
      - `dateRange` string, nullable
      - `compareDateRange` string[], nullable — List of date ranges for period-over-period comparison. Mutually exclusive with dateRange.
      - `granularity` string, nullable
    - `segments` string[], nullable
    - `order` CubeQueryOrderSchema[], nullable
      - `id` string, required
      - `desc` boolean
    - `limit` integer, nullable
    - `offset` integer, nullable
    - `timezone` string, nullable
    - `ungrouped` boolean, nullable

## Response `200`

Successful Response

- SemanticModelQueryResponse — Response schema for semantic model query.
  - `sql` unknown[], required — SQL query and parameters
    - unknown
  - `aliasNameToMember` object, nullable
  - `memberNames` string[], nullable — Member names
  - `cacheKeyQueries` unknown[], nullable
    - unknown
  - `canUseTransformedQuery` object, nullable
  - `dataSource` string, nullable
  - `external` boolean, nullable
  - `lambdaQueries` object, nullable
  - `order` object, nullable
  - `preAggregations` unknown[], nullable
    - unknown
  - `rollupMatchResults` unknown[], nullable
    - unknown
  - `raw_schema` object, nullable
  - `execution_time_ms` number, nullable

## Other responses

- `422` — Validation Error

---

[API](https://skmtc.dev/definite/apis/defapi.md) · [All operations](https://skmtc.dev/definite/apis/defapi/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/definite/defapi/revisions/3943d8deb3be/schema)