Skip to main content

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
enum<string>
required

Current state of the dimension table.

Available options:
TABLE_STATE_UNSPECIFIED,
TABLE_STATE_CREATING,
TABLE_STATE_ACTIVE,
TABLE_STATE_FAILED,
TABLE_STATE_UPDATING,
TABLE_STATE_DELETED
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.

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.