# 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 [support@airkit.com](mailto:support@airkit.com).

## 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](../administration/airkit-organizations) 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](../console/console).             |
| DESCRIPTION          | VARCHAR      | Application description, as defined when examining the app in the [Console](../console/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              |
| 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.

<details>

<summary>How are application branches created and defined?</summary>

\


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.

</details>

| Property                 | Data Type    |                                                                                                                                                                      |
| ------------------------ | ------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **ORGANIZATION\_ID**     | VARCHAR      | Unique identifier of the [Organization](../administration/airkit-organizations) 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](../console/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](../console/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      |

### 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](../administration/user-roles/working-with-custom-roles) and the [default user roles](../administration/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      |
