Supernova home
Documentation menu

Pendo#

Connect Pendo with an integration key. The source writes 13 fixed tables under titan.pendo.

sql
select
  page_id,
  account_id,
  app_id
from titan.pendo.page_events
limit 10

Connect Pendo#

  1. Open Apps, choose Connect app, and select Pendo.

  2. Enter an integration key.

  3. Review the tables, then save the source.

  4. Watch Sync history until the first run completes.

Credentials are stored as secrets. They never become lake columns or appear in query results.

Sync behavior#

Long syncs checkpoint every 10 minutes. Large event windows split adaptively down to 1 hour.

A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely.

Every lake table also has the system columns _synced_at and _deleted; the column reference below lists source columns only.

Table reference#

page_events#

titan.pendo.page_events has 24 source columns.

pendo.page_events24 columns
page_idstringpk

Source field pageId.

account_idstringpk

Source field accountId.

app_idintegerpk

Source field appId.

visitor_idstringpk

Source field visitorId.

hourdatetimepk

Source field hour.

num_eventsinteger

Source field numEvents.

num_minutesinteger

Source field numMinutes.

first_timedatetimepk

Source field firstTime.

last_timedatetimepk

Source field lastTime.

remote_ipstringpk

Source field remoteIp.

serverstringpk

Source field server.

user_agentstringpk

Source field userAgent.

recording_idstringpk

Source field recordingId.

tab_idstringpk

Source field tabId.

analytics_session_idstringpk

Source field analyticsSessionId.

recording_session_idstringpk

Source field recordingSessionId.

error_click_countinteger

Source field errorClickCount.

dead_click_countinteger

Source field deadClickCount.

u_turn_countinteger

Source field uTurnCount.

rage_click_countinteger

Source field rageClickCount.

longitudefloatpk

Source field longitude.

latitudefloatpk

Source field latitude.

regionstringpk

Source field region.

countrystringpk

Source field country.

feature_events#

titan.pendo.feature_events has 24 source columns.

pendo.feature_events24 columns
feature_idstringpk

Source field featureId.

account_idstringpk

Source field accountId.

app_idintegerpk

Source field appId.

visitor_idstringpk

Source field visitorId.

hourdatetimepk

Source field hour.

num_eventsinteger

Source field numEvents.

num_minutesinteger

Source field numMinutes.

first_timedatetimepk

Source field firstTime.

last_timedatetimepk

Source field lastTime.

remote_ipstringpk

Source field remoteIp.

serverstringpk

Source field server.

user_agentstringpk

Source field userAgent.

recording_idstringpk

Source field recordingId.

tab_idstringpk

Source field tabId.

analytics_session_idstringpk

Source field analyticsSessionId.

recording_session_idstringpk

Source field recordingSessionId.

error_click_countinteger

Source field errorClickCount.

dead_click_countinteger

Source field deadClickCount.

u_turn_countinteger

Source field uTurnCount.

rage_click_countinteger

Source field rageClickCount.

longitudefloatpk

Source field longitude.

latitudefloatpk

Source field latitude.

regionstringpk

Source field region.

countrystringpk

Source field country.

events#

titan.pendo.events has 24 source columns.

pendo.events24 columns
page_idstringpk

Source field pageId.

account_idstringpk

Source field accountId.

app_idintegerpk

Source field appId.

visitor_idstringpk

Source field visitorId.

hourdatetimepk

Source field hour.

num_eventsinteger

Source field numEvents.

num_minutesinteger

Source field numMinutes.

first_timedatetimepk

Source field firstTime.

last_timedatetimepk

Source field lastTime.

remote_ipstringpk

Source field remoteIp.

serverstringpk

Source field server.

user_agentstringpk

Source field userAgent.

recording_idstringpk

Source field recordingId.

tab_idstringpk

Source field tabId.

analytics_session_idstringpk

Source field analyticsSessionId.

recording_session_idstringpk

Source field recordingSessionId.

error_click_countinteger

Source field errorClickCount.

dead_click_countinteger

Source field deadClickCount.

u_turn_countinteger

Source field uTurnCount.

rage_click_countinteger

Source field rageClickCount.

longitudefloatpk

Source field longitude.

latitudefloatpk

Source field latitude.

regionstringpk

Source field region.

countrystringpk

Source field country.

track_events#

titan.pendo.track_events has 24 source columns.

pendo.track_events24 columns
track_type_idstringpk

Source field trackTypeId.

account_idstringpk

Source field accountId.

app_idintegerpk

Source field appId.

visitor_idstringpk

Source field visitorId.

hourdatetimepk

Source field hour.

num_eventsinteger

Source field numEvents.

num_minutesinteger

Source field numMinutes.

first_timedatetimepk

Source field firstTime.

last_timedatetimepk

Source field lastTime.

