Snowflake Analytics Schema

Airkit collects data in the form of Events. This includes information on what Events are triggered, how long users interact with your applications before completing their Journeys, and how many users begin a Journey at all. In addition to collecting general information, Airkit will also log any Custom Events that have been defined in an application.

Snowflake Secure Data Sharing

📘

Enterprise Feature

Accessing this data in its raw form requires Snowflake Secure Data Sharing, which requires an ENTERPRISE license. If you would like to enable this feature for your Airkit Organization, please contact your Airkit representative or contact [email protected].

Tables and Properties

Collected data is structured into various tables, each of which contain their own set of properties.

📘

Primary keys

Bold column names indicate that column is part of the primary key for the table

Adapter

Data pertaining to external integrations and how they are authenticated.

PropertyData Type
ORGANIZATION_IDVARCHAR
ADAPTER_IDVARCHAR
CREDENTIAL_TYPEVARCHAR
ADAPTER_KEYVARCHAR
DISPLAY_NAMEVARCHAR
DESCRIPTIONVARCHAR
CREATED_YEARNUMBER
CREATED_MONTHDATE
CREATED_DATEDATE
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
AUTH_PARAM_TYPEVARCHAR
AUTH_PARAM_NAMEVARCHAR
ACCESS_TOKEN_VERBVARCHAR
AUTH_GRANT_TYPEVARCHAR
CAPABILITIESOBJECT

App

Basic data regarding each application.

PropertyData TypeDescription
ORGANIZATION_IDVARCHARUnique identifier of the Organization the app was built in.
APP_IDVARCHARUnique identifier of the application.
DISPLAY_NAMEVARCHARApplication name, as defined when examining the app in the Console.
DESCRIPTIONVARCHARApplication description, as defined when examining the app in the Console.
CREATED_YEARNUMBERYear the application was created.
CREATED_MONTHDATEMonth the application was created.
CREATED_DATEDATEDate the application was created.
CREATED_TIMETIMESTAMPNTZTime the application was created.
MODIFIED_TIMETIMESTAMPNTZTime the application was last modified.

App Subscription

Data pertaining to packets of information passed to external sources via Web Hooks.

PropertyData Type
ORGANIZATION_IDVARCHAR
APP_SUBSCRIPTION_IDVARCHAR
DISPLAY_NAMEVARCHAR
CREATED_YEARNUMBER
CREATED_MONTHDATE
CREATED_DATEDATE
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
DEPLOYMENT_IDVARCHAR
DATA_SOURCE_IDVARCHAR
EVENT_SOURCE_IDVARCHAR
WEBHOOK_CATEGORY_KEYVARCHAR
WEBHOOK_IDENTIFIERVARCHAR
WEBHOOK_EVENT_SOURCEOBJECT
PROPERTIESOBJECT

Asset

Data on Assets used in or downloaded by applications.

PropertyData Type
ORGANIZATION_IDVARCHAR
ASSET_IDVARCHAR
ASSET_KEYVARCHAR
ASSET_VERSIONNUMBER
DISPLAY_NAMEVARCHAR
CONTENT_TYPEVARCHAR
CONTENT_SIZENUMBER
EXPIRATION_TIME_HOURSNUMBER
EXPIRATION_TIME_MINUTESNUMBER
EXPIRATION_TIME_SECONDSNUMBER
EXPIRATION_TIME_MILLISNUMBER
VISIBILITYVARCHAR
STATEVARCHAR
SCOPEVARCHAR
REGIONVARCHAR
CREATED_YEARNUMBER
CREATED_MONTHDATE
CREATED_DATEDATE
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
VALIDATION_ERRORSVARCHAR
EXTRA_INFOOBJECT

Audit Event

Data pertaining to the details of Audit Events, which are used for things like compliance tracking.

