BigQuery

Sync your Pylon customer issue data into BigQuery.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Trusted by 1,500+ B2B customers globally
Why teams use it

Deploy AI agents that handle questions end-to-end, gather context for your team, and escalate to humans when it matters.

Analyze support data alongside the rest of your business

Pylon writes your customer issue data into a BigQuery table so you can query it next to your product, revenue, and usage data in the warehouse you already run.

Skip the schema setup

Pylon automatically creates the destination table with the proper schema, so your issue data lands query-ready without manual modeling.

Keep support data in your own project

Data is written into a dataset and project you control, letting you house Pylon customer issue data wherever it fits your existing BigQuery structure.

How to install
Step 1
Open the data warehouse apps section

In Pylon, head to the data warehouse app section and select the BigQuery app to connect it. We recommend creating a new dataset to house your Pylon customer issue data — you can also create a new project or use an existing one.

Step 2
Create a service account key

In Google Cloud, create a service account key for your account and upload the Key File JSON when configuring the connection.

Step 3
Enter your project and dataset details

Provide your Project ID and a Dataset ID (create the dataset where Pylon data will be housed). Optionally set the Location where the dataset lives.

Step 4
Set the table ID

Enter the Table ID for the table data will be written to. Pylon automatically creates this table for you with the proper schema.

Step 5
Test the connection

Once all details are entered, hit test to verify your connection.

Frequently asked questions
How do I connect BigQuery to Pylon?

Navigate to the data warehouse app section inside Pylon and connect the BigQuery app. You'll need a Key File JSON, your Project ID, a Dataset ID where Pylon data will be housed, and a Table ID. An optional Location field lets you specify where the dataset is stored. Pylon will automatically create the table with the proper schema.

Do I need to create a new BigQuery project and dataset or can I use existing ones?

You can create a new Project or use an existing one. Pylon recommends creating a new dedicated dataset to house your Pylon customer issue data to keep it organized.  The table itself does not need to be created in advance. Pylon generates it automatically once the connection is validated.

What types of customer data can I analyze once it's in BigQuery?

There are three primary use cases for synced product data: viewing usage data in the issue sidebar for context when responding to customer issues, creating worklists in Pylon with usage data as columns, and feeding account data into custom account management notebooks. The data can also be joined with other warehouse data for deeper reporting and analytics.

Can Pylon write data back into BigQuery after I've already exported to it?

The warehouse sync is a one-way export from Pylon to BigQuery. Data will automatically be upserted into your warehouse. New records are inserted as new rows. And updated records replace existing rows. New data columns can be subscribed to as they become available.

What other warehouse destinations does Pylon support besides BigQuery?

In addition to BigQuery, Pylon supports Snowflake, Redshift, and AWS S3 for warehouse sync. All use the same no-code setup and upsert logic; the difference is simply in the credentials and connection details required for each provider.

Other integrations

Pylon connects with the tools your team lives in — Slack, email, CRMs, ticketing systems,and more. Meet your customers where they are and streamline every support workflow.

Telegram

Receive and respond to customer messages from Telegram

Slack

Manage B2B support directly in Slack channels alongside your team.

Granola

Connect Pylon to Granola to ingest call recordings

Outlook Calendar

Sync Outlook Calendar meetings to customer records in Pylon

Google Meet

Automatically capture and log Google Meet call notes to Pylon

Incident.io

Automcatically link active incidents to affected customer conversations.

Redshift

Enrich customer records with usage data from Amazon Redshift.

Shortcut

Create Shortcut stories from customer conversations automatically

PagerDuty

Trigger PagerDuty incidents from critical customer-reported issues.