remote_ipstringpk

Source field remoteIp.

serverstringpk

Source field server.

user_agentstringpk

Source field userAgent.

recording_idstringpk

Source field recordingId.

tab_idstringpk

Source field tabId.

analytics_session_idstringpk

Source field analyticsSessionId.

recording_session_idstringpk

Source field recordingSessionId.

error_click_countinteger

Source field errorClickCount.

dead_click_countinteger

Source field deadClickCount.

u_turn_countinteger

Source field uTurnCount.

rage_click_countinteger

Source field rageClickCount.

longitudefloatpk

Source field longitude.

latitudefloatpk

Source field latitude.

regionstringpk

Source field region.

countrystringpk

Source field country.

pages#

titan.pendo.pages has 21 source columns.

pendo.pages21 columns
idstringpk

Source field id.

created_by_userjson

Source field createdByUser.

last_updated_by_userjson

Source field lastUpdatedByUser.

created_atdatetime

Source field createdAt.

last_updated_atdatetime

Source field lastUpdatedAt.

kindstring

Source field kind.

root_version_idstring

Source field rootVersionId.

stable_version_idstring

Source field stableVersionId.

app_idinteger

Source field appId.

app_idsjson

Source field appIds.

namestring

Source field name.

groupjson

Source field group.

is_core_eventboolean

Source field isCoreEvent.

valid_throughdatetime

Source field validThrough.

dirtyboolean

Source field dirty.

daily_merge_firstinteger

Source field dailyMergeFirst.

daily_rollup_firstinteger

Source field dailyRollupFirst.

ignored_frustration_typesjson

Source field ignoredFrustrationTypes.

rulesjson

Source field rules.

rulesjsonstring

Source field rulesjson.

is_suggestedboolean

Source field isSuggested.

features#

titan.pendo.features has 23 source columns.

pendo.features23 columns
idstringpk

Source field id.

page_idstringpk

Source field pageId.

event_property_configurationsjson

Source field eventPropertyConfigurations.

element_path_rulesjson

Source field elementPathRules.

element_selection_typestring

Source field elementSelectionType.

suggested_match_typestring

Source field suggestedMatchType.

app_wideboolean

Source field appWide.

created_by_userjson

Source field createdByUser.

last_updated_by_userjson

Source field lastUpdatedByUser.

created_atdatetime

Source field createdAt.

last_updated_atdatetime

Source field lastUpdatedAt.

kindstring

Source field kind.

root_version_idstring

Source field rootVersionId.

stable_version_idstring

Source field stableVersionId.

app_idinteger

Source field appId.

app_idsjson

Source field appIds.

namestring

Source field name.

groupjson

Source field group.

is_core_eventboolean

Source field isCoreEvent.

valid_throughdatetime

Source field validThrough.

dirtyboolean

Source field dirty.

daily_merge_firstinteger

Source field dailyMergeFirst.

daily_rollup_firstinteger

Source field dailyRollupFirst.

visitors#

titan.pendo.visitors has 2 source columns.

pendo.visitors2 columns
visitor_idstringpk

Source field visitorId.

metadatajson

Source field metadata.

guides#

titan.pendo.guides has 48 source columns.

pendo.guides48 columns
idstringpk

Source field id.

namestring

Source field name.

statestring

Source field state.

kindstring

Source field kind.

launch_methodstring

Source field launchMethod.

editor_typestring

Source field editorType.

authored_languagestring

Source field authoredLanguage.

email_statestring

Source field emailState.

is_multi_stepboolean

Source field isMultiStep.

is_moduleboolean

Source field isModule.

is_top_levelboolean

Source field isTopLevel.

is_trainingboolean

Source field isTraining.

is_dntboolean

Source field isDNT.

auto_create_feedbackboolean

Source field autoCreateFeedback.

include_for_oemboolean

Source field includeForOEM.

published_everboolean

Source field publishedEver.

app_idinteger

Source field appId.

app_idsjson

Source field appIds.

resource_center_idstring

Source field resourceCenterId.

origin_idstring

Source field originId.

root_version_idstring

Source field rootVersionId.

stable_version_idstring

Source field stableVersionId.

recurrenceinteger

Source field recurrence.

recurrence_eligibility_windowinteger

Source field recurrenceEligibilityWindow.

created_atdatetime

Source field createdAt.

last_updated_atdatetime

Source field lastUpdatedAt.

published_atdatetime

Source field publishedAt.

expires_afterdatetime

Source field expiresAfter.

reset_atdatetime

Source field resetAt.

current_first_eligible_to_be_seen_atdatetime

Source field currentFirstEligibleToBeSeenAt.

created_by_user_idstring

Source field createdByUserId.

created_by_usernamestring

Source field createdByUsername.

last_updated_by_user_idstring