PropertyData Type
ORGANIZATION_IDVARCHAR
EVENT_IDVARCHAR
EVENT_YEARNUMBER
EVENT_MONTHDATE
EVENT_DATEDATE
EVENT_TIMETIMESTAMPNTZ
ROOT_SCOPE_USER_IDVARCHAR
USER_IDVARCHAR
EMAILVARCHAR
APP_IDVARCHAR
BRANCH_IDVARCHAR
DEPLOY_IDVARCHAR
SAVEPOINT_IDVARCHAR
SAVEPOINT_REVISIONNUMBER
RESOURCE_TYPEVARCHAR
RESOURCE_IDVARCHAR
DOMAINVARCHAR
DATASTORE_IDVARCHAR
API_KEY_IDVARCHAR
NOTIFIER_IDVARCHAR
SAML_IDVARCHAR
WEBHOOK_IDVARCHAR
ADAPTER_IDVARCHAR
EMBED_IDVARCHAR
ROLE_IDVARCHAR
SERVICEVARCHAR
SERVICE_REVISIONVARCHAR
LOGIN_TYPEVARCHAR
EVENT_TYPEVARCHAR (See possible values below.)

Event Types

Every Audit Event has an associated Event Type, stored under EVENT_TYPE. EVENT_TYPE has the following possible values:

Event Types
portal_page_view
deployment_changed
new_adapter
deleted_api_key
deleted_encryption_key
modified_notifier
new_saml
invite_sent
new_encryption_key
user_support_scope_assigned
deleted_resource
user_role_removed
deleted_notifier
clone_datastore
invalid_login
saml_assertion_received
user_created
user_logout
deleted_domain_certificate
new_embed
user_root_scope_assigned
deleted_adapter
modified_datastore
deleted_datastore
user_login
app_deployed
new_resource
new_api_key
modified_adapter
modified_api_key
data_migration
org_created
new_domain_certificate
modified_domain_certificate
new_notifier
backup_datastore
new_datastore
password_change
modified_embed
user_locked
deleted_embed
app_undeployed
app_created
user_role_added
request_state

Branch

Basic data regarding application branches.

How are application branches created and defined?

Branches in this context represent a linear log of application changes. Most branching of applications occurs whenever an application is deployed. When working directly in the Studio, the logistics of branching is handled under the hood. An application can be deployed, edited, and re-deployed to include the latest changes without the builder needing to consider how branching at all.

Under the hood, an application is forked each time it is deployed. The new version becomes published. It is also locked, or made uneditable, which prevents inadvertent changes from being made to a live app. Any changes made to the application in the Studio are made to the old, unpublished branch, which remains unlocked.

PropertyData Type
ORGANIZATION_IDVARCHARUnique identifier of the Organization the app was built in.
BRANCH_IDVARCHARUnique identifier of the application branch.
APP_IDVARCHARUnique identifier of the application.
DISPLAY_NAMEVARCHARUnique name of branch. A name is automatically generated upon the creation of each branch, and can be edited in the Console.
SOURCE_BRANCH_IDVARCHARUnique identifier of the source branch.
SOURCE_BRANCH_REVISIONNUMBERNumber of revisions from source branch. Count starts with source branch at 0.
DESCRIPTIONVARCHARDescription of branch. A basic description is automatically generated upon the creation of each branch, and can be edited in the Console.
CREATED_YEARNUMBERYear the branch was created.
CREATED_MONTHDATEMonth the branch was created.
CREATED_DATEDATEDate the branch was created.
CREATED_TIMETIMESTAMPNTZTime the branch was created.
MODIFIED_TIMETIMESTAMPNTZTime the branch was last modified.
LOCK_TIMETIMESTAMPNTZTime branch was locked, if applicable. Note that only locked branches can be deployed.
USER_IDVARCHARUnique ID of the builder who created the branch.
FROZENBOOLEANWhether branch is locked. TRUE means that it is, FALSE means that it isn't. Note that only locked branches can be deployed, and locked branches can't be edited.

Custom Metric

Data pertaining to when Custom Metrics occurred.

PropertyData Type
ORGANIZATION_IDVARCHAR
CUSTOM_METRIC_KEYVARCHAR
FIRST_SEEN_TIMETIMESTAMPNTZ
LAST_SEEN_TIMETIMESTAMPNTZ
COUNT_FIRST_SEEN_TIMETIMESTAMPNTZ
COUNT_LAST_SEEN_TIMETIMESTAMPNTZ
STATISTIC_FIRST_SEEN_TIMETIMESTAMPNTZ
STATISTIC_LAST_SEEN_TIMETIMESTAMPNTZ
FIELD_FIRST_SEEN_TIMETIMESTAMPNTZ
FIELD_LAST_SEEN_TIMETIMESTAMPNTZ

Custom Metric Field

Basic data on which Custom Metrics have occurred.

PropertyData Type
ORGANIZATION_IDVARCHAR
CUSTOM_METRIC_KEYVARCHAR
FIELD_VALUEVARCHAR
FIRST_SEEN_TIMETIMESTAMPNTZ
LAST_SEEN_TIMETIMESTAMPNTZ

Custom Metric Field Event

Data pertaining to the instance and value of Custom Metrics.

PropertyData Type
ORGANIZATION_IDVARCHAR
SESSION_IDVARCHAR
EVENT_YEARNUMBER
EVENT_MONTHDATE
EVENT_DATEDATE
EVENT_TIMETIMESTAMPNTZ
CUSTOM_METRIC_KEYVARCHAR
FIELD_VALUEVARCHAR
APP_IDVARCHAR
DEPLOY_IDVARCHAR
BRANCH_IDVARCHAR
EVENT_IDVARCHAR

Custom Metric Info

Data pertaining to the circumstances under which Custom Metrics were logged.

PropertyData Type
ORGANIZATION_IDVARCHAR
CUSTOM_METRIC_IDVARCHAR
APP_IDVARCHAR
BRANCH_IDVARCHAR
FIRST_SEEN_TIMETIMESTAMPNTZ
LAST_SEEN_TIMETIMESTAMPNTZ
COUNT_FIRST_SEEN_TIMETIMESTAMPNTZ
COUNT_LAST_SEEN_TIMETIMESTAMPNTZ
STATISTIC_FIRST_SEEN_TIMETIMESTAMPNTZ
STATISTIC_FIRST_SEEN_TIMETIMESTAMPNTZ
FIELD_FIRST_SEEN_TIMETIMESTAMPNTZ
FIELD_LAST_SEEN_TIMETIMESTAMPNTZ

Custom Session Metric

Data summarizing the details of Custom Metrics.

PropertyData Type
ORGANIZATION_IDVARCHAR
SESSION_IDVARCHAR
CUSTOM_METRIC_KEYVARCHAR
SESSION_YEARNUMBER
SESSION_MONTHDATE
SESSION_DATEDATE
SESSION_TIMETIMESTAMPNTZ
FIRST_TIMESTAMPTIMESTAMPNTZ
LAST_TIMESTAMPTIMESTAMPNTZ
APP_IDVARCHAR
DEPLOY_IDVARCHAR
BRANCH_IDVARCHAR
SAVEPOINT_REVISIONNUMBER
COUNT_COUNTNUMBER
COUNT_FIRST_TIMESTAMPTIMESTAMPNTZ
COUNT_LAST_TIMESTAMPTIMESTAMPNTZ
STATISTIC_COUNTNUMBER
STATISTIC_SUMNUMBER
STATISTIC_MINIMUMNUMBER
STATISTIC_MAXIMUMNUMBER
STATISTIC_FIRSTNUMBER
STATISTIC_LASTNUMBER
STATISTIC_FIRST_TIMESTAMPTIMESTAMPNTZ
STATISTIC_LAST_TIMESTAMPTIMESTAMPNTZ
FIELD_COUNTNUMBER
FIELD_FIRSTVARCHAR
FIELD_LASTVARCHAR
FIELD_FIRST_TIMESTAMPTIMESTAMPNTZ
FIELD_LAST_TIMESTAMPTIMESTAMPNTZ

