Metrics Explorer
runMetricExplorerQuery
API
My Account
- Overview
- GETGetAuthenticatedUser
- POSTRegisterUser
- PUTCreateEmailOneTimePasscode
- GETGetEmailVerificationStatus
- GETListMyAvailableOrganizations
- POSTJoinOrganization
- DELDeleteMe
- GETcreateWarehouseCredentials
- POSTupdateWarehouseCredentials
- DELdeleteWarehouseCredentials
- PATCHupdateWarehouseCredentials
- GETgetLoginOptions
- PATCHRotate personal access token
Organizations
- Overview
- GETGetMyOrganization
- PUTCreateOrganization
- PATCHUpdateMyOrganization
- DELDeleteMyOrganization
- GETListOrganizationProjects
- GETListOrganizationMembers
- GETGetOrganizationMemberByUuid
- DELDeleteOrganizationMember
- GETListOrganizationEmailDomains
- PATCHUpdateOrganizationEmailDomains
- GETListGroupsInOrganization
- POSTCreateGroupInOrganization
Projects
- Overview
- GETGetExplores
- PUTSetExplores
- GETGetExplore
- POSTCompileQuery
- POSTDownloadCsvFromExplore
- GETGetProject
- GETListChartsInProject
- GETListChartSummariesInProject `Deprecated`
- GETListSpacesInProject
- GETGetProjectAccessList
- POSTCalculateTotalFromQuery
- GETgetUserWarehouseCredentialsPreference
- PATCHupdateUserWarehouseCredentialsPreference
- GETgetCustomMetrics
- PATCHupdateProjectMetadata
- DELdeleteProjectSemanticLayerConnection
- PATCHupdateProjectSemanticLayerConnection
- GETgetDashboards
- POSTcreateDashboard
- PATCHupdateDashboards
- POSTcreatePreview
- PATCHPatch apiv1projects schedulersettings
- GETgetTags
- POSTcreateTag
- DELdeleteTag
- PATCHupdateTag
- GETgetChartsAsCode
- GETgetDashboardsAsCode
- POSTupsertChartAsCode
- POSTupsertDashboardAsCode
- GETGetLatestValidationResults
- POSTValidateProject
- DELDeleteValidationDismiss
Roles & Permissions
- PATCHUpdateOrganizationMember
- POSTCreateSpaceInProject
- GETGet apiv1projects access
- POSTGetProjectAccessList
- GETGetProjectMemberAccess
- DELRevokeProjectAccessForUser
- PATCHGrantProjectAccessToUser
- PATCHUpdateSpace
- POSTAddSpaceUserAccess
- DELRevokeSpaceAccessForUser
- POSTAddSpaceGroupAccess
- DELRevokeGroupSpaceAccess
Catalog
- GETgetCatalog
- GETgetMetadata
- GETgetAnalytics
- GETgetAnalyticsField
- GETgetMetricsCatalog
- GETgetMetric
- GETgetMetricsWithTimeDimensions
- GETgetSegmentDimensions
- POSTaddCategoryToCatalogItem
- DELremoveCategoryFromCatalogItem
- PATCHupdateCatalogItemIcon
- GETgetMetricsTree
- POSTcreateMetricsTreeEdge
- DELdeleteMetricsTreeEdge
Exports
Git Integration
User Groups
Metrics Explorer
Notifications
Charts
Schedulers
Share links
SSH Keypairs
Metrics Explorer
runMetricExplorerQuery
Run a metrics explorer query
POST
/
api
/
v1
/
projects
/
{projectUuid}
/
metricsExplorer
/
{explore}
/
{metric}
/
runMetricExplorerQuery
{
"results": {
"results": [
{
"compareMetric": {
"label": "<string>",
"value": 123
},
"metric": {
"label": "<string>",
"value": 123
},
"segment": "<string>",
"date": "2023-11-07T05:31:56Z",
"dateValue": 123
}
],
"fields": {},
"segmentDimension": {
"fieldType": "dimension",
"type": "string",
"name": "<string>",
"label": "<string>",
"table": "<string>",
"tableLabel": "<string>",
"sql": "<string>",
"description": "<string>",
"source": {
"content": "<string>",
"highlight": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"range": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"path": "<string>"
},
"hidden": true,
"compact": "thousands",
"round": 123,
"format": "km",
"groupLabel": "<string>",
"groups": [
"<string>"
],
"urls": [
{
"label": "<string>",
"url": "<string>"
}
],
"index": 123,
"tags": [
"<string>"
],
"group": "<string>",
"requiredAttributes": {},
"timeInterval": "RAW",
"timeIntervalBaseDimensionName": "<string>",
"isAdditionalDimension": true,
"colors": {},
"isIntervalBase": true
},
"compareMetric": {
"fieldType": "metric",
"type": "percentile",
"name": "<string>",
"label": "<string>",
"table": "<string>",
"tableLabel": "<string>",
"sql": "<string>",
"description": "<string>",
"source": {
"content": "<string>",
"highlight": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"range": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"path": "<string>"
},
"hidden": true,
"compact": "thousands",
"round": 123,
"format": "km",
"groupLabel": "<string>",
"groups": [
"<string>"
],
"urls": [
{
"label": "<string>",
"url": "<string>"
}
],
"index": 123,
"tags": [
"<string>"
],
"isAutoGenerated": true,
"showUnderlyingValues": [
"<string>"
],
"filters": [
{
"values": [
"<any>"
],
"operator": "isNull",
"id": "<string>",
"target": {
"fieldRef": "<string>"
},
"settings": "<any>",
"disabled": true,
"required": true
}
],
"percentile": 123,
"formatOptions": {
"type": "default",
"round": 123,
"separator": "default",
"currency": "<string>",
"compact": "thousands",
"prefix": "<string>",
"suffix": "<string>",
"timeInterval": "RAW"
},
"dimensionReference": "<string>",
"requiredAttributes": {},
"defaultTimeDimension": {
"interval": "RAW",
"field": "<string>"
},
"compiledSql": "<string>",
"tablesReferences": [
"<string>"
],
"tablesRequiredAttributes": {},
"availableTimeDimensions": [
{
"fieldType": "dimension",
"type": "date",
"name": "<string>",
"label": "<string>",
"table": "<string>",
"tableLabel": "<string>",
"sql": "<string>",
"description": "<string>",
"source": {
"content": "<string>",
"highlight": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"range": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"path": "<string>"
},
"hidden": true,
"compact": "thousands",
"round": 123,
"format": "km",
"groupLabel": "<string>",
"groups": [
"<string>"
],
"urls": [
{
"label": "<string>",
"url": "<string>"
}
],
"index": 123,
"tags": [
"<string>"
],
"group": "<string>",
"requiredAttributes": {},
"timeInterval": "RAW",
"timeIntervalBaseDimensionName": "<string>",
"isAdditionalDimension": true,
"colors": {},
"isIntervalBase": true,
"compiledSql": "<string>",
"tablesReferences": [
"<string>"
],
"tablesRequiredAttributes": {}
}
],
"timeDimension": {
"interval": "RAW",
"field": "<string>",
"table": "<string>"
}
},
"metric": {
"fieldType": "metric",
"type": "percentile",
"name": "<string>",
"label": "<string>",
"table": "<string>",
"tableLabel": "<string>",
"sql": "<string>",
"description": "<string>",
"source": {
"content": "<string>",
"highlight": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"range": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"path": "<string>"
},
"hidden": true,
"compact": "thousands",
"round": 123,
"format": "km",
"groupLabel": "<string>",
"groups": [
"<string>"
],
"urls": [
{
"label": "<string>",
"url": "<string>"
}
],
"index": 123,
"tags": [
"<string>"
],
"isAutoGenerated": true,
"showUnderlyingValues": [
"<string>"
],
"filters": [
{
"values": [
"<any>"
],
"operator": "isNull",
"id": "<string>",
"target": {
"fieldRef": "<string>"
},
"settings": "<any>",
"disabled": true,
"required": true
}
],
"percentile": 123,
"formatOptions": {
"type": "default",
"round": 123,
"separator": "default",
"currency": "<string>",
"compact": "thousands",
"prefix": "<string>",
"suffix": "<string>",
"timeInterval": "RAW"
},
"dimensionReference": "<string>",
"requiredAttributes": {},
"defaultTimeDimension": {
"interval": "RAW",
"field": "<string>"
},
"compiledSql": "<string>",
"tablesReferences": [
"<string>"
],
"tablesRequiredAttributes": {},
"availableTimeDimensions": [
{
"fieldType": "dimension",
"type": "date",
"name": "<string>",
"label": "<string>",
"table": "<string>",
"tableLabel": "<string>",
"sql": "<string>",
"description": "<string>",
"source": {
"content": "<string>",
"highlight": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"range": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"path": "<string>"
},
"hidden": true,
"compact": "thousands",
"round": 123,
"format": "km",
"groupLabel": "<string>",
"groups": [
"<string>"
],
"urls": [
{
"label": "<string>",
"url": "<string>"
}
],
"index": 123,
"tags": [
"<string>"
],
"group": "<string>",
"requiredAttributes": {},
"timeInterval": "RAW",
"timeIntervalBaseDimensionName": "<string>",
"isAdditionalDimension": true,
"colors": {},
"isIntervalBase": true,
"compiledSql": "<string>",
"tablesReferences": [
"<string>"
],
"tablesRequiredAttributes": {}
}
],
"timeDimension": {
"interval": "RAW",
"field": "<string>",
"table": "<string>"
}
}
},
"status": "ok"
}
Path Parameters
The project UUID
The explore name
The metric name
Body
application/json
Response
200
application/json
Success
The response is of type object
.
{
"results": {
"results": [
{
"compareMetric": {
"label": "<string>",
"value": 123
},
"metric": {
"label": "<string>",
"value": 123
},
"segment": "<string>",
"date": "2023-11-07T05:31:56Z",
"dateValue": 123
}
],
"fields": {},
"segmentDimension": {
"fieldType": "dimension",
"type": "string",
"name": "<string>",
"label": "<string>",
"table": "<string>",
"tableLabel": "<string>",
"sql": "<string>",
"description": "<string>",
"source": {
"content": "<string>",
"highlight": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"range": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"path": "<string>"
},
"hidden": true,
"compact": "thousands",
"round": 123,
"format": "km",
"groupLabel": "<string>",
"groups": [
"<string>"
],
"urls": [
{
"label": "<string>",
"url": "<string>"
}
],
"index": 123,
"tags": [
"<string>"
],
"group": "<string>",
"requiredAttributes": {},
"timeInterval": "RAW",
"timeIntervalBaseDimensionName": "<string>",
"isAdditionalDimension": true,
"colors": {},
"isIntervalBase": true
},
"compareMetric": {
"fieldType": "metric",
"type": "percentile",
"name": "<string>",
"label": "<string>",
"table": "<string>",
"tableLabel": "<string>",
"sql": "<string>",
"description": "<string>",
"source": {
"content": "<string>",
"highlight": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"range": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"path": "<string>"
},
"hidden": true,
"compact": "thousands",
"round": 123,
"format": "km",
"groupLabel": "<string>",
"groups": [
"<string>"
],
"urls": [
{
"label": "<string>",
"url": "<string>"
}
],
"index": 123,
"tags": [
"<string>"
],
"isAutoGenerated": true,
"showUnderlyingValues": [
"<string>"
],
"filters": [
{
"values": [
"<any>"
],
"operator": "isNull",
"id": "<string>",
"target": {
"fieldRef": "<string>"
},
"settings": "<any>",
"disabled": true,
"required": true
}
],
"percentile": 123,
"formatOptions": {
"type": "default",
"round": 123,
"separator": "default",
"currency": "<string>",
"compact": "thousands",
"prefix": "<string>",
"suffix": "<string>",
"timeInterval": "RAW"
},
"dimensionReference": "<string>",
"requiredAttributes": {},
"defaultTimeDimension": {
"interval": "RAW",
"field": "<string>"
},
"compiledSql": "<string>",
"tablesReferences": [
"<string>"
],
"tablesRequiredAttributes": {},
"availableTimeDimensions": [
{
"fieldType": "dimension",
"type": "date",
"name": "<string>",
"label": "<string>",
"table": "<string>",
"tableLabel": "<string>",
"sql": "<string>",
"description": "<string>",
"source": {
"content": "<string>",
"highlight": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"range": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"path": "<string>"
},
"hidden": true,
"compact": "thousands",
"round": 123,
"format": "km",
"groupLabel": "<string>",
"groups": [
"<string>"
],
"urls": [
{
"label": "<string>",
"url": "<string>"
}
],
"index": 123,
"tags": [
"<string>"
],
"group": "<string>",
"requiredAttributes": {},
"timeInterval": "RAW",
"timeIntervalBaseDimensionName": "<string>",
"isAdditionalDimension": true,
"colors": {},
"isIntervalBase": true,
"compiledSql": "<string>",
"tablesReferences": [
"<string>"
],
"tablesRequiredAttributes": {}
}
],
"timeDimension": {
"interval": "RAW",
"field": "<string>",
"table": "<string>"
}
},
"metric": {
"fieldType": "metric",
"type": "percentile",
"name": "<string>",
"label": "<string>",
"table": "<string>",
"tableLabel": "<string>",
"sql": "<string>",
"description": "<string>",
"source": {
"content": "<string>",
"highlight": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"range": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"path": "<string>"
},
"hidden": true,
"compact": "thousands",
"round": 123,
"format": "km",
"groupLabel": "<string>",
"groups": [
"<string>"
],
"urls": [
{
"label": "<string>",
"url": "<string>"
}
],
"index": 123,
"tags": [
"<string>"
],
"isAutoGenerated": true,
"showUnderlyingValues": [
"<string>"
],
"filters": [
{
"values": [
"<any>"
],
"operator": "isNull",
"id": "<string>",
"target": {
"fieldRef": "<string>"
},
"settings": "<any>",
"disabled": true,
"required": true
}
],
"percentile": 123,
"formatOptions": {
"type": "default",
"round": 123,
"separator": "default",
"currency": "<string>",
"compact": "thousands",
"prefix": "<string>",
"suffix": "<string>",
"timeInterval": "RAW"
},
"dimensionReference": "<string>",
"requiredAttributes": {},
"defaultTimeDimension": {
"interval": "RAW",
"field": "<string>"
},
"compiledSql": "<string>",
"tablesReferences": [
"<string>"
],
"tablesRequiredAttributes": {},
"availableTimeDimensions": [
{
"fieldType": "dimension",
"type": "date",
"name": "<string>",
"label": "<string>",
"table": "<string>",
"tableLabel": "<string>",
"sql": "<string>",
"description": "<string>",
"source": {
"content": "<string>",
"highlight": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"range": {
"end": {
"character": 123,
"line": 123
},
"start": {
"character": 123,
"line": 123
}
},
"path": "<string>"
},
"hidden": true,
"compact": "thousands",
"round": 123,
"format": "km",
"groupLabel": "<string>",
"groups": [
"<string>"
],
"urls": [
{
"label": "<string>",
"url": "<string>"
}
],
"index": 123,
"tags": [
"<string>"
],
"group": "<string>",
"requiredAttributes": {},
"timeInterval": "RAW",
"timeIntervalBaseDimensionName": "<string>",
"isAdditionalDimension": true,
"colors": {},
"isIntervalBase": true,
"compiledSql": "<string>",
"tablesReferences": [
"<string>"
],
"tablesRequiredAttributes": {}
}
],
"timeDimension": {
"interval": "RAW",
"field": "<string>",
"table": "<string>"
}
}
},
"status": "ok"
}