Product DocumentationAppearance
dim.client
The dim.client contains one row per client IP and information about the client that accessed the system. This information is sourced from sys.log_session.
| Column Name | Data Type | Description | Example |
|---|---|---|---|
client_sk | BIGINT | A sequencer generated unique ID for a client. | 1024 |
ip | BIGINT | IP number as per client_ip_address in sys.log_session that can be accessed via session_id from sys.log_query. | 49.248.77.118 |
hostname | VARCHAR | Host name as per hostname in sys.log_session. | |
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 |