Product DocumentationAppearance
dim.application
The dim.application consists of applications accessing the system (as per the application_name string in sys.log_query). Application is likely to be matched to various business units in large systems.
| Column Name | Data Type | Description | Example |
|---|---|---|---|
application_sk | BIGINT | A sequencer generated unique ID for a client. | 108544 |
name | VARCHAR | Name of the application. | glinda |
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 |