Yes, you can connect Pendo as a source and Google BigQuery as a destination using Airbyte. Here's a summary of how to set it up:
Pendo → BigQuery via Airbyte 1. Set Up Pendo as a Source You'll need a Pendo API key. To generate one: [
Pendo source docs]
1. Log in to Pendo as an Admin and go to
Integrations → Integration Keys.
2. Click
Add Integration Key, give it a description, and click
Create.
3. Copy the generated API key.
Then in Airbyte:
• Go to
Sources → + New source, select
Pendo, and enter your API key.
The Pendo connector supports the following streams (Full Refresh only): [
Pendo source docs]
• Page
• Feature
• Report
• Guide
• Account Metadata
• Visitor Metadata
2. Set Up BigQuery as a Destination • Go to
Destinations → + New destination, select
BigQuery.
• Provide your GCP
Project ID,
Dataset ID,
Dataset Location, and
Service Account Key JSON.
3. Create a Connection • Go to
Connections → + New connection.
• Select your Pendo source and BigQuery destination.
• Configure sync frequency and stream settings, then click
Set up connection.
This works on both
Airbyte Cloud and
Airbyte Open Source. [
Pendo source docs]
>
Note: The Pendo connector is currently in
alpha and at
community support level. The aggregation/events endpoints are not yet supported, but there is an active feature request to add them. [
GitHub discussion] 👍 0 button 👎 0 button ℹ️
Tip: Mention
@kapa.ai in the thread for follow-ups or
DM the app for
1-to-1 help.