Query Types

Contiamo Data Hub supports three query types:

  • Aggregate: retrieves measures grouped by dimensions

  • Record: fetches unaggregated rows for given fields

  • SQL: standard SQL queries run on physical tables defined in a schema

Queries always target a specific schema, and the fields of a query must therefore reference corresponding fields in the schema.

Queries can be constructed visually using the drag-and-drop Query Editor or written out as code in the Query Editor.

Queries can be persisted with added optional parameters as endpoints.

Read Next: