Product DocumentationAppearance
dim.cluster
The dim.cluster gives information about the cluster which is being used for running the queries. It comprises a row for each cluster which is being utilised (using Type 1 dimension schema).
Note: Type 1 Slowly Changing Dimension method overwrites the existing value with the new value and does not retain history.
| Column Name | Data Type | Description | Example |
|---|---|---|---|
cluster_sk | BIGINT | A sequencer generated unique ID for each cluster. | 25600 |
name | VARCHAR | The cluster name per cluster_name in sys.log_query and sys.cluster. | default_cluster |
cluster_id | VARCHAR | ID of the cluster, we use varchar instead of UUID as some extractor tools operate better on this. | fb96868a-cbea-422a-99b4-af485e9b43a9 |
valid_from | TIMESTAMPTZ | The validity start date of the record as per the timestamp at the source system. | 2023-12-19T11:05:31.164920Z |
metering_run | TIMESTAMPTZ | The metering run (one per hour) that created the record. | 2023-12-19T11:05:31.164920Z |