Get DimensionTable

Get a dimension table.

GET /v1/dimensionTables/{dimensionTable}

Get DimensionTable

cURL

curl --request GET \
  --url https://metrics.eu.confidence.dev/v1/dimensionTables/{dimensionTable} \
  --header 'Authorization: Bearer <token>'

200

{
  "sql": "<string>",
  "displayName": "<string>",
  "entityColumnMapping": {},
  "dimensions": [
    {}
  ],
  "state": {},
  "schemaValidationJob": "<string>",
  "createTime": {},
  "updateTime": {},
  "creator": "<string>",
  "updater": "<string>",
  "name": "<string>",
  "description": "<string>",
  "timeConfig": {},
  "valueMappings": [
    {}
  ],
  "error": {},
  "dimensionDataDeliveredUntilTime": {},
  "partitionedUpdateStrategyState": {},
  "dataDeliveredUntilUpdateStrategyConfig": {},
  "deleteTime": {},
  "labels": [
    {}
  ],
  "owner": "<string>",
  "systemCreated": true
}

Authorizations

Authorization · string · header · required

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

Path Parameters

dimensionTable · string · required

Response

200 - application/json

OK

A description of a dataset that contains one or more dimensions of an entity.

sql · string · required

A data warehouse-specific query to get the data of the dimension table.

displayName · string · required

Human friendly name of the dimension table.

entityColumnMapping · object · required

Mapping between columns and entities.

dimensions · object[] · required

Mapping between columns and dimensions of the entities.

state · object · required

Current state of the dimension table.

schemaValidationJob · string · required

Resource name of the sql job that was used to validate the schema of the dimension table.

createTime · object · required

Time when the dimension table was first created.

updateTime · object · required

Time when the dimension table was last updated.

creator · string · required

Reference to the identity that created this dimension table.

updater · string · required

Reference to the identity that last updated this dimension table.

name · string

Unique identifier of the dimension table. For example: dimensionTables/0smva5nxuhv4yts6paxt

description · string

Human readable description of the dimension table.

timeConfig · object

If set, the dimension is allowed to change over time, if not they are considered static.

valueMappings · object[]

An optional mapping for dimension values.

error · object

Indicates whether an errors has occurred.

dimensionDataDeliveredUntilTime · object

The current maximum time point where there is available data for the dimension table.

partitionedUpdateStrategyState · object

Current state for checking for new data.

dataDeliveredUntilUpdateStrategyConfig · object

The strategy for updating dimension_data_delivered_until_time in the fact table.

deleteTime · object

Time when the dimension table was deleted.

labels · object[]

Custom labels for this dimension table.

Show child attributes

owner · string

The owner of the resource. If not set will default to the creator.

systemCreated · boolean

If this table is an automatically created internal table.