Datastore

Basic information regarding each Datastore.

PropertyData Type
ORGANIZATION_IDVARCHAR
DATASTORE_IDVARCHAR
DISPLAY_NAMEVARCHAR
APP_IDVARCHAR
DEFAULT_TYPEVARCHAR
CREATED_YEARNUMBER
CREATED_MONTHDATE
CREATED_DATEDATE
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
DESCRIPTIONVARCHAR

Deployment

Basic data regarding application deployment.

PropertyData Type
ORGANIZATION_IDVARCHAR
DEPLOYMENT_IDVARCHAR
DEPLOYMENT_KEYVARCHAR
DISPLAY_NAMEVARCHAR
CREATED_YEARNUMBER
CREATED_MONTHDATE
CREATED_DATEDATE
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
APP_IDVARCHAR
BRANCH_IDVARCHAR
USER_IDVARCHAR
PROFILE_IDVARCHAR
CXR_VERSIONVARCHAR
DESCRIPTIONVARCHAR
RESOURCE_BINDINGSOBJECT
VARIABLESOBJECT
NOTIFICATIONSOBJECT
SHOW_PORTALSBOOLEAN
PORTAL_NAMEVARCHAR
RUN_PERIODIC_TASKBOOLEAN

Funnel

Basic information on any Funnels that have been defined.

PropertyData Type
ORGANIZATION_IDVARCHAR
SELECTOR_KEYVARCHAR
FUNNEL_KEYVARCHAR
FUNNEL_NAMEVARCHAR
FUNNEL_DESCRIPTIONVARCHAR
SELECTOR_NAMEVARCHAR
SELECTOR_DESCRIPTIONVARCHAR

Funnel Definition

Detailed information on how Funnels have been defined.

PropertyData Type
ORGANIZATION_IDVARCHAR
FUNNEL_IDVARCHAR
FUNNEL_STAGE_KEYVARCHAR
DISPLAY_NAMEVARCHAR
DESCRIPTIONVARCHAR
FUNNEL_STEPNUMBER
FUNNEL_NAMEVARCHAR
SELECTOR_KEYVARCHAR
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
SELECTOR_FILTERSVARIANT

Invite

Data regarding sent invites to join an Organization.

PropertyData Type
ORGANIZATION_IDVARCHAR
INVITE_IDVARCHAR
DISPLAY_NAMEVARCHAR
EMAILVARCHAR
STATUSVARCHAR
CREATED_YEARNUMBER
CREATED_MONTHDATE
CREATED_DATEDATE
CREATED_TIMETIMESTAMPNTZ
SENT_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
USERNAMEVARCHAR
VARIABLESVARIANT
URLVARCHAR
ROLESVARIANT
MULTIFACTORBOOLEAN
SSO_ONLYBOOLEAN
FIRST_NAMEVARCHAR
LAST_NAMEVARCHAR

Metric Selector

Data defined by and generated from combing other metrics.

PropertyData Type
ORGANIZATION_IDVARCHAR
SELECTOR_KEYVARCHAR
DISPLAY_NAMEVARCHAR
STATUSVARCHAR
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
DESCRIPTIONVARCHAR
STATUS_MESSAGEVARCHAR
APP_IDVARCHAR
BRANCH_IDVARCHAR

Organization

Basic data pertaining to an Organization.

PropertyData Type
ORGANIZATION_IDVARCHAR
DISPLAY_NAMEVARCHAR
ORGANIZATION_KEYVARCHAR
REALMVARCHAR
WHITE_LABEL_IDVARCHAR
CREATED_YEARNUMBER
CREATED_MONTHDATE
CREATED_DATEDATE
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
SAML_METADATA_IDVARCHAR
LICENSE_KEYVARCHAR
ORGANIZATION_TYPEVARCHAR

