Incentive Codes Data

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 most recent data refresh. Data is refreshed once per day. For example, if you are looking at the data set on 7/18, it will contain data from 7/11 to present.

What data can be pulled?

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

Sample Query

–- A query that will pull all sms messages from yesterday
SELECT
INCENTIVE_CODE
, INCENTIVE_POOL_NAME
, ISSUED
,ACTIVE
,INSERT_SOURCE
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)