Product DocumentationAppearance
dim.user
The dim.user contains one row per user identity using a Type 1 dimension schema.
- Upon user creation, a record is inserted into this table.
- Upon user deletion, a corresponding entry is removed from the table.
A user can be deleted, and a record with the same username may reappear later. Presently, it's challenging to discern that it's the same user.
| Column Name | Data Type | Description | Example |
|---|---|---|---|
sk_user | BIGINT | A sequencer generated unique ID for a cluster. | 16384 |
username | VARCHAR | The name of user who has been provided access to the instance. | testuser@yellowbrick.com |
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 |