Platform Event

Data pertaining to Events that take place beyond the scope of a Journey.

PropertyData Type
ORGANIZATION_IDVARCHAR
EVENT_YEARNUMBER
EVENT_MONTHDATE
EVENT_DATEDATE
EVENT_TIMETIMESTAMPNTZ
EVENT_IDVARCHAR
APP_IDVARCHAR
BRANCH_IDVARCHAR
SAVEPOINT_REVISIONNUMBER
DEPLOY_IDVARCHAR
EVENT_TYPEVARCHAR
STATUSVARCHAR
MESSAGEVARCHAR
SERVICEVARCHAR
SERVICE_VERSIONVARCHAR
CXR_VERSIONVARCHAR
CONNECTION_IDVARCHAR
GROUP_IDVARCHAR
DURATION_MILLISNUMBER

Resource

Data pertaining to external resources used within applications.

PropertyData Type
ORGANIZATION_IDVARCHAR
RESOURCE_IDVARCHAR
DISPLAY_NAMEVARCHAR
CREATED_YEARNUMBER
CREATED_MONTHDATE
CREATED_DATEDATE
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
REMOTE_TYPEVARCHAR
REMOTE_IDVARCHAR
DATA_SOURCE_IDVARCHAR
CREDENTIAL_IDVARCHAR
DOMAIN_IDVARCHAR
URL_IDENTIFIER_IDVARCHAR
PARENT_IDVARCHAR
FROM_ADDRESSVARCHAR
CAPABILITIESOBJECT

Resource Deployment

Data pertaining to how resources were deployed.

PropertyData Type
ORGANIZATION_IDVARCHAR
RESOURCE_DEPLOYMENT_IDVARCHAR
RESOURCE_IDVARCHAR
DEPLOYMENT_IDVARCHAR
CREATED_YEARNUMBER
CREATED_MONTHDATE
CREATED_DATEDATE
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ

Role

Data regarding roles with an Organization.

PropertyData Type
ORGANIZATION_IDVARCHAR
ROLE_IDVARCHAR
FEATURESARRAY
DISPLAY_NAMEVARCHAR
DESCRIPTIONVARCHAR
CREATED_YEARNUMBER
CREATED_MONTHDATE
CREATED_DATEDATE
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
ROLE_RANKVARCHAR
ROLE_KEYVARCHAR

Session Event

Data pertaining to Events that take place within the Scope of a Journey.

PropertyData Type
ORGANIZATION_IDVARCHAR
EVENT_YEARNUMBER
EVENT_MONTHDATE
EVENT_DATEDATE
EVENT_TIMETIMESTAMPNTZ
EVENT_IDVARCHAR
APP_IDVARCHAR
BRANCH_IDVARCHAR
SESSION_IDVARCHAR
DEPLOY_IDVARCHAR
EVENT_TYPEVARCHAR
CUSTOM_METRICSOBJECT
DEFAULT_METRICSOBJECT
SAVEPOINT_REVISIONNUMBER
CHANNEL_IDVARCHAR
CHANNEL_KEYVARCHAR
FLOW_IDVARCHAR
ACTIVITY_IDVARCHAR
ACTOR_IDVARCHAR
RESOURCE_IDVARCHAR
ACTIVITY_GROUP_IDVARCHAR
CLIENTVARCHAR
USER_AGENTVARCHAR
SCREEN_WIDTHNUMBER
SCREEN_HEIGHTNUMBER
HTTP_SOURCEVARCHAR
STATUSVARCHAR
CODENUMBER
SERVICEVARCHAR
SERVICE_VERSIONVARCHAR
EXTERNAL_IDVARCHAR
DURATION_MILLISNUMBER
CXR_VERSIONVARCHAR
SOURCE_RUNTIMEVARCHAR
SOURCE_DETAILVARCHAR
APP_EVENT_PARENT_SCHEMAVARCHAR
APP_EVENT_PARENT_IDVARCHAR
APP_EVENT_SCHEMAVARCHAR
APP_EVENT_IDVARCHAR
CONTROL_IDVARCHAR
CONTROL_SCHEMAVARCHAR
TRIGGER_IDVARCHAR
PROFILE_IDVARCHAR
EVENT_SOURCE_IDVARCHAR
ACTION_PARENT_PATHVARCHAR
ACTION_PARENT_SCHEMAVARCHAR
ACTION_PATHVARCHAR
ACTION_SCHEMAVARCHAR
CONNECTION_IDVARCHAR
EVENT_SOURCE_NAMEVARCHAR
EVENT_SOURCE_PARENT_IDVARCHAR
EVENT_HANDLER_IDVARCHAR
EVENT_HANDLER_SCHEMAVARCHAR
EVENT_SOURCE_INPUTVARCHAR

