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 [e-mail].

Views and Properties

Collected data is structured into various views, 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 underlying source table. We expose this data set through Snowflake secure views.

Adapter

Data pertaining to external integrations and how they are authenticated.

Property	Data Type
ORGANIZATION_ID	VARCHAR
ADAPTER_ID	VARCHAR
CREDENTIAL_TYPE	VARCHAR
ADAPTER_KEY	VARCHAR
DISPLAY_NAME	VARCHAR
DESCRIPTION	VARCHAR
CREATED_YEAR	NUMBER
CREATED_MONTH	DATE
CREATED_DATE	DATE
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
AUTH_PARAM_TYPE	VARCHAR
AUTH_PARAM_NAME	VARCHAR
ACCESS_TOKEN_VERB	VARCHAR
AUTH_GRANT_TYPE	VARCHAR
CAPABILITIES	OBJECT

App

Basic data regarding each application.

Property	Data Type	Description
ORGANIZATION_ID	VARCHAR	Unique identifier of the Organization the app was built in.
APP_ID	VARCHAR	Unique identifier of the application.
DISPLAY_NAME	VARCHAR	Application name, as defined when examining the app in the Console.
DESCRIPTION	VARCHAR	Application description, as defined when examining the app in the Console.
CREATED_YEAR	NUMBER	Year the application was created.
CREATED_MONTH	DATE	Month the application was created.
CREATED_DATE	DATE	Date the application was created.
CREATED_TIME	TIMESTAMPNTZ	Time the application was created.
MODIFIED_TIME	TIMESTAMPNTZ	Time the application was last modified.

App Subscription

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

Property	Data Type
ORGANIZATION_ID	VARCHAR
APP_SUBSCRIPTION_ID	VARCHAR
DISPLAY_NAME	VARCHAR
CREATED_YEAR	NUMBER
CREATED_MONTH	DATE
CREATED_DATE	DATE
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
DEPLOYMENT_ID	VARCHAR
DATA_SOURCE_ID	VARCHAR
EVENT_SOURCE_ID	VARCHAR
WEBHOOK_CATEGORY_KEY	VARCHAR
WEBHOOK_IDENTIFIER	VARCHAR
WEBHOOK_EVENT_SOURCE	OBJECT
PROPERTIES	OBJECT

Asset

Data on Assets used in or downloaded by applications.

Property	Data Type
ORGANIZATION_ID	VARCHAR
ASSET_ID	VARCHAR
ASSET_KEY	VARCHAR
ASSET_VERSION	NUMBER
DISPLAY_NAME	VARCHAR
CONTENT_TYPE	VARCHAR
CONTENT_SIZE	NUMBER
EXPIRATION_TIME_HOURS	NUMBER
EXPIRATION_TIME_MINUTES	NUMBER
EXPIRATION_TIME_SECONDS	NUMBER
EXPIRATION_TIME_MILLIS	NUMBER
VISIBILITY	VARCHAR
STATE	VARCHAR
SCOPE	VARCHAR
REGION	VARCHAR
CREATED_YEAR	NUMBER
CREATED_MONTH	DATE
CREATED_DATE	DATE
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
VALIDATION_ERRORS	VARCHAR
EXTRA_INFO	OBJECT

Audit Event

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

