Skip to end of metadata
Go to start of metadata

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)
  • No labels