Session Funnel History

Data generated by defined Funnels.

PropertyData Type
ORGANIZATION_IDVARCHAR
SESSION_IDVARCHAR
FUNNEL_KEYVARCHAR
FUNNEL_STAGEVARCHAR
SELECTOR_KEYVARCHAR
SESSION_YEARNUMBER
SESSION_MONTHDATE
SESSION_DATEDATE
SESSION_TIMETIMESTAMPNTZ
VISITED_TIMETIMESTAMPNTZ
VISITED_EVENT_IDVARCHAR
APP_IDVARCHAR
BRANCH_IDVARCHAR
DEPTH_INTO_FUNNELNUMBER
FUNNEL_STAGE_STATUSVARCHAR
IS_MATCHEDBOOLEAN
DURATION_HOURSNUMBER
DURATION_MINUTESNUMBER
DURATION_SECONDSNUMBER
DURATION_MILLISNUMBER
LAST_UPDATED_TIMETIMESTAMPNTZ

Session Summary

Data summarizing individual Journeys taken by users through all applications.

PropertyData Type
ORGANIZATION_IDVARCHAR
SESSION_IDVARCHAR
APP_IDVARCHAR
DEPLOY_IDVARCHAR
BRANCH_IDVARCHAR
SAVEPOINT_REVISIONNUMBER
SESSION_YEARNUMBER
SESSION_MONTHDATE
SESSION_DATEDATE
SESSION_TIMETIMESTAMPNTZ
FIRST_EVENT_TIMETIMESTAMPNTZ
FIRST_EVENT_IDVARCHAR
LAST_EVENT_TIMETIMESTAMPNTZ
LAST_EVENT_IDVARCHAR
START_EVENT_TIMETIMESTAMPNTZ
START_EVENT_IDVARCHAR
END_EVENT_TIMETIMESTAMPNTZ
END_EVENT_IDVARCHAR
ACTIONS_FIREDNUMBER
EVENTS_OCCURREDNUMBER
ERRORS_THROWNNUMBER
CONNECTIONS_RUNNUMBER
TRIGGERS_REGISTEREDNUMBER
TRIGGERS_EXPIREDNUMBER
TRIGGERS_INVOKEDNUMBER
VOICE_DURATION_HOURSNUMBER
VOICE_DURATION_MINUTESNUMBER
VOICE_DURATION_SECONDSNUMBER
VOICE_DURATION_MILLISNUMBER
MESSAGES_SENTNUMBER
MESSAGES_RECEIVEDNUMBER
VOICE_SENTNUMBER
VOICE_RECEIVEDNUMBER
ACTION_RUNSNUMBER
ACTION_ERRORSNUMBER
RUNTIME_ERRORSNUMBER
CANVAS_LINK_OPENNUMBER
MESSAGES_DELIVEREDNUMBER
MESSAGES_DELIVERY_FAILURESNUMBER
SOCKET_CONNECTIONSNUMBER
SOCKET_DISCONNECTIONSNUMBER
HTTP_SOURCEVARCHAR
BRIDGE_CALL_COMPLETIONSNUMBER
BRIDGE_CALL_DURATION_HOURSNUMBER
BRIDGE_CALL_DURATION_MINUTESNUMBER
BRIDGE_CALL_DURATION_SECONDSNUMBER
BRIDGE_CALL_DURATION_MILLISNUMBER
CALL_COMPLETIONSNUMBER
CALL_DURATION_HOURSNUMBER
CALL_DURATION_MINUTESNUMBER
CALL_DURATION_SECONDSNUMBER
CALL_DURATION_MILLISNUMBER
CXR_VERSIONVARCHAR
USER_AGENTOBJECT
MIN_SCREEN_WIDTHNUMBER
MIN_SCREEN_HEIGHTNUMBER
MAX_SCREE_WIDTHNUMBER
MAX_SCREEN_HEIGHTNUMBER
APPLICATION_ERRORSNUMBER
PLATFORM_ERRORSNUMBER
MESSAGES_PENDINGNUMBER
EXTERNAL_IDENTIFIERSARRAY
BUILTIN_METRICSOBJECT
CUSTOM_METRICSOBJECT
DEFAULT_METRICSOBJECT
SELECTOR_METRICSOBJECT

