User tags dimension table (s3)
Bi_DimUserTags_s3
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) | GUID of the user the tags belong to | PK | Bi_DimUser | |
CenterId | VARCHAR(36) | GUID of the center associated with the user | Bi_DimCenter | ||
OrganizationId | VARCHAR(36) | GUID of the organization | Bi_DimCenter | ||
UserTags | NVARCHAR(MAX) | Comma-separated or JSON list of tags assigned to the user | |||
Void | BIT | Indicates whether the record is voided (soft-deleted) | |||
EtlLastUpdatedOn | TIMESTAMP | Timestamp of the last ETL update for this record | |||
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 | Identifier for the data group used in ETL partitioning |