Skip to main content
GET
/
v1
/
factTables
List FactTable
curl --request GET \
  --url https://metrics.eu.confidence.dev/v1/factTables \
  --header 'Authorization: Bearer <token>'
{
  "factTables": [
    {
      "sql": "<string>",
      "displayName": "<string>",
      "timestampColumn": {
        "name": "<string>",
        "repeated": true
      },
      "entities": [
        {
          "column": {
            "name": "<string>",
            "repeated": true
          },
          "entity": "<string>"
        }
      ],
      "schemaValidationJob": "<string>",
      "createTime": {},
      "updateTime": {},
      "creator": "<string>",
      "updater": "<string>",
      "name": "<string>",
      "description": "<string>",
      "measures": [
        {
          "column": {
            "name": "<string>",
            "repeated": true
          },
          "displayName": "<string>",
          "unit": {
            "baseUnitMultiplier": 123,
            "currencyCode": "<string>",
            "customUnit": "<string>",
            "entity": "<string>",
            "factTable": "<string>"
          }
        }
      ],
      "partitionedUpdateStrategyState": {
        "currentPartitionLastCheckTime": {},
        "existsCheckDuration": {},
        "usualLateness": {},
        "count": 123
      },
      "dimensions": [
        {
          "name": "<string>",
          "repeated": true
        }
      ],
      "error": {
        "message": "<string>",
        "details": [
          "<string>"
        ]
      },
      "factDataDeliveredUntilTime": {},
      "dataDeliveredUntilUpdateStrategyConfig": {
        "disableEmptyPartitions": true,
        "automaticUpdateConfig": {
          "commitDelay": {},
          "incrementDuration": {},
          "changeThreshold": {
            "value": "<string>"
          }
        },
        "dailyUpdateConfig": {
          "maxZeroDuration": {}
        },
        "hourlyUpdateConfig": {
          "maxZeroDuration": {}
        }
      },
      "deleteTime": {},
      "labels": [
        {}
      ],
      "owner": "<string>",
      "systemCreated": true
    }
  ],
  "nextPageToken": "<string>"
}

Documentation Index

Fetch the complete documentation index at: https://confidence-auth-testing.mintlify.io/llms.txt

Use this file to discover all available pages before exploring further.

Authorizations

​
Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Query Parameters

​
pageSize
object

The maximum number of fact tables to fetch.

​
pageToken
string

Token used for pagination.

​
filter
string

Filtering for fact tables, follows the lucene query string format for example 'name: "factTables/abc"', see FactTable type for available fields.

​
showDeleted
boolean

If deleted fact tables should be included.

​
orderBy
string

Provide fields and direction to sort by. Will always tiebreak on name. Format: {"<"}field_0{">"}:{"<"}direction{">"}, {"<"}field_1{">"}:{"<"}direction{">"} Example: displayName:desc,createTime:asc

Response

200 - application/json

OK

​
factTables
FactTable · object[]
required

FactTable: List of matching fact tables.

​
nextPageToken
string

Token to fetch the next page, empty if no more pages.