# Pendo
Pendo is a SaaS platform that helps businesses improve product adoption, usage, and satisfaction by providing in-app guidance, communications, and analytics. You can use Pendo as a data source when landing or replicating data.
See the [Schema](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#Schema) section for a list of objects available for replication.
## Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
Information noteMake sure that the account you use has read access to the tables you want to fetch.
To generate an integration key:
1. Make sure you have the Admin privileges in Pendo. You need them to create an integration key.
2. Log into your Pendo account as a user with Admin privileges.
3. Go tp Settings > Integrations > Integration Keys.
4. Click + Add Integration Key.
5. In Description field of the window that displays, enter a description. For example: `Qlik`.
6. Click Create.The integration key will display in the Key column:
7. Copy the key.
## Creating the connection
For more information, see [Connecting to SaaS applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Landing/connecting-web-applications.htm).
1. Fill in the required connection properties.
2. Provide a name for the connection in Connection name.
3. Select Open connection metadata to define metadata for the connection when it has been created.
4. Click Create.
Connection settings
| Setting | Description |
| --- | --- |
| Data gateway | Select a Data Movement gateway if required by your use case.
Information note
This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.
For information on the benefits of Data Movement gateway and use cases that require it, see [Qlik Data Gateway - Data Movement](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/replication-gateway.htm). |
| Start Date | Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target. |
| Period | Select the period from the drop-down list:
- Days: Data will be aggregated by day.
- Hours: Data will be aggregated by hour.
|
| X Pendo Integration Key | Pendo integration key. |
| App IDs | App IDs separated by a comma. Example: `1122, 2345`. |
| Include Anonymous Visitors | Select the check box if needed. This lets you collect data from visitors that have no assigned Visitor ID and counts toward your total monthly active users. |
## Schema
Information note
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
Depending on your destination, table and column names may not appear as they are outlined below.
### accounts
The `accounts` table contains info about your customer accounts in Pendo.
| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | account\_id |
| **Replication Key** | lastupdated |
| **Useful links** | [Pendo documentation](https://engageapi.pendo.io/#12dd758f-1578-4eba-894c-0d6ea64f600a)
[Pendo API method](https://engageapi.pendo.io/#7c8479b8-3843-403c-94a9-04cbdf542db9 "Opens in new tab: Pendo API method") |
accounts table foreign keys
| Join accounts with | on |
| --- | --- |
| [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#events) | ```
accounts.account_id = events.account_id
``` |
| [feature_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#feature-events) | ```
accounts.account_id = feature_events.account_id
``` |
| [guide_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guide-events) | ```
accounts.account_id = guide_events.account_id
```
```
accounts.account_id = guide_events.account_ids
``` |
| [page_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#page-events) | ```
accounts.account_id = page_events.account_id
``` |
| [poll_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#poll-events) | ```
accounts.account_id = poll_events.account_id
```
```
accounts.account_id = poll_events.account_ids
``` |
| [track_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-events) | ```
accounts.account_id = track_events.account_id
``` |
| [visitors](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitors) | ```
accounts.account_id = visitors.metadata_auto.accountid
```
```
accounts.account_id = visitors.metadata_auto.accountids
``` |
accounts table schema
| **account\_id**
STRING |
| --- |
| **lastupdated**
DATE-TIME |
| **metadata\_auto**
OBJECT
This is a nested data structure:
- firstvisit: DATE-TIME
- id: STRING
- idhash: INTEGER
- lastupdated: DATE-TIME
- lastvisit: DATE-TIME
|
| **metadata\_custom**
OBJECT |
### events
The `events` table contains info about events recorded in your Pendo account.
**Note**: The **Period** setting you define during setup determine how this table is replicated, including the field used as a Replication Key. Refer to the [Replication section](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#event-replication) for more info.
| **Replication Method** | CDC |
| --- | --- |
| **Primary Keys** | account\_id
server
remote\_ip |
| **Useful links** | [Pendo documentation](https://engageapi.pendo.io/#3d10cfdb-c4b3-4a9c-8d67-dc250cab82ab)
[Pendo API method](https://engageapi.pendo.io/#7c8479b8-3843-403c-94a9-04cbdf542db9 "Opens in new tab: Pendo API method") |
events table foreign keys
| Join events with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#accounts) | ```
events.account_id = accounts.account_id
``` |
| [feature_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#feature-events) | ```
events.account_id = feature_events.account_id
```
```
events.app_id = feature_events.app_id
```
```
events.feature_id = feature_events.feature_id
```
```
events.visitor_id = feature_events.visitor_id
``` |
| [guide_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guide-events) | ```
events.account_id = guide_events.account_id
```
```
events.account_id = guide_events.account_ids
```
```
events.app_id = guide_events.app_id
```
```
events.visitor_id = guide_events.visitor_id
``` |
| [page_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#page-events) | ```
events.account_id = page_events.account_id
```
```
events.app_id = page_events.app_id
```
```
events.page_id = page_events.page_id
```
```
events.visitor_id = page_events.visitor_id
``` |
| [poll_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#poll-events) | ```
events.account_id = poll_events.account_id
```
```
events.account_id = poll_events.account_ids
```
```
events.visitor_id = poll_events.visitor_id
``` |
| [track_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-events) | ```
events.account_id = track_events.account_id
```
```
events.app_id = track_events.app_id
```
```
events.visitor_id = track_events.visitor_id
``` |
| [visitors](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitors) | ```
events.account_id = visitors.metadata_auto.accountid
```
```
events.account_id = visitors.metadata_auto.accountids
```
```
events.visitor_id = visitors.visitor_id
``` |
| [features](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#features) | ```
events.app_id = features.created_by_user.app_id
```
```
events.feature_id = features.id
```
```
events.page_id = features.page_id
``` |
| [visitor_history](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitor-history) | ```
events.app_id = visitor_history.app_id
```
```
events.feature_id = visitor_history.feature_id
```
```
events.page_id = visitor_history.page_id
```
```
events.visitor_id = visitor_history.visitor_id
``` |
| [guides](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guides) | ```
events.page_id = guides.steps.page_id
```
```
events.visitor_id = guides.audience.select.visitor_id
``` |
| [pages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#pages) | ```
events.page_id = pages.id
``` |
events table schema
| **account\_id**
STRING |
| --- |
| **app\_id**
NUMBER |
| **day**
DATE-TIME |
| **feature\_id**
STRING |
| **hour**
DATE-TIME |
| **num\_events**
INTEGER |
| **num\_minutes**
INTEGER |
| **page\_id**
STRING |
| **parameters**
STRING |
| **remote\_ip**
STRING |
| **server**
STRING |
| **user\_agent**
STRING |
| **visitor\_id**
STRING |
### feature\_events
The `feature_events` table contains info about feature events recorded in your Pendo account.
**Note**: The **Period** setting you define during setup determine how this table is replicated, including the field used as a Replication Key. Refer to the [Replication section](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#event-replication) for more info.
| **Replication Method** | CDC |
| --- | --- |
| **Primary Keys** | account\_id
server
remote\_ip
visitor\_id
day
feature\_id
user\_agent |
| **Useful links** | [Pendo documentation](https://engageapi.pendo.io/#3d10cfdb-c4b3-4a9c-8d67-dc250cab82ab)
[Pendo API method](https://engageapi.pendo.io/#7c8479b8-3843-403c-94a9-04cbdf542db9 "Opens in new tab: Pendo API method") |
feature\_events table foreign keys
| Join feature\_events with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#accounts) | ```
feature_events.account_id = accounts.account_id
``` |
| [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#events) | ```
feature_events.account_id = events.account_id
```
```
feature_events.app_id = events.app_id
```
```
feature_events.feature_id = events.feature_id
```
```
feature_events.visitor_id = events.visitor_id
``` |
| [guide_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guide-events) | ```
feature_events.account_id = guide_events.account_id
```
```
feature_events.account_id = guide_events.account_ids
```
```
feature_events.app_id = guide_events.app_id
```
```
feature_events.visitor_id = guide_events.visitor_id
``` |
| [page_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#page-events) | ```
feature_events.account_id = page_events.account_id
```
```
feature_events.app_id = page_events.app_id
```
```
feature_events.visitor_id = page_events.visitor_id
``` |
| [poll_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#poll-events) | ```
feature_events.account_id = poll_events.account_id
```
```
feature_events.account_id = poll_events.account_ids
```
```
feature_events.visitor_id = poll_events.visitor_id
``` |
| [track_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-events) | ```
feature_events.account_id = track_events.account_id
```
```
feature_events.app_id = track_events.app_id
```
```
feature_events.visitor_id = track_events.visitor_id
``` |
| [visitors](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitors) | ```
feature_events.account_id = visitors.metadata_auto.accountid
```
```
feature_events.account_id = visitors.metadata_auto.accountids
```
```
feature_events.visitor_id = visitors.visitor_id
``` |
| [features](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#features) | ```
feature_events.app_id = features.created_by_user.app_id
```
```
feature_events.feature_id = features.id
``` |
| [visitor_history](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitor-history) | ```
feature_events.app_id = visitor_history.app_id
```
```
feature_events.feature_id = visitor_history.feature_id
```
```
feature_events.visitor_id = visitor_history.visitor_id
``` |
| [guides](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guides) | ```
feature_events.visitor_id = guides.audience.select.visitor_id
``` |
feature\_events table schema
| **account\_id**
STRING |
| --- |
| **app\_id**
NUMBER |
| **day**
DATE-TIME |
| **feature\_id**
STRING |
| **hour**
DATE-TIME |
| **num\_events**
INTEGER |
| **num\_minutes**
INTEGER |
| **parameters**
STRING |
| **remote\_ip**
STRING |
| **server**
STRING |
| **user\_agent**
STRING |
| **visitor\_id**
STRING |
### features
The `features` table contains info about app features listed in your Pendo account.
| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | last\_updated\_at |
| **Useful links** | [Pendo documentation](https://engageapi.pendo.io/#b7ba5380-68c7-4c6a-bf17-50159e56a8d8)
[Pendo API method](https://engageapi.pendo.io/#7c8479b8-3843-403c-94a9-04cbdf542db9 "Opens in new tab: Pendo API method") |
features table foreign keys
| Join features with | on |
| --- | --- |
| [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#events) | ```
features.created_by_user.app_id = events.app_id
```
```
features.id = events.feature_id
```
```
features.page_id = events.page_id
``` |
| [feature_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#feature-events) | ```
features.created_by_user.app_id = feature_events.app_id
```
```
features.id = feature_events.feature_id
``` |
| [guide_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guide-events) | ```
features.created_by_user.app_id = guide_events.app_id
``` |
| [page_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#page-events) | ```
features.created_by_user.app_id = page_events.app_id
```
```
features.page_id = page_events.page_id
``` |
| [track_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-events) | ```
features.created_by_user.app_id = track_events.app_id
``` |
| [visitor_history](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitor-history) | ```
features.created_by_user.app_id = visitor_history.app_id
```
```
features.id = visitor_history.feature_id
```
```
features.page_id = visitor_history.page_id
``` |
| [pages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#pages) | ```
features.group.id = pages.group.id
```
```
features.page_id = pages.id
```
```
features.created_by_user.id = pages.created_by_user.id
```
```
features.group.created_by_user.id = pages.created_by_user.id
```
```
features.group.last_updated_by_user.id = pages.created_by_user.id
```
```
features.last_updated_by_user.id = pages.created_by_user.id
```
```
features.created_by_user.id = pages.group.created_by_user.id
```
```
features.group.created_by_user.id = pages.group.created_by_user.id
```
```
features.group.last_updated_by_user.id = pages.group.created_by_user.id
```
```
features.last_updated_by_user.id = pages.group.created_by_user.id
```
```
features.created_by_user.id = pages.group.last_updated_by_user.id
```
```
features.group.created_by_user.id = pages.group.last_updated_by_user.id
```
```
features.group.last_updated_by_user.id = pages.group.last_updated_by_user.id
```
```
features.last_updated_by_user.id = pages.group.last_updated_by_user.id
```
```
features.created_by_user.id = pages.last_updated_by_user.id
```
```
features.group.created_by_user.id = pages.last_updated_by_user.id
```
```
features.group.last_updated_by_user.id = pages.last_updated_by_user.id
```
```
features.last_updated_by_user.id = pages.last_updated_by_user.id
``` |
| [track_types](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-types) | ```
features.group.id = track_types.group.id
```
```
features.created_by_user.id = track_types.created_by_user.id
```
```
features.group.created_by_user.id = track_types.created_by_user.id
```
```
features.group.last_updated_by_user.id = track_types.created_by_user.id
```
```
features.last_updated_by_user.id = track_types.created_by_user.id
```
```
features.created_by_user.id = track_types.last_updated_by_user.id
```
```
features.group.created_by_user.id = track_types.last_updated_by_user.id
```
```
features.group.last_updated_by_user.id = track_types.last_updated_by_user.id
```
```
features.last_updated_by_user.id = track_types.last_updated_by_user.id
``` |
| [guides](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guides) | ```
features.page_id = guides.steps.page_id
```
```
features.created_by_user.id = guides.created_by_user.id
```
```
features.group.created_by_user.id = guides.created_by_user.id
```
```
features.group.last_updated_by_user.id = guides.created_by_user.id
```
```
features.last_updated_by_user.id = guides.created_by_user.id
```
```
features.created_by_user.id = guides.last_updated_by_user.id
```
```
features.group.created_by_user.id = guides.last_updated_by_user.id
```
```
features.group.last_updated_by_user.id = guides.last_updated_by_user.id
```
```
features.last_updated_by_user.id = guides.last_updated_by_user.id
``` |
features table schema
| **app\_id**
NUMBER |
| --- |
| **color**
STRING |
| **created\_at**
DATE-TIME |
| **created\_by\_user**
OBJECT
This is a nested data structure:
- app_id: NUMBER
- app_wide: BOOLEAN
- event_property_configurations: ARRAY, which is also a nested data structure.
- first: STRING
- id: STRING
- is_core_event: BOOLEAN
- last: STRING
- role: INTEGER
- user_type: STRING
- username: STRING
- valid_through: NUMBER
|
| **dirty**
BOOLEAN |
| **element\_path\_rules**
ARRAY |
| **group**
OBJECT
This is a nested data structure:
- color: STRING
- created_at: DATE-TIME
- created_by_user: OBJECT, which is also a nested data structure.
- first: STRING
- id: STRING
- last: STRING
- role: INTEGER
- type: STRING
- username: STRING
- description: STRING
- id: STRING
- last_updated_at: DATE-TIME
- last_updated_by_user: OBJECT, which is also a nested data structure.
- first: STRING
- id: STRING
- last: STRING
- role: INTEGER
- username: STRING
- length: INTEGER
- name: STRING
|
| **id**
STRING |
| **kind**
STRING |
| **last\_updated\_at**
DATE-TIME |
| **last\_updated\_by\_user**
OBJECT
This is a nested data structure:
- first: STRING
- id: STRING
- last: STRING
- role: INTEGER
- type: STRING
- username: STRING
|
| **name**
STRING |
| **page\_id**
STRING |
| **root\_version\_id**
STRING |
| **stable\_version\_id**
STRING |
### guide\_events
The `guide_events` table contains info about guide events recorded in your Pendo account.
**Note**: The **Period** setting you define during setup determine how this table is replicated, including the field used as a Replication Key. Refer to the [Replication section](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#event-replication) for more info.
| **Replication Method** | CDC |
| --- | --- |
| **Primary Keys** | account\_id
browser\_time
guide\_id
guide\_step\_id
remote\_ip
type
url
visitor\_id |
| **Replication Key** | browser\_time |
| **Useful links** | [Pendo documentation](https://engageapi.pendo.io/#3d10cfdb-c4b3-4a9c-8d67-dc250cab82ab)
[Pendo API method](https://engageapi.pendo.io/#7c8479b8-3843-403c-94a9-04cbdf542db9 "Opens in new tab: Pendo API method") |
guide\_events table foreign keys
| Join guide\_events with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#accounts) | ```
guide_events.account_id = accounts.account_id
```
```
guide_events.account_ids = accounts.account_id
``` |
| [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#events) | ```
guide_events.account_id = events.account_id
```
```
guide_events.account_ids = events.account_id
```
```
guide_events.app_id = events.app_id
```
```
guide_events.visitor_id = events.visitor_id
``` |
| [feature_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#feature-events) | ```
guide_events.account_id = feature_events.account_id
```
```
guide_events.account_ids = feature_events.account_id
```
```
guide_events.app_id = feature_events.app_id
```
```
guide_events.visitor_id = feature_events.visitor_id
``` |
| [page_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#page-events) | ```
guide_events.account_id = page_events.account_id
```
```
guide_events.account_ids = page_events.account_id
```
```
guide_events.app_id = page_events.app_id
```
```
guide_events.visitor_id = page_events.visitor_id
``` |
| [poll_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#poll-events) | ```
guide_events.account_id = poll_events.account_id
```
```
guide_events.account_ids = poll_events.account_id
```
```
guide_events.account_id = poll_events.account_ids
```
```
guide_events.account_ids = poll_events.account_ids
```
```
guide_events.guide_id = poll_events.guide_id
```
```
guide_events.poll_id = poll_events.poll_id
```
```
guide_events.visitor_id = poll_events.visitor_id
``` |
| [track_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-events) | ```
guide_events.account_id = track_events.account_id
```
```
guide_events.account_ids = track_events.account_id
```
```
guide_events.app_id = track_events.app_id
```
```
guide_events.visitor_id = track_events.visitor_id
``` |
| [visitors](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitors) | ```
guide_events.account_id = visitors.metadata_auto.accountid
```
```
guide_events.account_ids = visitors.metadata_auto.accountid
```
```
guide_events.account_id = visitors.metadata_auto.accountids
```
```
guide_events.account_ids = visitors.metadata_auto.accountids
```
```
guide_events.visitor_id = visitors.visitor_id
``` |
| [features](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#features) | ```
guide_events.app_id = features.created_by_user.app_id
``` |
| [visitor_history](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitor-history) | ```
guide_events.app_id = visitor_history.app_id
```
```
guide_events.guide_id = visitor_history.guide_id
```
```
guide_events.visitor_id = visitor_history.visitor_id
``` |
| [guides](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guides) | ```
guide_events.guide_id = guides.id
```
```
guide_events.guide_id = guides.steps.guide_id
```
```
guide_events.visitor_id = guides.audience.select.visitor_id
``` |
guide\_events table schema
| **account\_id**
STRING |
| --- |
| **account\_ids**
ARRAY |
| **app\_id**
NUMBER |
| **browser\_time**
DATE-TIME |
| **country**
STRING |
| **guide\_id**
STRING |
| **guide\_step\_id**
STRING |
| **latitude**
NUMBER |
| **load\_time**
INTEGER |
| **longitude**
NUMBER |
| **poll\_id**
STRING |
| **poll\_response**
STRING |
| **region**
STRING |
| **remote\_ip**
STRING |
| **server\_name**
STRING |
| **type**
STRING |
| **url**
STRING |
| **user\_agent**
STRING |
| **visitor\_id**
STRING |
### guides
The `guides` table contains info about the guides in your Pendo account.
| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | last\_updated\_at |
| **Useful links** | [Pendo API method](https://engageapi.pendo.io/#7c8479b8-3843-403c-94a9-04cbdf542db9 "Opens in new tab: Pendo API method") |
guides table foreign keys
| Join guides with | on |
| --- | --- |
| [guide_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guide-events) | ```
guides.id = guide_events.guide_id
```
```
guides.steps.guide_id = guide_events.guide_id
```
```
guides.audience.select.visitor_id = guide_events.visitor_id
``` |
| [poll_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#poll-events) | ```
guides.id = poll_events.guide_id
```
```
guides.steps.guide_id = poll_events.guide_id
```
```
guides.audience.select.visitor_id = poll_events.visitor_id
``` |
| [visitor_history](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitor-history) | ```
guides.id = visitor_history.guide_id
```
```
guides.steps.guide_id = visitor_history.guide_id
```
```
guides.steps.id = visitor_history.guide_id
```
```
guides.steps.page_id = visitor_history.page_id
```
```
guides.audience.select.visitor_id = visitor_history.visitor_id
``` |
| [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#events) | ```
guides.steps.page_id = events.page_id
```
```
guides.audience.select.visitor_id = events.visitor_id
``` |
| [features](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#features) | ```
guides.steps.page_id = features.page_id
```
```
guides.created_by_user.id = features.created_by_user.id
```
```
guides.last_updated_by_user.id = features.created_by_user.id
```
```
guides.created_by_user.id = features.group.created_by_user.id
```
```
guides.last_updated_by_user.id = features.group.created_by_user.id
```
```
guides.created_by_user.id = features.group.last_updated_by_user.id
```
```
guides.last_updated_by_user.id = features.group.last_updated_by_user.id
```
```
guides.created_by_user.id = features.last_updated_by_user.id
```
```
guides.last_updated_by_user.id = features.last_updated_by_user.id
``` |
| [page_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#page-events) | ```
guides.steps.page_id = page_events.page_id
```
```
guides.audience.select.visitor_id = page_events.visitor_id
``` |
| [pages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#pages) | ```
guides.steps.page_id = pages.id
```
```
guides.created_by_user.id = pages.created_by_user.id
```
```
guides.last_updated_by_user.id = pages.created_by_user.id
```
```
guides.created_by_user.id = pages.group.created_by_user.id
```
```
guides.last_updated_by_user.id = pages.group.created_by_user.id
```
```
guides.created_by_user.id = pages.group.last_updated_by_user.id
```
```
guides.last_updated_by_user.id = pages.group.last_updated_by_user.id
```
```
guides.created_by_user.id = pages.last_updated_by_user.id
```
```
guides.last_updated_by_user.id = pages.last_updated_by_user.id
``` |
| [track_types](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-types) | ```
guides.created_by_user.id = track_types.created_by_user.id
```
```
guides.last_updated_by_user.id = track_types.created_by_user.id
```
```
guides.created_by_user.id = track_types.last_updated_by_user.id
```
```
guides.last_updated_by_user.id = track_types.last_updated_by_user.id
``` |
| [feature_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#feature-events) | ```
guides.audience.select.visitor_id = feature_events.visitor_id
``` |
| [track_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-events) | ```
guides.audience.select.visitor_id = track_events.visitor_id
``` |
| [visitors](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitors) | ```
guides.audience.select.visitor_id = visitors.visitor_id
``` |
guides table schema
| **app\_id**
NUMBER |
| --- |
| **attributes**
OBJECT
This is a nested data structure: **badge**, OBJECT, which is alaso a nested data structure.
- can_change_badge_color: BOOLEAN
- color: STRING
- height: INTEGER
- image_url: STRING
- is_only_show_once: BOOLEAN
- name: STRING
- offsets: OBJECT, which is also a nested data structure.
- left: INTEGER
- right: INTEGER
- top: INTEGER
- position: STRING
- show_on_event: STRING
- use_hover: STRING
- width: INTEGER
- device: OBJECT, which is also a nested data structure.
- priority: INTEGER
- type: STRING
|
| **audience**
ARRAY
This is a nested data structure:
- identified: STRING
- select: OBJECT, which is also a nested data structure.
- source: OBJECT, which is also a nested data structure.
|
| **created\_at**
DATE-TIME |
| **created\_by\_user**
OBJECT
This is a nested data structure:
- first: STRING
- id: STRING
- last: STRING
- role: INTEGER
- username: STRING
|
| **id**
STRING |
| **is\_multi\_step**
BOOLEAN |
| **kind**
STRING |
| **last\_updated\_at**
DATE-TIME |
| **last\_updated\_by\_user**
OBJECT
This is a nested data structure:
- first: STRING
- id: STRING
- last: STRING
- role: INTEGER
- username: STRING
|
| **launch\_method**
STRING |
| **name**
STRING |
| **published\_at**
DATE-TIME |
| **reset\_at**
DATE-TIME |
| **root\_version\_id**
STRING |
| **stable\_version\_id**
STRING |
| **state**
STRING |
| **steps**
ARRAY
This is a nested data structure:
- advance_method: STRING
- attributes: OBJECT, which is also a nested data structure.
- auto_height: BOOLEAN
- css: STRING
- height: INTEGER
- width: INTEGER
- content_type: STRING
- content_url: STRING
- content_url_css: STRING
- content_url_js: STRING
- element_path_rule: STRING
- guide_id: STRING
- id: STRING
- last_updated_at: DATE-TIME
- page_id: STRING
- rank: INTEGER
- regex_url_rule: STRING
- reset_at: DATE-TIME
- type: STRING
|
### metadata\_accounts
The `metadata_accounts` table contains info about the metadata schema used for account objects in your Pendo account.
| **Replication Method** | Full Table |
| --- | --- |
| **Useful links** | [Pendo documentation](https://engageapi.pendo.io/#a0064303-3aa9-41ef-a7bc-2e43c0ccd88e)
[Pendo API method](https://engageapi.pendo.io/#a59ff30a-d29c-430c-b28a-fa64d199a9b9 "Opens in new tab: Pendo API method") |
metadata\_accounts table schema
| **auto**
OBJECT
This is a nested data structure:
- firstvisit: OBJECT, which is also a nested data structure.
- dirty: BOOLEAN
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
- id: OBJECT, which is also a nested data structure.
- dirty: BOOLEAN
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
- lastvisit: OBJECT, which is also a nested data structure.
- dirty: BOOLEAN
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
|
| --- |
### metadata\_visitors
The `metadata_visitors` table contains info about the metadata schema used for visitor objects in your Pendo account.
| **Replication Method** | Full Table |
| --- | --- |
| **Useful links** | [Pendo documentation](https://engageapi.pendo.io/#a0064303-3aa9-41ef-a7bc-2e43c0ccd88e)
[Pendo API method](https://engageapi.pendo.io/#a59ff30a-d29c-430c-b28a-fa64d199a9b9 "Opens in new tab: Pendo API method") |
metadata\_visitors table schema
| **agent**
OBJECT
This is a nested data structure:
- language, OBJECT, which is also a nested data structure:
- dirty: OBJECT
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
- auto, OBJECT, which is also a nested data structure:
- accountid: OBJECT, which is also a nested data structure:
- dirty: OBJECT
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
- accountids, OBJECT, which is also a nested data structure:
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
- firstvisit, OBJECT, which is also a nested data structure:
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
- id, OBJECT, which is also a nested data structure:
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
- lastbrowsername, OBJECT, which is also a nested data structure:
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
- lastbrowserversion, OBJECT, which is also a nested data structure:
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
- lastoperatingsystem, OBJECT, which is also a nested data structure:
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
- lastservername, OBJECT, which is also a nested data structure:
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
- lastvisit, OBJECT, which is also a nested data structure:
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
- pendo, OBJECT, which is also a nested data structure:
- designerenabled: OBJECT
- display_name: STRING
- element_format: STRING
- element_type: STRING
- is_calculated: BOOLEAN
- is_deleted: BOOLEAN
- is_hidden: BOOLEAN
- is_per_app: BOOLEAN
- never_index: BOOLEAN
- type: STRING
|
| --- |
### page\_events
The `page_events` table contains info about page events recorded in your Pendo account.
**Note**: The **Period** setting you define during setup determine how this table is replicated, including the field used as a Replication Key. Refer to the [Replication section](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#event-replication) for more info.
| **Replication Method** | CDC |
| --- | --- |
| **Primary Keys** | account\_id
server
remote\_ip
visitor\_id
day
page\_id
user\_agent |
| **Useful links** | [Pendo documentation](https://engageapi.pendo.io/#3d10cfdb-c4b3-4a9c-8d67-dc250cab82ab)
[Pendo API method](https://engageapi.pendo.io/#7c8479b8-3843-403c-94a9-04cbdf542db9 "Opens in new tab: Pendo API method") |
page\_events table foreign keys
| Join page\_events with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#accounts) | ```
page_events.account_id = accounts.account_id
``` |
| [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#events) | ```
page_events.account_id = events.account_id
```
```
page_events.app_id = events.app_id
```
```
page_events.page_id = events.page_id
```
```
page_events.visitor_id = events.visitor_id
``` |
| [feature_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#feature-events) | ```
page_events.account_id = feature_events.account_id
```
```
page_events.app_id = feature_events.app_id
```
```
page_events.visitor_id = feature_events.visitor_id
``` |
| [guide_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guide-events) | ```
page_events.account_id = guide_events.account_id
```
```
page_events.account_id = guide_events.account_ids
```
```
page_events.app_id = guide_events.app_id
```
```
page_events.visitor_id = guide_events.visitor_id
``` |
| [poll_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#poll-events) | ```
page_events.account_id = poll_events.account_id
```
```
page_events.account_id = poll_events.account_ids
```
```
page_events.visitor_id = poll_events.visitor_id
``` |
| [track_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-events) | ```
page_events.account_id = track_events.account_id
```
```
page_events.app_id = track_events.app_id
```
```
page_events.visitor_id = track_events.visitor_id
``` |
| [visitors](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitors) | ```
page_events.account_id = visitors.metadata_auto.accountid
```
```
page_events.account_id = visitors.metadata_auto.accountids
```
```
page_events.visitor_id = visitors.visitor_id
``` |
| [features](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#features) | ```
page_events.app_id = features.created_by_user.app_id
```
```
page_events.page_id = features.page_id
``` |
| [visitor_history](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitor-history) | ```
page_events.app_id = visitor_history.app_id
```
```
page_events.page_id = visitor_history.page_id
```
```
page_events.visitor_id = visitor_history.visitor_id
``` |
| [guides](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guides) | ```
page_events.page_id = guides.steps.page_id
```
```
page_events.visitor_id = guides.audience.select.visitor_id
``` |
| [pages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#pages) | ```
page_events.page_id = pages.id
``` |
page\_events table schema
| **account\_id**
STRING |
| --- |
| **app\_id**
NUMBER |
| **day**
DATE-TIME |
| **hour**
DATE-TIME |
| **num\_events**
INTEGER |
| **num\_minutes**
INTEGER |
| **page\_id**
STRING |
| **parameters**
STRING |
| **remote\_ip**
STRING |
| **server**
STRING |
| **user\_agent**
STRING |
| **visitor\_id**
STRING |
### pages
The `pages` table contains info about specific pages in your Pendo app.
| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | last\_updated\_at |
| **Useful links** | [Pendo documentation](https://engageapi.pendo.io/#e7ef2d55-8ae8-46a5-b36e-1197fb3d9c3a)
[Pendo API method](https://engageapi.pendo.io/#7c8479b8-3843-403c-94a9-04cbdf542db9 "Opens in new tab: Pendo API method") |
pages table foreign keys
| Join pages with | on |
| --- | --- |
| [features](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#features) | ```
pages.group.id = features.group.id
```
```
pages.id = features.page_id
```
```
pages.created_by_user.id = features.created_by_user.id
```
```
pages.group.created_by_user.id = features.created_by_user.id
```
```
pages.group.last_updated_by_user.id = features.created_by_user.id
```
```
pages.last_updated_by_user.id = features.created_by_user.id
```
```
pages.created_by_user.id = features.group.created_by_user.id
```
```
pages.group.created_by_user.id = features.group.created_by_user.id
```
```
pages.group.last_updated_by_user.id = features.group.created_by_user.id
```
```
pages.last_updated_by_user.id = features.group.created_by_user.id
```
```
pages.created_by_user.id = features.group.last_updated_by_user.id
```
```
pages.group.created_by_user.id = features.group.last_updated_by_user.id
```
```
pages.group.last_updated_by_user.id = features.group.last_updated_by_user.id
```
```
pages.last_updated_by_user.id = features.group.last_updated_by_user.id
```
```
pages.created_by_user.id = features.last_updated_by_user.id
```
```
pages.group.created_by_user.id = features.last_updated_by_user.id
```
```
pages.group.last_updated_by_user.id = features.last_updated_by_user.id
```
```
pages.last_updated_by_user.id = features.last_updated_by_user.id
``` |
| [track_types](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-types) | ```
pages.group.id = track_types.group.id
```
```
pages.created_by_user.id = track_types.created_by_user.id
```
```
pages.group.created_by_user.id = track_types.created_by_user.id
```
```
pages.group.last_updated_by_user.id = track_types.created_by_user.id
```
```
pages.last_updated_by_user.id = track_types.created_by_user.id
```
```
pages.created_by_user.id = track_types.last_updated_by_user.id
```
```
pages.group.created_by_user.id = track_types.last_updated_by_user.id
```
```
pages.group.last_updated_by_user.id = track_types.last_updated_by_user.id
```
```
pages.last_updated_by_user.id = track_types.last_updated_by_user.id
``` |
| [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#events) | ```
pages.id = events.page_id
``` |
| [guides](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guides) | ```
pages.id = guides.steps.page_id
```
```
pages.created_by_user.id = guides.created_by_user.id
```
```
pages.group.created_by_user.id = guides.created_by_user.id
```
```
pages.group.last_updated_by_user.id = guides.created_by_user.id
```
```
pages.last_updated_by_user.id = guides.created_by_user.id
```
```
pages.created_by_user.id = guides.last_updated_by_user.id
```
```
pages.group.created_by_user.id = guides.last_updated_by_user.id
```
```
pages.group.last_updated_by_user.id = guides.last_updated_by_user.id
```
```
pages.last_updated_by_user.id = guides.last_updated_by_user.id
``` |
| [page_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#page-events) | ```
pages.id = page_events.page_id
``` |
| [visitor_history](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitor-history) | ```
pages.id = visitor_history.page_id
``` |
pages table schema
| **app\_id**
NUMBER |
| --- |
| **color**
STRING |
| **created\_at**
DATE-TIME |
| **created\_by\_user**
OBJECT
This is a nested data structure:
- first: STRING
- id: STRING
- last: STRING
- role: INTEGER
- username: INTEGER
|
| **dirty**
BOOLEAN |
| **group**
OBJECT
This is a nested data structure:
- color: STRING
- created_at: DATE-TIME
- created_by_user: OBJECT, which is also a nested data structure:
- first: STRING
- id: STRING
- last: STRING
- role: INTEGER
- username: STRING
- description: STRING
- id: STRING
- last_updated_at: DATE-TIME
- last_updated_by_user: OBJECT, which is also a nested data structure:
- first: STRING
- id: STRING
- last: STRING
- role: INTEGER
- username: STRING
- length: INTEGER
- name: STRING
|
| **id**
STRING |
| **kind**
STRING |
| **last\_updated\_at**
DATE-TIME |
| **last\_updated\_by\_user**
OBJECT
This is a nested data structure:
- first: STRING
- id: STRING
- last: STRING
- role: INTEGER
- username: STRING
|
| **name**
STRING |
| **root\_version\_id**
STRING |
| **rules**
ARRAY
This is a nested data structure:
- designer_hint: STRING
- parsed_rule: STRING
- rule: STRING
|
| **stable\_version\_id**
STRING |
### poll\_events
The `poll_events` table contains info about poll events recorded in your Pendo account.
**Note**: The **Period** setting you define during setup determine how this table is replicated, including the field used as a Replication Key. Refer to the [Replication section](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#event-replication) for more info.
| **Replication Method** | CDC |
| --- | --- |
| **Primary Keys** | account\_id
remote\_ip
visitor\_id
browser\_time
poll\_id |
| **Replication Key** | browser\_time |
| **Useful links** | [Pendo documentation](https://engageapi.pendo.io/#3d10cfdb-c4b3-4a9c-8d67-dc250cab82ab)
[Pendo API method](https://engageapi.pendo.io/#7c8479b8-3843-403c-94a9-04cbdf542db9 "Opens in new tab: Pendo API method") |
poll\_events table foreign keys
| Join poll\_events with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#accounts) | ```
poll_events.account_id = accounts.account_id
```
```
poll_events.account_ids = accounts.account_id
``` |
| [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#events) | ```
poll_events.account_id = events.account_id
```
```
poll_events.account_ids = events.account_id
```
```
poll_events.visitor_id = events.visitor_id
``` |
| [feature_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#feature-events) | ```
poll_events.account_id = feature_events.account_id
```
```
poll_events.account_ids = feature_events.account_id
```
```
poll_events.visitor_id = feature_events.visitor_id
``` |
| [guide_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guide-events) | ```
poll_events.account_id = guide_events.account_id
```
```
poll_events.account_ids = guide_events.account_id
```
```
poll_events.account_id = guide_events.account_ids
```
```
poll_events.account_ids = guide_events.account_ids
```
```
poll_events.guide_id = guide_events.guide_id
```
```
poll_events.poll_id = guide_events.poll_id
```
```
poll_events.visitor_id = guide_events.visitor_id
``` |
| [page_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#page-events) | ```
poll_events.account_id = page_events.account_id
```
```
poll_events.account_ids = page_events.account_id
```
```
poll_events.visitor_id = page_events.visitor_id
``` |
| [track_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-events) | ```
poll_events.account_id = track_events.account_id
```
```
poll_events.account_ids = track_events.account_id
```
```
poll_events.visitor_id = track_events.visitor_id
``` |
| [visitors](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitors) | ```
poll_events.account_id = visitors.metadata_auto.accountid
```
```
poll_events.account_ids = visitors.metadata_auto.accountid
```
```
poll_events.account_id = visitors.metadata_auto.accountids
```
```
poll_events.account_ids = visitors.metadata_auto.accountids
```
```
poll_events.visitor_id = visitors.visitor_id
``` |
| [guides](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guides) | ```
poll_events.guide_id = guides.id
```
```
poll_events.guide_id = guides.steps.guide_id
```
```
poll_events.visitor_id = guides.audience.select.visitor_id
``` |
| [visitor_history](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitor-history) | ```
poll_events.guide_id = visitor_history.guide_id
```
```
poll_events.visitor_id = visitor_history.visitor_id
``` |
poll\_events table schema
| **account\_id**
STRING |
| --- |
| **account\_ids**
ARRAY |
| **app\_id**
NUMBER |
| **browser\_time**
DATE-TIME |
| **country**
STRING |
| **guide\_id**
STRING |
| **latitude**
NUMBER |
| **load\_time**
INTEGER |
| **longitude**
NUMBER |
| **poll\_id**
STRING |
| **poll\_response**
STRING |
| **region**
STRING |
| **remote\_ip**
STRING |
| **server\_name**
STRING |
| **type**
STRING |
| **user\_agent**
STRING |
| **visitor\_id**
STRING |
### track\_events
The `track_events` table contains info about the track events recorded in your Pendo account.
**Note**: The **Period** setting you define during setup determine how this table is replicated, including the field used as a Replication Key. Refer to the [Replication section](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#event-replication) for more info.
| **Replication Method** | CDC |
| --- | --- |
| **Primary Keys** | account\_id
remote\_ip
server
visitor\_id
day
track\_type\_id
user\_agent |
| **Useful links** | [Pendo documentation](https://engageapi.pendo.io/#2757f228-ca94-4075-a840-b1fafd6d43b2)
[Pendo API method](https://engageapi.pendo.io/#7c8479b8-3843-403c-94a9-04cbdf542db9 "Opens in new tab: Pendo API method") |
track\_events table foreign keys
| Join track\_events with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#accounts) | ```
track_events.account_id = accounts.account_id
``` |
| [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#events) | ```
track_events.account_id = events.account_id
```
```
track_events.app_id = events.app_id
```
```
track_events.visitor_id = events.visitor_id
``` |
| [feature_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#feature-events) | ```
track_events.account_id = feature_events.account_id
```
```
track_events.app_id = feature_events.app_id
```
```
track_events.visitor_id = feature_events.visitor_id
``` |
| [guide_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guide-events) | ```
track_events.account_id = guide_events.account_id
```
```
track_events.account_id = guide_events.account_ids
```
```
track_events.app_id = guide_events.app_id
```
```
track_events.visitor_id = guide_events.visitor_id
``` |
| [page_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#page-events) | ```
track_events.account_id = page_events.account_id
```
```
track_events.app_id = page_events.app_id
```
```
track_events.visitor_id = page_events.visitor_id
``` |
| [poll_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#poll-events) | ```
track_events.account_id = poll_events.account_id
```
```
track_events.account_id = poll_events.account_ids
```
```
track_events.visitor_id = poll_events.visitor_id
``` |
| [visitors](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitors) | ```
track_events.account_id = visitors.metadata_auto.accountid
```
```
track_events.account_id = visitors.metadata_auto.accountids
```
```
track_events.visitor_id = visitors.visitor_id
``` |
| [features](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#features) | ```
track_events.app_id = features.created_by_user.app_id
``` |
| [visitor_history](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitor-history) | ```
track_events.app_id = visitor_history.app_id
```
```
track_events.visitor_id = visitor_history.visitor_id
``` |
| [track_types](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-types) | ```
track_events.track_type_id = track_types.id
``` |
| [guides](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guides) | ```
track_events.visitor_id = guides.audience.select.visitor_id
``` |
track\_events table schema
| **account\_id**
STRING |
| --- |
| **app\_id**
NUMBER |
| **day**
DATE-TIME |
| **hour**
DATE-TIME |
| **num\_events**
INTEGER |
| **num\_minutes**
INTEGER |
| **properties**
OBJECT
This is a nested data structure:
- android: BOOLEAN
- any: BOOLEAN
- apple: BOOLEAN
- phone: BOOLEAN
- table: BOOLEAN
|
| **remote\_ip**
STRING |
| **server**
STRING |
| **track\_type\_id**
STRING |
| **user\_agent**
STRING |
| **visitor\_id**
STRING |
### track\_types
The `track_types` table contains info about
| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Pendo API method](https://engageapi.pendo.io/#7c8479b8-3843-403c-94a9-04cbdf542db9 "Opens in new tab: Pendo API method") |
track\_types table foreign keys
| Join track\_types with | on |
| --- | --- |
| [features](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#features) | ```
track_types.group.id = features.group.id
```
```
track_types.created_by_user.id = features.created_by_user.id
```
```
track_types.last_updated_by_user.id = features.created_by_user.id
```
```
track_types.created_by_user.id = features.group.created_by_user.id
```
```
track_types.last_updated_by_user.id = features.group.created_by_user.id
```
```
track_types.created_by_user.id = features.group.last_updated_by_user.id
```
```
track_types.last_updated_by_user.id = features.group.last_updated_by_user.id
```
```
track_types.created_by_user.id = features.last_updated_by_user.id
```
```
track_types.last_updated_by_user.id = features.last_updated_by_user.id
``` |
| [pages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#pages) | ```
track_types.group.id = pages.group.id
```
```
track_types.created_by_user.id = pages.created_by_user.id
```
```
track_types.last_updated_by_user.id = pages.created_by_user.id
```
```
track_types.created_by_user.id = pages.group.created_by_user.id
```
```
track_types.last_updated_by_user.id = pages.group.created_by_user.id
```
```
track_types.created_by_user.id = pages.group.last_updated_by_user.id
```
```
track_types.last_updated_by_user.id = pages.group.last_updated_by_user.id
```
```
track_types.created_by_user.id = pages.last_updated_by_user.id
```
```
track_types.last_updated_by_user.id = pages.last_updated_by_user.id
``` |
| [track_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-events) | ```
track_types.id = track_events.track_type_id
``` |
| [guides](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guides) | ```
track_types.created_by_user.id = guides.created_by_user.id
```
```
track_types.last_updated_by_user.id = guides.created_by_user.id
```
```
track_types.created_by_user.id = guides.last_updated_by_user.id
```
```
track_types.last_updated_by_user.id = guides.last_updated_by_user.id
``` |
track\_types table schema
| **app\_id**
NUMBER |
| --- |
| **color**
STRING |
| **created\_at**
DATE-TIME |
| **created\_by\_user**
OBJECT
This is a nested data structure:
- first: STRING
- id: STRING
- last: STRING
- role: INTEGER
- username: STRING
|
| **dirty**
BOOLEAN |
| **group**
OBJECT
This is a nested data structure:
- color: STRING
- description: STRING
- id: STRING
- length: INTEGER
- name: STRING
|
| **id**
STRING |
| **kind**
STRING |
| **last\_updated\_at**
DATE-TIME |
| **last\_updated\_by\_user**
OBJECT
This is a nested data structure:
- color: STRING
- description: STRING
- id: STRING
- length: INTEGER
- name: STRING
|
| **name**
STRING |
| **root\_version\_id**
STRING |
| **stable\_version\_id**
STRING |
| **track\_type\_name**
BOOLEAN |
| **track\_type\_rules**
ARRAY |
### visitor\_history
The `visitor_history` table contains info about visitor activity.
| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | visitor\_id |
| **Replication Key** | modified\_ts |
| **Useful links** | [Pendo documentation](https://engageapi.pendo.io/#3acb7d0d-69dc-4508-a9ba-e085a7301c27)
[Pendo API method](https://engageapi.pendo.io/#7c8479b8-3843-403c-94a9-04cbdf542db9 "Opens in new tab: Pendo API method") |
visitor\_history table foreign keys
| Join visitor\_history with | on |
| --- | --- |
| [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#events) | ```
visitor_history.app_id = events.app_id
```
```
visitor_history.feature_id = events.feature_id
```
```
visitor_history.page_id = events.page_id
```
```
visitor_history.visitor_id = events.visitor_id
``` |
| [feature_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#feature-events) | ```
visitor_history.app_id = feature_events.app_id
```
```
visitor_history.feature_id = feature_events.feature_id
```
```
visitor_history.visitor_id = feature_events.visitor_id
``` |
| [features](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#features) | ```
visitor_history.app_id = features.created_by_user.app_id
```
```
visitor_history.feature_id = features.id
```
```
visitor_history.page_id = features.page_id
``` |
| [guide_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guide-events) | ```
visitor_history.app_id = guide_events.app_id
```
```
visitor_history.guide_id = guide_events.guide_id
```
```
visitor_history.visitor_id = guide_events.visitor_id
``` |
| [page_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#page-events) | ```
visitor_history.app_id = page_events.app_id
```
```
visitor_history.page_id = page_events.page_id
```
```
visitor_history.visitor_id = page_events.visitor_id
``` |
| [track_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-events) | ```
visitor_history.app_id = track_events.app_id
```
```
visitor_history.visitor_id = track_events.visitor_id
``` |
| [guides](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guides) | ```
visitor_history.guide_id = guides.id
```
```
visitor_history.guide_id = guides.steps.guide_id
```
```
visitor_history.guide_id = guides.steps.id
```
```
visitor_history.page_id = guides.steps.page_id
```
```
visitor_history.visitor_id = guides.audience.select.visitor_id
``` |
| [poll_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#poll-events) | ```
visitor_history.guide_id = poll_events.guide_id
```
```
visitor_history.visitor_id = poll_events.visitor_id
``` |
| [pages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#pages) | ```
visitor_history.page_id = pages.id
``` |
| [visitors](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitors) | ```
visitor_history.visitor_id = visitors.visitor_id
``` |
visitor\_history table schema
| **app\_id**
NUMBER |
| --- |
| **duration**
INTEGER |
| **feature\_id**
STRING |
| **guide\_id**
STRING |
| **guide\_step\_id**
STRING |
| **last\_ts**
DATE-TIME |
| **modified\_ts**
DATE-TIME |
| **page\_id**
STRING |
| **parsed\_user\_agent**
OBJECT
This is a nested data structure:
- name: STRING
- os: STRING
- version: STRING
|
| **ts**
DATE-TIME |
| **type**
STRING |
| **untagged\_url**
STRING |
| **uri**
STRING |
| **visitor\_id**
STRING |
### visitors
The `visitors` table contains info about the visitors recorded in your Pendo account.
| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | visitor\_id |
| **Replication Key** | lastupdated |
| **Useful links** | [Pendo documentation](https://engageapi.pendo.io/#3acb7d0d-69dc-4508-a9ba-e085a7301c27)
[Pendo API method](https://engageapi.pendo.io/#7c8479b8-3843-403c-94a9-04cbdf542db9 "Opens in new tab: Pendo API method") |
visitors table foreign keys
| Join visitors with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#accounts) | ```
visitors.metadata_auto.accountid = accounts.account_id
```
```
visitors.metadata_auto.accountids = accounts.account_id
``` |
| [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#events) | ```
visitors.metadata_auto.accountid = events.account_id
```
```
visitors.metadata_auto.accountids = events.account_id
```
```
visitors.visitor_id = events.visitor_id
``` |
| [feature_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#feature-events) | ```
visitors.metadata_auto.accountid = feature_events.account_id
```
```
visitors.metadata_auto.accountids = feature_events.account_id
```
```
visitors.visitor_id = feature_events.visitor_id
``` |
| [guide_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guide-events) | ```
visitors.metadata_auto.accountid = guide_events.account_id
```
```
visitors.metadata_auto.accountids = guide_events.account_id
```
```
visitors.metadata_auto.accountid = guide_events.account_ids
```
```
visitors.metadata_auto.accountids = guide_events.account_ids
```
```
visitors.visitor_id = guide_events.visitor_id
``` |
| [page_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#page-events) | ```
visitors.metadata_auto.accountid = page_events.account_id
```
```
visitors.metadata_auto.accountids = page_events.account_id
```
```
visitors.visitor_id = page_events.visitor_id
``` |
| [poll_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#poll-events) | ```
visitors.metadata_auto.accountid = poll_events.account_id
```
```
visitors.metadata_auto.accountids = poll_events.account_id
```
```
visitors.metadata_auto.accountid = poll_events.account_ids
```
```
visitors.metadata_auto.accountids = poll_events.account_ids
```
```
visitors.visitor_id = poll_events.visitor_id
``` |
| [track_events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#track-events) | ```
visitors.metadata_auto.accountid = track_events.account_id
```
```
visitors.metadata_auto.accountids = track_events.account_id
```
```
visitors.visitor_id = track_events.visitor_id
``` |
| [guides](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#guides) | ```
visitors.visitor_id = guides.audience.select.visitor_id
``` |
| [visitor_history](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Pendo-v2.htm#visitor-history) | ```
visitors.visitor_id = visitor_history.visitor_id
``` |
visitors table schema
| **lastupdated**
DATE-TIME |
| --- |
| **metadata\_agent**
OBJECT
This is a nested data structure:
- email: STRING
- ipaddress: STRING
- language: STRING
|
| **metadata\_auto**
OBJECT
This is a nested data structure:
- accountid: STRING
- accountids: ARRAY, which is also a nested data structure:
- firstvisit: DATE-TIME
- id: STRING
- idhash: INTEGER
- lastbrowsername: STRING
- lastbrowserversion: STRING
- lastoperatingsystem: STRING
- lastservername: STRING
- lastupdated: DATE-TIME
- lastuseragent: STRING
- lastvisit: DATE-TIME
- nid: INTEGER
|
| **metadata\_custom**
OBJECT |
| **visitor\_id**
STRING |