Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Last Updated:

Lastupdatedate

Livesearch
placeholderSearch the Vibes Developer Wiki
typepage



This data set contains push messages devices associated with lists of the company's account.

How much data is retained?

This will have the current status of all devices

What data is included?

Column Name

Type

Nullable

Default

Comment

DEVICE_ID

NUMBER(38,0)

FALSE

NULL

Unique id of the device

TENANT_KEY

VARCHAR(16777216)

FALSE

NULL

Vibes ID used to identify a tenant that is associated with the individual

APP_ID

VARCHAR(40)

TRUE

NULL

ID of the mobile app

VIBES_DEVICE_ID

VARCHAR(255)

TRUE

NULL

Vibes unique identifier for each device

DEVICE_OS

VARCHAR(255)

TRUE

NULL

Operating system of the push device (Android or IOS)

PERIOD_START

TIMESTAMP_TZ(9)

TRUE

NULL

Start of device validity period

PERIOD_END

TIMESTAMP_TZ(9)

TRUE

NULL

End of device validity period

PERSON_KEY

VARCHAR(40)

TRUE

NULL

Vibes UID for the recipient

PUSH_TOKEN

VARCHAR(16777216)

TRUE

NULL

Android or IOS Push token

OS_VERSION

VARCHAR(16777216)

TRUE

NULL

Version of the operating system

SDK_VERSION

VARCHAR(16777216)

TRUE

NULL

Version of the SDL

LAST_REGISTERED_DATE

TIMESTAMP_TZ(9)

TRUE

NULL

Last Registered

HARDWARE_MAKE

VARCHAR(255)

TRUE

NULL

Make of their device

HARDWARE_MODEL

VARCHAR(255)

TRUE

NULL

Model Number of their device

APP_VERSION

VARCHAR(255)

TRUE

NULL

Version of the App they're on

ADVERTISING_ID

VARCHAR(255)

TRUE

NULL

Advertising ID

LOCATION_LAT

FLOAT

TRUE

NULL

Latitude (at registration)

LOCATION_LONG

FLOAT

TRUE

NULL

Longitude (at registration)

LOCALE

VARCHAR(255)

TRUE

NULL

Locale

LAST_OPENED_ATTIMESTAMP_TZ(9)

TRUE

NULL

When they last opened the app
DW_CREATED_ATTIMESTAMP_TZ(9)

TRUE

NULL

When this person was added
DW_UPDATED_ATTIMESTAMP_TZ(9)

TRUE

NULL

When it was last updated
PERIOD_START_TTZTIMESTAMP_TZ(9)

TRUE

NULL

Date/time of the start of the validity period
PERIOD_END_TTZTIMESTAMP_TZ(9)

TRUE

NULL

Date/time of the end of the validity period
PERIOD_START_DATE_DIM_KEYTIMESTAMP_TZ(9)

TRUE

NULL

Date of the start of the validity period
PERIOD_END_DATE_DIM_KEYTIMESTAMP_TZ(9)

TRUE

NULL

Date of the end of the validity period
TIMEZONEVARCHAR(16777216)

TRUE

NULL

Timezone of the device
PUSH_STATUSVARCHAR(16777216)

TRUE

NULL

Was this person active in the app in the last 180 days? Values:

ACTIVE, INACTIVE, or UNINSTALLED

PUSH_ADDRESSABLEVARCHAR(16777216)

TRUE

NULL

Do we have a push token for this person? (ACTIVE/INACTIVE)
EXTERNAL_PERSON_IDVARCHAR(16777216)TRHE NULLCustomer's unique identifier (if it is associated at registration or through an API intergration)


What are some sample queries to pull this data?

–- A query that will pull push messages from yesterday
SELECT
EXTERNAL_PERSON_ID
,PERSON_KEY
FROM PUSH_DEVICE
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)