User tags dimension table (Redshift)
Bi_DimUserTags
Captures HubSpot-related user tags. HubSpot tags (those starting with HS_) have been decoupled from Bi_DimUser and now reside in this dedicated table; all other user tags continue to flow to Bi_DimUser.
Field | Field type | Description | Primary Key | Mapped Dimension table | Mapped Dimension field |
|---|---|---|---|---|---|
UserId | VARCHAR(36) | Unique identifier (GUID) of the user the tags belong to | PK | Bi_DimUser | userwid |
CenterId | VARCHAR(36) | Unique identifier (GUID) of the center associated with the user | Bi_DimCenter | centerwid | |
OrganizationId | VARCHAR(36) | Unique identifier (GUID) of the organization | an organization entity in the source system | ||
UserTags | NVARCHAR(MAX) | Comma-separated or JSON list of tags assigned to the user | |||
Void | BOOLEAN | Indicates whether the record has been voided/soft-deleted | |||
EtlLastUpdatedOn | TIMESTAMP | Timestamp of the last ETL update (defaults to current UTC time) | |||
EtlLastUpdatedBy | NVARCHAR(50) | User or process that last updated this record via ETL | |||
PodName | VARCHAR(20) | Name of the source pod from which the data originated | |||
groupid | BIGINT | Group identifier for multi-tenant partitioning |