Property	Data Type
ORGANIZATION_ID	VARCHAR
EVENT_ID	VARCHAR
EVENT_YEAR	NUMBER
EVENT_MONTH	DATE
EVENT_DATE	DATE
EVENT_TIME	TIMESTAMPNTZ
ROOT_SCOPE_USER_ID	VARCHAR
USER_ID	VARCHAR
EMAIL	VARCHAR
APP_ID	VARCHAR
BRANCH_ID	VARCHAR
DEPLOY_ID	VARCHAR
SAVEPOINT_ID	VARCHAR
SAVEPOINT_REVISION	NUMBER
RESOURCE_TYPE	VARCHAR
RESOURCE_ID	VARCHAR
DOMAIN	VARCHAR
DATASTORE_ID	VARCHAR
API_KEY_ID	VARCHAR
NOTIFIER_ID	VARCHAR
SAML_ID	VARCHAR
WEBHOOK_ID	VARCHAR
ADAPTER_ID	VARCHAR
EMBED_ID	VARCHAR
ROLE_ID	VARCHAR
SERVICE	VARCHAR
SERVICE_REVISION	VARCHAR
LOGIN_TYPE	VARCHAR
EVENT_TYPE	VARCHAR (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
data_encrypt
data_decrypt
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.

Property	Data Type
ORGANIZATION_ID	VARCHAR	Unique identifier of the Organization the app was built in.
BRANCH_ID	VARCHAR	Unique identifier of the application branch.
APP_ID	VARCHAR	Unique identifier of the application.
DISPLAY_NAME	VARCHAR	Unique name of branch. A name is automatically generated upon the creation of each branch, and can be edited in the Console.
SOURCE_BRANCH_ID	VARCHAR	Unique identifier of the source branch.
SOURCE_BRANCH_REVISION	NUMBER	Number of revisions from source branch. Count starts with source branch at 0.
DESCRIPTION	VARCHAR	Description of branch. A basic description is automatically generated upon the creation of each branch, and can be edited in the Console.
CREATED_YEAR	NUMBER	Year the branch was created.
CREATED_MONTH	DATE	Month the branch was created.
CREATED_DATE	DATE	Date the branch was created.
CREATED_TIME	TIMESTAMPNTZ	Time the branch was created.
MODIFIED_TIME	TIMESTAMPNTZ	Time the branch was last modified.
LOCK_TIME	TIMESTAMPNTZ	Time branch was locked, if applicable. Note that only locked branches can be deployed.
USER_ID	VARCHAR	Unique ID of the builder who created the branch.
FROZEN	BOOLEAN	Whether 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.

Property	Data Type
ORGANIZATION_ID	VARCHAR
CUSTOM_METRIC_KEY	VARCHAR
FIRST_SEEN_TIME	TIMESTAMPNTZ
LAST_SEEN_TIME	TIMESTAMPNTZ
COUNT_FIRST_SEEN_TIME	TIMESTAMPNTZ
COUNT_LAST_SEEN_TIME	TIMESTAMPNTZ
STATISTIC_FIRST_SEEN_TIME	TIMESTAMPNTZ
STATISTIC_LAST_SEEN_TIME	TIMESTAMPNTZ
FIELD_FIRST_SEEN_TIME	TIMESTAMPNTZ
FIELD_LAST_SEEN_TIME	TIMESTAMPNTZ

Custom Metric Field

Basic data on which Custom Metrics have occurred.

Property	Data Type
ORGANIZATION_ID	VARCHAR
CUSTOM_METRIC_KEY	VARCHAR
FIELD_VALUE	VARCHAR
FIRST_SEEN_TIME	TIMESTAMPNTZ
LAST_SEEN_TIME	TIMESTAMPNTZ

Custom Metric Field Event

Data pertaining to the instance and value of Custom Metrics.

Property	Data Type
ORGANIZATION_ID	VARCHAR
SESSION_ID	VARCHAR
EVENT_YEAR	NUMBER
EVENT_MONTH	DATE
EVENT_DATE	DATE
EVENT_TIME	TIMESTAMPNTZ
CUSTOM_METRIC_KEY	VARCHAR
FIELD_VALUE	VARCHAR
APP_ID	VARCHAR
DEPLOY_ID	VARCHAR
BRANCH_ID	VARCHAR
EVENT_ID	VARCHAR

Custom Metric Info

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

Property	Data Type
ORGANIZATION_ID	VARCHAR
CUSTOM_METRIC_ID	VARCHAR
APP_ID	VARCHAR
BRANCH_ID	VARCHAR
FIRST_SEEN_TIME	TIMESTAMPNTZ
LAST_SEEN_TIME	TIMESTAMPNTZ
COUNT_FIRST_SEEN_TIME	TIMESTAMPNTZ
COUNT_LAST_SEEN_TIME	TIMESTAMPNTZ
STATISTIC_FIRST_SEEN_TIME	TIMESTAMPNTZ
STATISTIC_FIRST_SEEN_TIME	TIMESTAMPNTZ
FIELD_FIRST_SEEN_TIME	TIMESTAMPNTZ
FIELD_LAST_SEEN_TIME	TIMESTAMPNTZ

Custom Session Metric

Data summarizing the details of Custom Metrics.

Property	Data Type
ORGANIZATION_ID	VARCHAR
SESSION_ID	VARCHAR
CUSTOM_METRIC_KEY	VARCHAR
SESSION_YEAR	NUMBER
SESSION_MONTH	DATE
SESSION_DATE	DATE
SESSION_TIME	TIMESTAMPNTZ
FIRST_TIMESTAMP	TIMESTAMPNTZ
LAST_TIMESTAMP	TIMESTAMPNTZ
APP_ID	VARCHAR
DEPLOY_ID	VARCHAR
BRANCH_ID	VARCHAR
SAVEPOINT_REVISION	NUMBER
COUNT_COUNT	NUMBER
COUNT_FIRST_TIMESTAMP	TIMESTAMPNTZ
COUNT_LAST_TIMESTAMP	TIMESTAMPNTZ
STATISTIC_COUNT	NUMBER
STATISTIC_SUM	NUMBER
STATISTIC_MINIMUM	NUMBER
STATISTIC_MAXIMUM	NUMBER
STATISTIC_FIRST	NUMBER
STATISTIC_LAST	NUMBER
STATISTIC_FIRST_TIMESTAMP	TIMESTAMPNTZ
STATISTIC_LAST_TIMESTAMP	TIMESTAMPNTZ
FIELD_COUNT	NUMBER
FIELD_FIRST	VARCHAR
FIELD_LAST	VARCHAR
FIELD_FIRST_TIMESTAMP	TIMESTAMPNTZ
FIELD_LAST_TIMESTAMP	TIMESTAMPNTZ

Datastore

Basic information regarding each Datastore.

Property	Data Type
ORGANIZATION_ID	VARCHAR
DATASTORE_ID	VARCHAR
DISPLAY_NAME	VARCHAR
APP_ID	VARCHAR
DEFAULT_TYPE	VARCHAR
CREATED_YEAR	NUMBER
CREATED_MONTH	DATE
CREATED_DATE	DATE
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
DESCRIPTION	VARCHAR
ENVIRONMENT_KEY	VARCHAR

Deployment

Basic data regarding application deployment.

Property	Data Type
ORGANIZATION_ID	VARCHAR
DEPLOYMENT_ID	VARCHAR
DEPLOYMENT_KEY	VARCHAR
DISPLAY_NAME	VARCHAR
CREATED_YEAR	NUMBER
CREATED_MONTH	DATE
CREATED_DATE	DATE
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
APP_ID	VARCHAR
BRANCH_ID	VARCHAR
USER_ID	VARCHAR
PROFILE_ID	VARCHAR
CXR_VERSION	VARCHAR
DESCRIPTION	VARCHAR
RESOURCE_BINDINGS	OBJECT
VARIABLES	OBJECT
NOTIFICATIONS	OBJECT
SHOW_PORTALS	BOOLEAN
PORTAL_NAME	VARCHAR
RUN_PERIODIC_TASK	BOOLEAN
ENVIRONMENT_KEY	VARCHAR
DELETED_TIME	TIMESTAMPNTZ

Funnel

Basic information on any Funnels that have been defined.

Property	Data Type
ORGANIZATION_ID	VARCHAR
SELECTOR_KEY	VARCHAR
FUNNEL_KEY	VARCHAR
FUNNEL_NAME	VARCHAR
FUNNEL_DESCRIPTION	VARCHAR
SELECTOR_NAME	VARCHAR
SELECTOR_DESCRIPTION	VARCHAR

Funnel Definition

Detailed information on how Funnels have been defined.

Property	Data Type
ORGANIZATION_ID	VARCHAR
FUNNEL_ID	VARCHAR
FUNNEL_STAGE_KEY	VARCHAR
DISPLAY_NAME	VARCHAR
DESCRIPTION	VARCHAR
FUNNEL_STEP	NUMBER
FUNNEL_NAME	VARCHAR
SELECTOR_KEY	VARCHAR
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
SELECTOR_FILTERS	VARIANT

Invite

Data regarding sent invites to join an Organization.

Property	Data Type
ORGANIZATION_ID	VARCHAR
INVITE_ID	VARCHAR
DISPLAY_NAME	VARCHAR
EMAIL	VARCHAR
STATUS	VARCHAR
CREATED_YEAR	NUMBER
CREATED_MONTH	DATE
CREATED_DATE	DATE
CREATED_TIME	TIMESTAMPNTZ
SENT_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
USERNAME	VARCHAR
VARIABLES	VARIANT
URL	VARCHAR
ROLES	VARIANT
MULTIFACTOR	BOOLEAN
SSO_ONLY	BOOLEAN
FIRST_NAME	VARCHAR
LAST_NAME	VARCHAR

Metric Selector

Data defined by and generated from combing other metrics.

Property	Data Type
ORGANIZATION_ID	VARCHAR
SELECTOR_KEY	VARCHAR
DISPLAY_NAME	VARCHAR
STATUS	VARCHAR
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
DESCRIPTION	VARCHAR
STATUS_MESSAGE	VARCHAR
APP_ID	VARCHAR
BRANCH_ID	VARCHAR

Organization

Basic data pertaining to an Organization.

Property	Data Type
ORGANIZATION_ID	VARCHAR
DISPLAY_NAME	VARCHAR
ORGANIZATION_KEY	VARCHAR
REALM	VARCHAR
WHITE_LABEL_ID	VARCHAR
CREATED_YEAR	NUMBER
CREATED_MONTH	DATE
CREATED_DATE	DATE
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
SAML_METADATA_ID	VARCHAR
LICENSE_KEY	VARCHAR
ORGANIZATION_TYPE	VARCHAR

Platform Event

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

Property	Data Type
ORGANIZATION_ID	VARCHAR
EVENT_YEAR	NUMBER
EVENT_MONTH	DATE
EVENT_DATE	DATE
EVENT_TIME	TIMESTAMPNTZ
EVENT_ID	VARCHAR
APP_ID	VARCHAR
BRANCH_ID	VARCHAR
SAVEPOINT_REVISION	NUMBER
DEPLOY_ID	VARCHAR
EVENT_TYPE	VARCHAR
STATUS	VARCHAR
MESSAGE	VARCHAR
SERVICE	VARCHAR
SERVICE_VERSION	VARCHAR
CXR_VERSION	VARCHAR
CONNECTION_ID	VARCHAR
GROUP_ID	VARCHAR
DURATION_MILLIS	NUMBER

Resource

Data pertaining to external resources used within applications.

Property	Data Type
ORGANIZATION_ID	VARCHAR
RESOURCE_ID	VARCHAR
DISPLAY_NAME	VARCHAR
CREATED_YEAR	NUMBER
CREATED_MONTH	DATE
CREATED_DATE	DATE
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
REMOTE_TYPE	VARCHAR
REMOTE_ID	VARCHAR
DATA_SOURCE_ID	VARCHAR
CREDENTIAL_ID	VARCHAR
DOMAIN_ID	VARCHAR
URL_IDENTIFIER_ID	VARCHAR
PARENT_ID	VARCHAR
FROM_ADDRESS	VARCHAR
CAPABILITIES	OBJECT
ENVIRONMENT_KEY	VARCHAR
EMAIL_ADDRESS	VARCHAR

Resource Deployment

Data pertaining to how resources were deployed.

Property	Data Type
ORGANIZATION_ID	VARCHAR
RESOURCE_DEPLOYMENT_ID	VARCHAR
RESOURCE_ID	VARCHAR
DEPLOYMENT_ID	VARCHAR
CREATED_YEAR	NUMBER
CREATED_MONTH	DATE
CREATED_DATE	DATE
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ

Role

Data regarding roles with an Organization. Custom roles and the default user roles are included in this data set.

Property	Data Type
ORGANIZATION_ID	VARCHAR
ROLE_ID	VARCHAR
POLICY	VARCHAR
DISPLAY_NAME	VARCHAR
DESCRIPTION	VARCHAR
CREATED_YEAR	NUMBER
CREATED_MONTH	DATE
CREATED_DATE	DATE
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
ROLE_RANK	VARCHAR
ROLE_KEY	VARCHAR

Session Event

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

Property	Data Type
ORGANIZATION_ID	VARCHAR
EVENT_YEAR	NUMBER
EVENT_MONTH	DATE
EVENT_DATE	DATE
EVENT_TIME	TIMESTAMPNTZ
EVENT_ID	VARCHAR
APP_ID	VARCHAR
BRANCH_ID	VARCHAR
SESSION_ID	VARCHAR
DEPLOY_ID	VARCHAR
EVENT_TYPE	VARCHAR
CUSTOM_METRICS	OBJECT
DEFAULT_METRICS	OBJECT
SAVEPOINT_REVISION	NUMBER
CHANNEL_ID	VARCHAR
CHANNEL_KEY	VARCHAR
FLOW_ID	VARCHAR
ACTIVITY_ID	VARCHAR
ACTOR_ID	VARCHAR
RESOURCE_ID	VARCHAR
ACTIVITY_GROUP_ID	VARCHAR
CLIENT	VARCHAR
USER_AGENT	VARCHAR
SCREEN_WIDTH	NUMBER
SCREEN_HEIGHT	NUMBER
HTTP_SOURCE	VARCHAR
STATUS	VARCHAR
CODE	NUMBER
SERVICE	VARCHAR
SERVICE_VERSION	VARCHAR
EXTERNAL_ID	VARCHAR
DURATION_MILLIS	NUMBER
CXR_VERSION	VARCHAR
SOURCE_RUNTIME	VARCHAR
SOURCE_DETAIL	VARCHAR
APP_EVENT_PARENT_SCHEMA	VARCHAR
APP_EVENT_PARENT_ID	VARCHAR
APP_EVENT_SCHEMA	VARCHAR
APP_EVENT_ID	VARCHAR
CONTROL_ID	VARCHAR
CONTROL_SCHEMA	VARCHAR
TRIGGER_ID	VARCHAR
PROFILE_ID	VARCHAR
EVENT_SOURCE_ID	VARCHAR
ACTION_PARENT_PATH	VARCHAR
ACTION_PARENT_SCHEMA	VARCHAR
ACTION_PATH	VARCHAR
ACTION_SCHEMA	VARCHAR
CONNECTION_ID	VARCHAR
EVENT_SOURCE_NAME	VARCHAR
EVENT_SOURCE_PARENT_ID	VARCHAR
EVENT_HANDLER_ID	VARCHAR
EVENT_HANDLER_SCHEMA	VARCHAR
EVENT_SOURCE_INPUT	VARCHAR

Session Funnel History

Data generated by defined Funnels.

Property	Data Type
ORGANIZATION_ID	VARCHAR
SESSION_ID	VARCHAR
FUNNEL_KEY	VARCHAR
FUNNEL_STAGE	VARCHAR
SELECTOR_KEY	VARCHAR
SESSION_YEAR	NUMBER
SESSION_MONTH	DATE
SESSION_DATE	DATE
SESSION_TIME	TIMESTAMPNTZ
VISITED_TIME	TIMESTAMPNTZ
VISITED_EVENT_ID	VARCHAR
APP_ID	VARCHAR
BRANCH_ID	VARCHAR
DEPTH_INTO_FUNNEL	NUMBER
FUNNEL_STAGE_STATUS	VARCHAR
IS_MATCHED	BOOLEAN
DURATION_HOURS	NUMBER
DURATION_MINUTES	NUMBER
DURATION_SECONDS	NUMBER
DURATION_MILLIS	NUMBER
LAST_UPDATED_TIME	TIMESTAMPNTZ

Session Summary

Data summarizing individual Journeys taken by users through all applications.

Property	Data Type
ORGANIZATION_ID	VARCHAR
SESSION_ID	VARCHAR
APP_ID	VARCHAR
DEPLOY_ID	VARCHAR
BRANCH_ID	VARCHAR
SAVEPOINT_REVISION	NUMBER
SESSION_YEAR	NUMBER
SESSION_MONTH	DATE
SESSION_DATE	DATE
SESSION_TIME	TIMESTAMPNTZ
FIRST_EVENT_TIME	TIMESTAMPNTZ
FIRST_EVENT_ID	VARCHAR
LAST_EVENT_TIME	TIMESTAMPNTZ
LAST_EVENT_ID	VARCHAR
START_EVENT_TIME	TIMESTAMPNTZ
START_EVENT_ID	VARCHAR
END_EVENT_TIME	TIMESTAMPNTZ
END_EVENT_ID	VARCHAR
ACTIONS_FIRED	NUMBER
EVENTS_OCCURRED	NUMBER
ERRORS_THROWN	NUMBER
CONNECTIONS_RUN	NUMBER
TRIGGERS_REGISTERED	NUMBER
TRIGGERS_EXPIRED	NUMBER
TRIGGERS_INVOKED	NUMBER
VOICE_DURATION_HOURS	NUMBER
VOICE_DURATION_MINUTES	NUMBER
VOICE_DURATION_SECONDS	NUMBER
VOICE_DURATION_MILLIS	NUMBER
MESSAGES_SENT	NUMBER
MESSAGES_RECEIVED	NUMBER
VOICE_SENT	NUMBER
VOICE_RECEIVED	NUMBER
ACTION_RUNS	NUMBER
ACTION_ERRORS	NUMBER
RUNTIME_ERRORS	NUMBER
CANVAS_LINK_OPEN	NUMBER
MESSAGES_DELIVERED	NUMBER
MESSAGES_DELIVERY_FAILURES	NUMBER
SOCKET_CONNECTIONS	NUMBER
SOCKET_DISCONNECTIONS	NUMBER
HTTP_SOURCE	VARCHAR
BRIDGE_CALL_COMPLETIONS	NUMBER
BRIDGE_CALL_DURATION_HOURS	NUMBER
BRIDGE_CALL_DURATION_MINUTES	NUMBER
BRIDGE_CALL_DURATION_SECONDS	NUMBER
BRIDGE_CALL_DURATION_MILLIS	NUMBER
CALL_COMPLETIONS	NUMBER
CALL_DURATION_HOURS	NUMBER
CALL_DURATION_MINUTES	NUMBER
CALL_DURATION_SECONDS	NUMBER
CALL_DURATION_MILLIS	NUMBER
CXR_VERSION	VARCHAR
USER_AGENT	OBJECT
MIN_SCREEN_WIDTH	NUMBER
MIN_SCREEN_HEIGHT	NUMBER
MAX_SCREE_WIDTH	NUMBER
MAX_SCREEN_HEIGHT	NUMBER
APPLICATION_ERRORS	NUMBER
PLATFORM_ERRORS	NUMBER
MESSAGES_PENDING	NUMBER
EXTERNAL_IDENTIFIERS	ARRAY
BUILTIN_METRICS	OBJECT
CUSTOM_METRICS	OBJECT
DEFAULT_METRICS	OBJECT
SELECTOR_METRICS	OBJECT

Session Trigger

Data pertaining to when and how Journeys are triggered.

Property	Data Type
ORGANIZATION_ID	VARCHAR
TRIGGER_ID	VARCHAR
TRIGGER_KEY	VARCHAR
DISPLAY_NAME	VARCHAR
CREATED_YEAR	NUMBER
CREATED_MONTH	DATE
CREATED_DATE	DATE
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
EXECUTION_TIME	TIMESTAMPNTZ
PROCESSED_TIME	TIMESTAMPNTZ
TRIGGER_TYPE	VARCHAR
CALENDAR_RESTRICTION	VARCHAR
LAUNCH_BEHAVIOR	VARCHAR
CXR_VERSION	VARCHAR
DEPLOY_ID	VARCHAR
SESSION_ID	VARCHAR
ACTIVITY_GROUP_ID	VARCHAR
CHANNEL_ID	VARCHAR
EVENT_SOURCE_ID	VARCHAR
URL_IDENTIFIER_ID	VARCHAR
SHORT_ID	VARCHAR
SECURE_ID	VARCHAR
URL	VARCHAR

Trigger Resource

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

Property	Data Type
ORGANIZATION_ID	VARCHAR
TRIGGER_RESOURCE_ID	VARCHAR
TRIGGER_ID	VARCHAR
RESOURCE_ID	VARCHAR
DISPLAY_NAME	VARCHAR
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ

User

Basic data pertaining to individual Builders.

Property	Data Type	Description
ORGANIZATION_ID	VARCHAR
USER_ID	VARCHAR
DISPLAY_NAME	VARCHAR
EMAIL	VARCHAR
EMAIL_VERIFIED	BOOLEAN
USERNAME	VARCHAR
CREATED_YEAR	NUMBER
CREATED_MONTH	DATE
CREATED_DATE	DATE
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
DELETED_TIME	TIMESTAMPNTZ
VARIABLES	VARIANT
MULTIFACTOR	BOOLEAN
PHONE_NUMER	VARIANT
FIRST_NAME	VARCHAR
LAST_NAME	VARCHAR
ACTIVITY_STATUS	VARCHAR	Status of the user. Either "ACTIVE" or "INACTIVE"

White Label

Basic data pertaining to a White Label Account.

Property	Data Type
ORGANIZATION_ID	VARCHAR
WHITE_LABEL_ID	VARCHAR
DISPLAY_NAME	VARCHAR
CREATED_YEAR	NUMBER
CREATED_MONTH	DATE
CREATED_DATE	DATE
CREATED_TIME	TIMESTAMPNTZ
MODIFIED_TIME	TIMESTAMPNTZ
FROM_EMAIL	VARCHAR
FROM_PERSON	VARCHAR