Source field lastUpdatedByUserId.

last_updated_by_usernamestring

Source field lastUpdatedByUsername.

device_typestring

Source field deviceType.

segment_idstring

Source field segmentId.

created_by_userjson

Source field createdByUser.

last_updated_by_userjson

Source field lastUpdatedByUser.

attributesjson

Source field attributes.

audiencejson

Source field audience.

audience_ui_hintjson

Source field audienceUiHint.

stepsjson

Source field steps.

childrenjson

Source field children.

pollsjson

Source field polls.

redisplayjson

Source field redisplay.

conversionjson

Source field conversion.

shows_afterjson

Source field showsAfter.

dependent_metadatajson

Source field dependentMetadata.

resource_center#

titan.pendo.resource_center has 11 source columns.

pendo.resource_center11 columns
guide_idstringpk

Source field guideId.

namestring

Source field name.

statestring

Source field state.

module_idstring

Source field moduleId.

is_top_levelboolean

Source field isTopLevel.

origin_idstring

Source field originId.

childrenjson

Source field children.

resource_center_idstring

Source field resourceCenterId.

app_idinteger

Source field appId.

created_atdatetime

Source field createdAt.

last_updated_atdatetime

Source field lastUpdatedAt.

guide_polls#

titan.pendo.guide_polls has 9 source columns.

pendo.guide_polls9 columns
guide_idstringpk

Source field guideId.

poll_idstringpk

Source field pollId.

questionstring

Source field question.

poll_typestring

Source field pollType.

poll_follow_up_idstring

Source field pollFollowUpId.

id_responsesjson

Source field idResponses.

numeric_responsesjson

Source field numericResponses.

reset_atdatetime

Source field resetAt.

guide_namestring

Source field guideName.

guide_steps#

titan.pendo.guide_steps has 15 source columns.

pendo.guide_steps15 columns
guide_idstringpk

Source field guideId.

step_idstringpk

Source field stepId.

rankinteger

Source field rank.

typestring

Source field type.

advance_methodstring

Source field advanceMethod.

template_idstring

Source field templateId.

content_typestring

Source field contentType.

page_idstring

Source field pageId.

element_path_rulestring

Source field elementPathRule.

launch_urlstring

Source field launchUrl.

regex_url_rulestring

Source field regexUrlRule.

poll_idsjson

Source field pollIds.

attributesjson

Source field attributes.

last_updated_atdatetime

Source field lastUpdatedAt.

reset_atdatetime

Source field resetAt.

guide_events#

titan.pendo.guide_events has 31 source columns.

pendo.guide_events31 columns
visitor_idstringpk

Source field visitorId.

guide_idstringpk

Source field guideId.

guide_step_idstringpk

Source field guideStepId.

typestringpk

Source field type.

browser_timedatetimepk

Source field browserTime.

guide_timestampdatetimepk

Source field guideTimestamp.

analytics_session_idstringpk

Source field analyticsSessionId.

tab_idstringpk

Source field tabId.

account_idstring

Source field accountId.

account_idsjson

Source field accountIds.

app_idinteger

Source field appId.

destination_step_idstring

Source field destinationStepId.

guide_seen_reasonstring

Source field guideSeenReason.

guide_seen_timeout_lengthinteger

Source field guideSeenTimeoutLength.

guide_snooze_durationinteger

Source field guideSnoozeDuration.

received_timedatetime

Source field receivedTime.

countrystring

Source field country.

regionstring

Source field region.

latitudefloat

Source field latitude.

longitudefloat

Source field longitude.

remote_ipstring

Source field remoteIp.

server_namestring

Source field serverName.

user_agentstring

Source field userAgent.

urlstring

Source field url.

load_timeinteger

Source field loadTime.

element_pathstring

Source field elementPath.

ui_element_idstring

Source field uiElementId.

ui_element_textstring

Source field uiElementText.

ui_element_typestring

Source field uiElementType.

ui_element_actionsjson

Source field uiElementActions.

propertiesjson

Source field properties.

segments#

titan.pendo.segments has 14 source columns.

pendo.segments14 columns
idstringpk

Source field id.

namestring

Source field name.

descriptionstring

Source field description.

sharedboolean

Source field shared.

kindstring

Source field kind.

created_by_apiboolean

Source field createdByApi.

root_version_idstring

Source field rootVersionId.

stable_version_idstring

Source field stableVersionId.

created_atdatetime

Source field createdAt.

last_updated_atdatetime

Source field lastUpdatedAt.

created_by_userjson

Source field createdByUser.

last_updated_by_userjson

Source field lastUpdatedByUser.

definitionjson

Source field definition.

dependent_metadatajson

Source field dependentMetadata.

Deletes and history#

Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets _deleted so queries can choose whether to include history. Filter current-state queries with where not _deleted.