--- title: Pendo description: Connect Pendo, understand its sync behavior, and query every table and column it writes. species: reference --- # 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](/v2/docs/concepts/your-lake#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. ```columns table=pendo.page_events page_id string pk Source field `pageId`. account_id string pk Source field `accountId`. app_id integer pk Source field `appId`. visitor_id string pk Source field `visitorId`. hour datetime pk Source field `hour`. num_events integer Source field `numEvents`. num_minutes integer Source field `numMinutes`. first_time datetime pk Source field `firstTime`. last_time datetime pk Source field `lastTime`. remote_ip string pk Source field `remoteIp`. server string pk Source field `server`. user_agent string pk Source field `userAgent`. recording_id string pk Source field `recordingId`. tab_id string pk Source field `tabId`. analytics_session_id string pk Source field `analyticsSessionId`. recording_session_id string pk Source field `recordingSessionId`. error_click_count integer Source field `errorClickCount`. dead_click_count integer Source field `deadClickCount`. u_turn_count integer Source field `uTurnCount`. rage_click_count integer Source field `rageClickCount`. longitude float pk Source field `longitude`. latitude float pk Source field `latitude`. region string pk Source field `region`. country string pk Source field `country`. ``` ### `feature_events` `titan.pendo.feature_events` has 24 source columns. ```columns table=pendo.feature_events feature_id string pk Source field `featureId`. account_id string pk Source field `accountId`. app_id integer pk Source field `appId`. visitor_id string pk Source field `visitorId`. hour datetime pk Source field `hour`. num_events integer Source field `numEvents`. num_minutes integer Source field `numMinutes`. first_time datetime pk Source field `firstTime`. last_time datetime pk Source field `lastTime`. remote_ip string pk Source field `remoteIp`. server string pk Source field `server`. user_agent string pk Source field `userAgent`. recording_id string pk Source field `recordingId`. tab_id string pk Source field `tabId`. analytics_session_id string pk Source field `analyticsSessionId`. recording_session_id string pk Source field `recordingSessionId`. error_click_count integer Source field `errorClickCount`. dead_click_count integer Source field `deadClickCount`. u_turn_count integer Source field `uTurnCount`. rage_click_count integer Source field `rageClickCount`. longitude float pk Source field `longitude`. latitude float pk Source field `latitude`. region string pk Source field `region`. country string pk Source field `country`. ``` ### `events` `titan.pendo.events` has 24 source columns. ```columns table=pendo.events page_id string pk Source field `pageId`. account_id string pk Source field `accountId`. app_id integer pk Source field `appId`. visitor_id string pk Source field `visitorId`. hour datetime pk Source field `hour`. num_events integer Source field `numEvents`. num_minutes integer Source field `numMinutes`. first_time datetime pk Source field `firstTime`. last_time datetime pk Source field `lastTime`. remote_ip string pk Source field `remoteIp`. server string pk Source field `server`. user_agent string pk Source field `userAgent`. recording_id string pk Source field `recordingId`. tab_id string pk Source field `tabId`. analytics_session_id string pk Source field `analyticsSessionId`. recording_session_id string pk Source field `recordingSessionId`. error_click_count integer Source field `errorClickCount`. dead_click_count integer Source field `deadClickCount`. u_turn_count integer Source field `uTurnCount`. rage_click_count integer Source field `rageClickCount`. longitude float pk Source field `longitude`. latitude float pk Source field `latitude`. region string pk Source field `region`. country string pk Source field `country`. ``` ### `track_events` `titan.pendo.track_events` has 24 source columns. ```columns table=pendo.track_events track_type_id string pk Source field `trackTypeId`. account_id string pk Source field `accountId`. app_id integer pk Source field `appId`. visitor_id string pk Source field `visitorId`. hour datetime pk Source field `hour`. num_events integer Source field `numEvents`. num_minutes integer Source field `numMinutes`. first_time datetime pk Source field `firstTime`. last_time datetime pk Source field `lastTime`. remote_ip string pk Source field `remoteIp`. server string pk Source field `server`. user_agent string pk Source field `userAgent`. recording_id string pk Source field `recordingId`. tab_id string pk Source field `tabId`. analytics_session_id string pk Source field `analyticsSessionId`. recording_session_id string pk Source field `recordingSessionId`. error_click_count integer Source field `errorClickCount`. dead_click_count integer Source field `deadClickCount`. u_turn_count integer Source field `uTurnCount`. rage_click_count integer Source field `rageClickCount`. longitude float pk Source field `longitude`. latitude float pk Source field `latitude`. region string pk Source field `region`. country string pk Source field `country`. ``` ### `pages` `titan.pendo.pages` has 21 source columns. ```columns table=pendo.pages id string pk Source field `id`. created_by_user json Source field `createdByUser`. last_updated_by_user json Source field `lastUpdatedByUser`. created_at datetime Source field `createdAt`. last_updated_at datetime Source field `lastUpdatedAt`. kind string Source field `kind`. root_version_id string Source field `rootVersionId`. stable_version_id string Source field `stableVersionId`. app_id integer Source field `appId`. app_ids json Source field `appIds`. name string Source field `name`. group json Source field `group`. is_core_event boolean Source field `isCoreEvent`. valid_through datetime Source field `validThrough`. dirty boolean Source field `dirty`. daily_merge_first integer Source field `dailyMergeFirst`. daily_rollup_first integer Source field `dailyRollupFirst`. ignored_frustration_types json Source field `ignoredFrustrationTypes`. rules json Source field `rules`. rulesjson string Source field `rulesjson`. is_suggested boolean Source field `isSuggested`. ``` ### `features` `titan.pendo.features` has 23 source columns. ```columns table=pendo.features id string pk Source field `id`. page_id string pk Source field `pageId`. event_property_configurations json Source field `eventPropertyConfigurations`. element_path_rules json Source field `elementPathRules`. element_selection_type string Source field `elementSelectionType`. suggested_match_type string Source field `suggestedMatchType`. app_wide boolean Source field `appWide`. created_by_user json Source field `createdByUser`. last_updated_by_user json Source field `lastUpdatedByUser`. created_at datetime Source field `createdAt`. last_updated_at datetime Source field `lastUpdatedAt`. kind string Source field `kind`. root_version_id string Source field `rootVersionId`. stable_version_id string Source field `stableVersionId`. app_id integer Source field `appId`. app_ids json Source field `appIds`. name string Source field `name`. group json Source field `group`. is_core_event boolean Source field `isCoreEvent`. valid_through datetime Source field `validThrough`. dirty boolean Source field `dirty`. daily_merge_first integer Source field `dailyMergeFirst`. daily_rollup_first integer Source field `dailyRollupFirst`. ``` ### `visitors` `titan.pendo.visitors` has 2 source columns. ```columns table=pendo.visitors visitor_id string pk Source field `visitorId`. metadata json Source field `metadata`. ``` ### `guides` `titan.pendo.guides` has 48 source columns. ```columns table=pendo.guides id string pk Source field `id`. name string Source field `name`. state string Source field `state`. kind string Source field `kind`. launch_method string Source field `launchMethod`. editor_type string Source field `editorType`. authored_language string Source field `authoredLanguage`. email_state string Source field `emailState`. is_multi_step boolean Source field `isMultiStep`. is_module boolean Source field `isModule`. is_top_level boolean Source field `isTopLevel`. is_training boolean Source field `isTraining`. is_dnt boolean Source field `isDNT`. auto_create_feedback boolean Source field `autoCreateFeedback`. include_for_oem boolean Source field `includeForOEM`. published_ever boolean Source field `publishedEver`. app_id integer Source field `appId`. app_ids json Source field `appIds`. resource_center_id string Source field `resourceCenterId`. origin_id string Source field `originId`. root_version_id string Source field `rootVersionId`. stable_version_id string Source field `stableVersionId`. recurrence integer Source field `recurrence`. recurrence_eligibility_window integer Source field `recurrenceEligibilityWindow`. created_at datetime Source field `createdAt`. last_updated_at datetime Source field `lastUpdatedAt`. published_at datetime Source field `publishedAt`. expires_after datetime Source field `expiresAfter`. reset_at datetime Source field `resetAt`. current_first_eligible_to_be_seen_at datetime Source field `currentFirstEligibleToBeSeenAt`. created_by_user_id string Source field `createdByUserId`. created_by_username string Source field `createdByUsername`. last_updated_by_user_id string Source field `lastUpdatedByUserId`. last_updated_by_username string Source field `lastUpdatedByUsername`. device_type string Source field `deviceType`. segment_id string Source field `segmentId`. created_by_user json Source field `createdByUser`. last_updated_by_user json Source field `lastUpdatedByUser`. attributes json Source field `attributes`. audience json Source field `audience`. audience_ui_hint json Source field `audienceUiHint`. steps json Source field `steps`. children json Source field `children`. polls json Source field `polls`. redisplay json Source field `redisplay`. conversion json Source field `conversion`. shows_after json Source field `showsAfter`. dependent_metadata json Source field `dependentMetadata`. ``` ### `resource_center` `titan.pendo.resource_center` has 11 source columns. ```columns table=pendo.resource_center guide_id string pk Source field `guideId`. name string Source field `name`. state string Source field `state`. module_id string Source field `moduleId`. is_top_level boolean Source field `isTopLevel`. origin_id string Source field `originId`. children json Source field `children`. resource_center_id string Source field `resourceCenterId`. app_id integer Source field `appId`. created_at datetime Source field `createdAt`. last_updated_at datetime Source field `lastUpdatedAt`. ``` ### `guide_polls` `titan.pendo.guide_polls` has 9 source columns. ```columns table=pendo.guide_polls guide_id string pk Source field `guideId`. poll_id string pk Source field `pollId`. question string Source field `question`. poll_type string Source field `pollType`. poll_follow_up_id string Source field `pollFollowUpId`. id_responses json Source field `idResponses`. numeric_responses json Source field `numericResponses`. reset_at datetime Source field `resetAt`. guide_name string Source field `guideName`. ``` ### `guide_steps` `titan.pendo.guide_steps` has 15 source columns. ```columns table=pendo.guide_steps guide_id string pk Source field `guideId`. step_id string pk Source field `stepId`. rank integer Source field `rank`. type string Source field `type`. advance_method string Source field `advanceMethod`. template_id string Source field `templateId`. content_type string Source field `contentType`. page_id string Source field `pageId`. element_path_rule string Source field `elementPathRule`. launch_url string Source field `launchUrl`. regex_url_rule string Source field `regexUrlRule`. poll_ids json Source field `pollIds`. attributes json Source field `attributes`. last_updated_at datetime Source field `lastUpdatedAt`. reset_at datetime Source field `resetAt`. ``` ### `guide_events` `titan.pendo.guide_events` has 31 source columns. ```columns table=pendo.guide_events visitor_id string pk Source field `visitorId`. guide_id string pk Source field `guideId`. guide_step_id string pk Source field `guideStepId`. type string pk Source field `type`. browser_time datetime pk Source field `browserTime`. guide_timestamp datetime pk Source field `guideTimestamp`. analytics_session_id string pk Source field `analyticsSessionId`. tab_id string pk Source field `tabId`. account_id string Source field `accountId`. account_ids json Source field `accountIds`. app_id integer Source field `appId`. destination_step_id string Source field `destinationStepId`. guide_seen_reason string Source field `guideSeenReason`. guide_seen_timeout_length integer Source field `guideSeenTimeoutLength`. guide_snooze_duration integer Source field `guideSnoozeDuration`. received_time datetime Source field `receivedTime`. country string Source field `country`. region string Source field `region`. latitude float Source field `latitude`. longitude float Source field `longitude`. remote_ip string Source field `remoteIp`. server_name string Source field `serverName`. user_agent string Source field `userAgent`. url string Source field `url`. load_time integer Source field `loadTime`. element_path string Source field `elementPath`. ui_element_id string Source field `uiElementId`. ui_element_text string Source field `uiElementText`. ui_element_type string Source field `uiElementType`. ui_element_actions json Source field `uiElementActions`. properties json Source field `properties`. ``` ### `segments` `titan.pendo.segments` has 14 source columns. ```columns table=pendo.segments id string pk Source field `id`. name string Source field `name`. description string Source field `description`. shared boolean Source field `shared`. kind string Source field `kind`. created_by_api boolean Source field `createdByApi`. root_version_id string Source field `rootVersionId`. stable_version_id string Source field `stableVersionId`. created_at datetime Source field `createdAt`. last_updated_at datetime Source field `lastUpdatedAt`. created_by_user json Source field `createdByUser`. last_updated_by_user json Source field `lastUpdatedByUser`. definition json Source field `definition`. dependent_metadata json 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`.