Last Updated: Tuesday, December 7, 2021
This data set contains recently created incentive codes associated with the company's account.
How much data is retained?
This data set will contain 7 days worth of data starting from the previous day. For example, if you are looking at the data set today, 7/18/2019, it will contain data for codes created from 7/11/2019 to present.
What data is included?
Column Name | Type | Nullable | Default | Comment |
INCENTIVE_CODE | VARCHAR(255) | TRUE | NULL | The unique incentive code that is sent to a consumer |
INCENTIVE_POOL_NAME | VARCHAR(255) | TRUE | NULL | Name of the Incentive Pool |
TENANT_KEY | VARCHAR(255) | TRUE | NULL | Tenant key associated with the pool/code |
CREATED_AT | TIMESTAMP_TZ(9) | TRUE | NULL | When the code was created |
UPDATED_AT | TIMESTAMP_TZ(9) | TRUE | NULL | When it was last updated |
ACTIVE | NUMBER(38,0) | TRUE | NULL | Whether or not it is active (1-active; 0-inactive) |
ISSUED | NUMBER(38,0) | TRUE | NULL | Whether or not it is issued at least once (1-issued; 0-not issued) |
DW_CREATED_AT | TIMESTAMP_TZ(9) | TRUE | NULL | When it was added to the warehouse |
DW_UPDATED_AT | TIMESTAMP_TZ(9) | TRUE | NULL | When it was updated last in the warehouse |
What are some sample queries to pull this data?
–- A query that will pull all sms messages from yesterday
SELECT
INCENTIVE_CODE
, INCENTIVE_POOL_NAME
, ISSUED
FROM INCENTIVE_CODES
WHERE CAST(DW_CREATED_AT AS DATE) >= CAST(DATEADD(day,-1,CURRENT_DATE())AS DATE)
AND CAST(DW_CREATED_AT AS DATE) < CAST(CURRENT_DATE() AS DATE)
Overview
Content Tools