Pendo connector reference

Important

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Azure Databricks previews.

This page provides reference information for the Pendo connector, including supported tables and their schemas.

Supported source tables

The Pendo connector supports the following source tables:

Source table	Primary key	Description	Sync mode
page	id	Pages tracked in your Pendo subscription, including page rules, group membership, and authoring metadata.	Full refresh only
feature	id	Features tracked in your Pendo subscription, including element selection rules, event property configurations, and group membership.	Full refresh only
guide	id	In-product guides, including audience, steps, polls, conversion settings, and publishing state.	Full refresh only
report	id	Saved reports, including definition, aggregation, scope, sharing, and last-run metadata.	Full refresh only

page schema

The following table describes selected top-level fields in the page table. The full row also includes nested createdByUser, lastUpdatedByUser, group, and rules records.

Column	Type	Description
id	string	Page identifier. Primary key.
appId	long	Identifier of the application the page belongs to.
name	string	Page name.
suggestedName	string	Pendo's suggested name for the page.
color	string	Display color associated with the page.
kind	string	Page kind, as defined in Pendo.
createdAt	long	Creation timestamp (milliseconds since epoch).
lastUpdatedAt	long	Last update timestamp (milliseconds since epoch).
validThrough	long	Timestamp through which the page definition is valid.
isAutoTagged	boolean	Whether the page was created by Pendo autotagging.
isCoreEvent	boolean	Whether the page is marked as a core event.
dirty	boolean	Whether the page has unpublished changes.
rootVersionId	string	Identifier of the root version for the page definition.
stableVersionId	string	Identifier of the most recently published stable version.
rulesjson	string	Page rules serialized as JSON.

feature schema

The following table describes selected top-level fields in the feature table. The full row also includes nested createdByUser, lastUpdatedByUser, group, elementPathRules, and eventPropertyConfigurations records.

Column	Type	Description
id	string	Feature identifier. Primary key.
appId	long	Identifier of the application the feature belongs to.
name	string	Feature name.
suggestedMatch	string	Pendo's suggested match for the feature.
pageId	string	Identifier of the parent page, if the feature is scoped to a page.
appWide	boolean	Whether the feature applies across the entire application.
color	string	Display color associated with the feature.
kind	string	Feature kind, as defined in Pendo.
elementInitialTag	string	Initial element tag selector.
elementSelectionType	string	Selection strategy used to identify the underlying UI element.
createdAt	long	Creation timestamp (milliseconds since epoch).
lastUpdatedAt	long	Last update timestamp (milliseconds since epoch).
validThrough	long	Timestamp through which the feature definition is valid.
isCoreEvent	boolean	Whether the feature is marked as a core event.
dirty	boolean	Whether the feature has unpublished changes.
rootVersionId	string	Identifier of the root version for the feature definition.
stableVersionId	string	Identifier of the most recently published stable version.
createdDesignerVersion	string	Pendo Designer version used to create the feature.

guide schema

The following table describes selected top-level fields in the guide table. The full row also includes nested audience, audienceUiHint, steps, polls, conversion, experiment, emailConfiguration, createdByUser, and lastUpdatedByUser records.

Column	Type	Description
id	string	Guide identifier. Primary key.
appId	long	Identifier of the primary application the guide is associated with.
appIds	array<long>	Identifiers of all applications the guide targets.
name	string	Guide name.
description	string	Guide description.
kind	string	Guide kind (for example, tooltip, lightbox).
state	string	Lifecycle state (for example, draft, public, disabled).
editorType	string	Editor used to build the guide.
authoredLanguage	string	Language the guide was authored in.
isModule	boolean	Whether the guide is a reusable module.
isMultiStep	boolean	Whether the guide has multiple steps.
isTopLevel	boolean	Whether the guide is a top-level guide (not a child of another guide).
isTraining	boolean	Whether the guide is marked as training content.
launchMethod	string	How the guide is launched (for example, automatic, manual).
minAgentVersion	string	Minimum Pendo agent version required to render the guide.
recurrence	long	Recurrence interval, in milliseconds.
recurrenceEligibilityWindow	long	Recurrence eligibility window, in milliseconds.
resetAt	long	Timestamp at which the guide eligibility was last reset.
publishedAt	long	Most recent publish timestamp (milliseconds since epoch).
publishedEver	boolean	Whether the guide has ever been published.
emailState	string	Delivery state of the associated email guide, if applicable.
resourceCenterId	string	Identifier of the parent Resource Center, if applicable.
originId	string	Identifier of the originating guide, if cloned.
rootVersionId	string	Identifier of the root version for the guide definition.
stableVersionId	string	Identifier of the most recently published stable version.
attributes	string	Additional guide attributes serialized as JSON.
children	array<string>	Identifiers of child guides, if any.
createdAt	long	Creation timestamp (milliseconds since epoch).
currentFirstEligibleToBeSeenAt	long	Earliest timestamp at which the current version becomes eligible to display.
lastUpdatedAt	long	Last update timestamp (milliseconds since epoch).
showsAfter	long	Earliest timestamp at which the guide might be shown.

report schema

The following table describes selected top-level fields in the report table. The full row also includes nested createdByUser, lastUpdatedByUser, and ownedByUser records.

Column	Type	Description
id	string	Report identifier. Primary key.
name	string	Report name.
type	string	Report type.
kind	string	Report kind, as defined in Pendo.
level	string	Reporting level (for example, account, visitor).
scope	string	Reporting scope.
target	string	Target of the report (for example, a specific feature, page, or guide).
aggregation	string	Aggregation applied to the report metric.
definition	string	Report definition serialized as JSON.
share	string	Sharing configuration, if any.
shared	boolean	Whether the report is shared with other users.
createdAt	long	Creation timestamp (milliseconds since epoch).
lastUpdatedAt	long	Last update timestamp (milliseconds since epoch).
lastRunAt	long	Timestamp of the most recent run (milliseconds since epoch).
lastSuccessRunAt	long	Timestamp of the most recent successful run (milliseconds since epoch).
lastSuccessRunObj	string	Metadata for the most recent successful run, serialized as JSON.
rootVersionId	string	Identifier of the root version for the report definition.
stableVersionId	string	Identifier of the most recently published stable version.