Challenges dimension table (Redshift)
bi_dimchallenges
Field | Field Type | Primary Key |
|---|---|---|
ChallengePK | BIGINT | PK |
ChallengeID | VARCHAR (36) | |
ChallengeName | VARCHAR (2000) | |
ChallengeDescription | VARCHAR (65535) | |
ChallengeMetrics | BIGINT |
|
ChallengeTypeCount | INTEGER | |
ChallengeStartDate | TIMESTAMP | |
ChallengeEndDate | TIMESTAMP | |
RuleId | VARCHAR (36) | |
CreatedOn | TIMESTAMP | |
CreatedBy | VARCHAR (36) | |
OrganizationId | VARCHAR (36) | |
Void | BOOLEAN | |
ChallengeMetricsName | VARCHAR (2000) | |
ParentChallengeMetricsName | VARCHAR (2000) | |
etllastupdatedon | TIMESTAMP | |
etllastupdatedon | VARCHAR (50) | |
PodName | VARCHAR (20) | |
groupid | BIGINT |