Fivetran now supports extracting data from Pendo using Data Sync.
We have changed the primary key of the
EVENT table. Now, we use only the
_fivetran_id column as the primary key. Previously, we used a composite primary key which was a combination of the following columns:
We have added a new primary key column,
_fivetran_id, to the following tables to avoid data integrity issues:
This functionality is enabled by default for new connectors created after March 21, 2023. We are gradually rolling out this change to all the existing connectors.
We now sync the properties field of the
You can now exclude the following tables from your syncs:
By default, we include these tables in syncs. To exclude the tables, go to the Schema tab of your connector details page and deselect the tables.
You can now exclude the
VISITOR_ACCOUNT_ASSOCIATION tables from the syncs. On your connector details page, go to the Schema tab and deselect the tables. By default, we include these tables in the sync. If you exclude the tables and later want to sync the tables, perform a complete table re-sync to ensure data integrity.
We have added a new primary key column,
_fivetran_id, to the
FEATURE_EVENT tables to avoid data integrity issues. This functionality is enabled by default for new connectors created after December 15, 2022. We are gradually rolling out the feature to all the existing connectors.
Our Pendo connector now supports projects in the US1 region. To fetch data from Pendo's US1 data center, you must change the integration key for the connector to one that is compatible with Pendo's US1 endpoint. Generate a compatible integration key from us1.app.pendo.io.
We have added the following columns to the
To sync your historical data from these columns, contact our support team.
We have added a new table,
PICKLIST_POLL_RESPONSE, that stores the text response of the PickList poll type.
Pendo processes data at the top of each hour, and it can take up to 15 minutes past the hour for that data to be available. As a result, events data is not immediately available to Fivetran through the API but within 15 minutes past the hour. We have updated our API calls for the
POLL_EVENT tables to include a rollback time for the end cursors to fetch the data.
We have released pre-built, dbt Core-compatible data models for Pendo. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
We have added a new field, Sync Mode, to the connector setup form. You can now select all or specific Pendo App Ids to sync to your destination. See our setup instructions for more details.
We have added a new custom field,
property_*, to the
We have added a new field,
is_core_event, to the
We now sync the following tables on a priority-first basis:
We now sync property data in the
TRACK_TYPE_EVENT table. We sync each property to the destination in its own column and add the prefix
property_ to the column name. For example, the
file property is synced to the destination as the
We now sync parameter data in the
EVENT tables. We sync each parameter to the destination in its own column and add the prefix
param_ to the column name. For example, the
decisionData parameter is synced to the destination as the
You can now configure your Pendo connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
The Pendo connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Pendo's priority-first syncs fetch the most recent seven days' worth of data from the
To learn more, see our priority-first sync documentation.
Our Pendo connector now supports projects in the EU region. To let a connector fetch data from Pendo's EU data center, you must change the integration key for the connector to one that is compatible with Pendo's EU endpoint. Generate a compatible integration key from app.eu.pendo.io.
We now provide
segmentio metadata in
We have changed the data type of
n_id in the
VISITOR table from
Pendo helps product teams understand and guide users to create product experiences that customers love.