Session Trigger

Data pertaining to when and how Journeys are triggered.

PropertyData Type
ORGANIZATION_IDVARCHAR
TRIGGER_IDVARCHAR
TRIGGER_KEYVARCHAR
DISPLAY_NAMEVARCHAR
CREATED_YEARNUMBER
CREATED_MONTHDATE
CREATED_DATEDATE
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
EXECUTION_TIMETIMESTAMPNTZ
PROCESSED_TIMETIMESTAMPNTZ
TRIGGER_TYPEVARCHAR
CALENDAR_RESTRICTIONVARCHAR
LAUNCH_BEHAVIORVARCHAR
CXR_VERSIONVARCHAR
DEPLOY_IDVARCHAR
SESSION_IDVARCHAR
ACTIVITY_GROUP_IDVARCHAR
CHANNEL_IDVARCHAR
EVENT_SOURCE_IDVARCHAR
URL_IDENTIFIER_IDVARCHAR
SHORT_IDVARCHAR
SECURE_IDVARCHAR
URLVARCHAR

Trigger Resource

Basic data regarding the resources that trigger the start of Journeys.

PropertyData Type
ORGANIZATION_IDVARCHAR
TRIGGER_RESOURCE_IDVARCHAR
TRIGGER_IDVARCHAR
RESOURCE_IDVARCHAR
DISPLAY_NAMEVARCHAR
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ

User

Basic data pertaining to individual Builders.

PropertyData Type
ORGANIZATION_IDVARCHAR
USER_IDVARCHAR
DISPLAY_NAMEVARCHAR
EMAILVARCHAR
EMAIL_VERIFIEDBOOLEAN
USERNAMEVARCHAR
CREATED_YEARNUMBER
CREATED_MONTHDATE
CREATED_DATEDATE
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
VARIABLESVARIANT
MULTIFACTORBOOLEAN
PHONE_NUMERVARIANT
FIRST_NAMEVARCHAR
LAST_NAMEVARCHAR

White Label

Basic data pertaining to a White Label Account.

PropertyData Type
ORGANIZATION_IDVARCHAR
WHITE_LABEL_IDVARCHAR
DISPLAY_NAMEVARCHAR
CREATED_YEARNUMBER
CREATED_MONTHDATE
CREATED_DATEDATE
CREATED_TIMETIMESTAMPNTZ
MODIFIED_TIMETIMESTAMPNTZ
FROM_EMAILVARCHAR
FROM_PERSONVARCHAR

Did this page help you?