Snowflake

Sync your Pylon support data into your Snowflake warehouse.
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

Pipe Pylon data directly into your Snowflake warehouse so you can query it next to your product, revenue, and customer data in one place.

Keep your warehouse continuously up to date

Set up a Warehouse Sync that writes Pylon data into a Snowflake table automatically with the correct schema created for you.

Control exactly where data lands

Point the sync at a specific warehouse, database, schema, and table so Pylon data lives exactly where your team expects it.

Authenticate securely with key-pair auth

Connect using an RSA key pair and a dedicated Snowflake user and role, so Pylon only ever touches the database you grant it access to.

How to install
Step 1
Generate a Snowflake key pair

Following Snowflake's key-pair auth guide, generate an unencrypted RSA private key and its associated public key.

Step 2
Assign the public key to a Snowflake user

Assign the public key to the Snowflake user Pylon will authenticate as. We recommend creating a new role with access to only the database you plan to use with Pylon, then granting that role to the authenticating user.

Step 3
Install the Snowflake app in Pylon

Install the Snowflake app from the Apps Directory. You'll need your Account Identifier (in the form <organization_name>-<account_name>), the Snowflake login name of the user tied to the public key, and the full private key including its header and footer lines.

Step 4
Test the connection

Once the connection is tested and validated, you're ready to create a Warehouse Sync.

Step 5
Create a Warehouse Sync

Once the connection is tested and validated, you're ready to create a Warehouse Sync. Configure the sync with your database, schema, and table (Pylon creates the table with the proper schema automatically). Optionally specify a warehouse and a role with write access. We recommend creating a dedicated database, schema, and role for Pylon data.

Frequently asked questions
How do I set up key-pair authentication for Snowflake?

Generate an unencrypted RSA private key and associated public key, assign the public key to your Snowflake user, and provide Pylon with the full private key including the header and footer lines. Once the connection is tested and validated, you can create a Warehouse Sync. If you previously used password authentication, you'll need to disconnect and reconnect the Snowflake app from the App Directory.

Can I push external data from Snowflake back into Pylon?

Yes, using a Reverse ETL tool. Tools like Hightouch or Census can sync data from your Snowflake tables into Pylon Account fields via the Pylon API. You set up a data source (your Snowflake database), a model (a SQL query), and a destination (the Pylon API), then configure the sync to trigger when rows are added or updated. All usage data synced this way is written into Pylon as Account fields, which can then be used for filtering, sorting, and customer success workflows.

What data does Pylon sync to Snowflake?

Pylon syncs customer issue data directly into your warehouse without any engineering effort. You can select the specific data columns you care about, set a sync cadence, and data will automatically be upserted; new records are inserted as new rows, and updated records replace existing rows.

What are the recommended Snowflake settings when setting up the Warehouse Sync?

Pylon recommends creating a new database and schema within your Snowflake account to store Pylon data. For best practice in access control, create a new role with access only to that database and grant that role to the authenticating user. When configuring the sync, you'll specify the warehouse used to write data, the database, the schema, the role, and the table name. Pylon will automatically create the table with the proper schema.

How do I connect Snowflake to Pylon?

Install the Snowflake app from the Pylon App Directory. You'll need your Snowflake Account Identifier, the login name of the authenticating user, and the generated RSA private key.

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.