Pendo walkthrough

note

Data Integration currently supports Pendo API version 1.

Pendo is a data analytics tool designed to assist software companies in creating products appealing to customers.

Connection

An Integration Key authenticates requests. After activating the subscription, Admins can create and manage these keys.

Reports

Customization

After establishing a connection, you can create a custom report and select a specific report to pull data from the Pendo API.

Filters

Use the following parameters to filter some of the reports

You can select only one parameter at a time.

1. Accounts
2. Track Types
3. Visitors
4. All

After selecting a filter, Click To Select, and wait for the necessary data to be fetched in a drop-down. Choose all the IDs from which you require data.

note

Leaving this field empty has the same effect as choosing All.

Incremental function

Some of the reports are incremental (pulled by time spans). You can use Incremental or All for extraction. If you select the incremental option, specify the date range.

note

• Start date is mandatory.
• The system retrieves the data for the date range specified between the start and end dates.
• If you leave the end date blank, the data is pulled at the current time of the river's run.
• Dates align with the UTC timezone.
• Use the Last Days Back For Each Run option to gather data from a specified number of days before the selected start date.

To make the request process easier, you can divide the calls into separate chunks (Daily, Weekly, or Monthly).

tip

Use divide by chunks when the data you pull is large, and if you are hitting sizing or timeout limits.

Visitors History

You can pull this report for a single ID to obtain statistics for many visitors.

Choose the IDs, as collecting all visitors would take a long time.

The requests are limited to the last 180 days and are made for a single 24-hour period starting on a specific day. Select a beginning and ending date to obtain a period of time, and a separate request will be sent automatically for each day in between.

Retrieving details

The API requests are performed by either a POST method using the endpoint https://app.pendo.io/api/v1/aggregation and a specific MongoDB-like query JSON body, or a GET method using a specific URI for https://app.pendo.io.

Report	Filters	Incremental
Accounts	Account ID	No
Visitors	Account ID, Visitor ID	No
Visitors History	Visitor ID	Yes
Events	Account ID, Visitor ID	Yes
Feature Events	Account ID, Feature ID, Visitor ID	Yes
Page Events	Account ID, Page ID, Visitor ID	Yes
Track Events	Account ID, Track Type, Visitor ID	Yes
Features	-	No
Guides	-	No
Pages	-	No
Resports	-	No
Track Types	-	No

Pendo's official documentation

• Official Pendo App Help Center
• Official Pendo API Docs

Hard delete feature

Microsoft-SQL Change Tracking with Snowflake target rivers features the Include Deleted Rows feature. You can activate Include Deleted Rows.

Procedure

1. Navigate to the Microsoft SQL Server river and select Schema.
2. Choose a dedicated Source Table.
3. Go to Table settings.
4. Select the Initiate Migration checkbox and Overwrite Table Migration to match the existing database in SQL Server with the Snowflake table (optional).

Skip this step if you want to keep working with the data in Snowflake that is marked as deleted.

note

The checkbox is unselected after the first "Initiate Migration" is completed.

5. Click Include Deleted Rows.

note

If you select Include Deleted Rows, the river will retrieve all changes from the "Change Tracking" table, including deleted rows. It also adds a __DELETED column to indicate if the row was deleted from the source table.

6. Enable Remove Deleted Rows (optional).

note

This option is permitted only by selecting Upsert - Merge in Loading Mode.

caution

By enabling Remove Deleted Rows, all rows having the status True (Delete) will be eliminated and removed from the Snowflake target table.

7. Click Run.
8. Connect to Snowflake.