Use this article to connect your Intercom workspace to Snowflake, configure your data share, and query your conversation data directly. Snowflake Secure Data Sharing eliminates the need to build or maintain ETL (extract, transform, load) pipelines to load exported files into Snowflake, making it easier to analyze your Intercom data alongside the rest of your data warehouse.
Who can use Snowflake Data Sharing?
Snowflake Data Sharing is:
Available to workspaces with access to the feature.
Configurable by teammates with the Can manage workspace data permission.
Available for Snowflake accounts hosted on AWS. Snowflake accounts in other AWS regions are supported through Snowflake Auto-Fulfillment — a feature that automatically replicates shared data to your account's region.
What you need before setting up Snowflake Data Sharing
Before configuring Snowflake Data Sharing, make sure you have:
A Snowflake account.
Your Snowflake Data Sharing Account Identifier in the format
<organization>.<account>.An Intercom teammate with the Can manage workspace data permission.
To find your Snowflake account identifier:
Sign in to your Snowflake account.
Select your account name in the lower-left corner.
Choose Account.
Under Account Details, locate Data Sharing Account Identifier.
Copy the identifier and enter it into Intercom. It should be in the format
<organization>.<account>.
Note: If your Snowflake account is hosted outside the AWS region where your Intercom workspace is hosted, Snowflake automatically uses Auto-Fulfillment to securely replicate the shared data to your account region. No additional configuration is required.
How to configure Snowflake Data Sharing
In Intercom, go to Settings > Data > Imports & exports > Snowflake data sharing.
Click New Snowflake Data Share.
Enter your Snowflake Data Sharing Account Identifier.
Select how often your data should be refreshed:
Hourly
Daily
(Optional) Enable Export historical data for the last two years to backfill historical conversation data.
Click Create share.
Check your email and click the confirmation link to activate the data share. Once confirmed, Intercom provisions the data share and your data becomes available in Snowflake after the next scheduled export.
Note: No data is shared until the confirmation email has been verified.
Once confirmed, Intercom provisions the data share. Your data will become available in Snowflake after the next scheduled export.
How to access your shared data in Snowflake
Once your data share is confirmed and active, use the following SQL commands to locate, import, and query your Intercom conversation data in Snowflake.
1. Locate the shared listing
Run the following SQL to find the Intercom listing:
SHOW AVAILABLE LISTINGS IS_SHARED_WITH_ME = TRUE;
SELECT "global_name", "title", "profile", "is_ready_for_import" FROM TABLE(RESULT_SCAN(LAST_QUERY_ID())) WHERE "title" = 'Intercom Conversations Export' AND "profile" LIKE 'PEOSZPH.INTERCOM_DATA_SHARING_%';
Copy the value returned in the global_name column.
2. Request the listing and create the database
Replace <global_name> with the value from the previous step.
CALL SYSTEM$REQUEST_LISTING_AND_WAIT('<global_name>');
CREATE DATABASE INTERCOM_CONVERSATIONS FROM LISTING '<global_name>';The SYSTEM$REQUEST_LISTING_AND_WAIT procedure requests access to the listing and waits until it is ready to be imported.
3. Verify the database and query your conversations
DESC DATABASE INTERCOM_CONVERSATIONS;
Each workspace is exposed through its own schema:
SELECT * FROM INTERCOM_CONVERSATIONS.APP_<numeric_id>.CONVERSATIONS;
Replace <numeric_id> with your Intercom workspace ID.
What to expect after setting up Snowflake Data Sharing
After setup:
Your historical export (if selected) is processed first.
New and updated conversations are shared automatically according to your selected refresh schedule.
Conversation deletions are automatically propagated to Snowflake.
Your shared data remains up to date without any additional configuration.
Current limitations of Snowflake Data Sharing
Snowflake Data Sharing currently has the following limitations:
Snowflake Data Sharing currently supports conversation data.
You can choose either hourly or daily refreshes.
Historical exports are limited to the previous two years.
Data is not shared until the administrator confirms the verification email.
Changes to the destination Snowflake account require creating a new data share.
Troubleshooting Snowflake Data Sharing
I don't see any data in Snowflake
Data becomes available after the next scheduled export following email confirmation. Historical exports may take longer depending on the amount of data being processed.
I can't configure Snowflake Data Sharing
Ensure you have the Can manage workspace data permission in Intercom.
Where can I find my Snowflake account identifier?
In Snowflake, navigate to Account Details and copy the Data Sharing Account Identifier.
My Snowflake account is in another AWS region
Nothing extra is required. Snowflake automatically uses Auto-Fulfillment to replicate the shared data into your account's region.
Can I use Snowflake Data Sharing together with Cloud Storage Export?
Yes. Snowflake Data Sharing and Cloud Storage Export are configured independently and can be used at the same time.
Related articles
Need more help? Get support from our Community Forum
Find answers and get help from Intercom Support and Community Experts