Snowflake Integration

Export your referral intelligence to a table in your own Snowflake account. After every enrichment job, Clustr upserts new and updated opportunities into the table, keeping your warehouse and BI tools current. It is a data export, not an OAuth app. You connect with key-pair auth: Clustr generates the key, you run one line in Snowflake, and Clustr only ever writes to the one table it manages.

Connecting Snowflake is admin-only, under Integrations, Apps, Snowflake in the dashboard.

Connect Snowflake

Have your Snowsight URL and a Snowflake username ready, then run the four-step wizard.

Enter your account and user

Open Snowsight and copy the address from your browser, for example app.snowflake.com/tsyqtjr/kt32003. Paste it into Clustr, enter the username Clustr should sign in as, and click Continue. A dedicated service user is recommended.

Authorize with a key pair

Clustr generates a key pair and shows one statement. Run it once in a Snowflake worksheet as an admin:

ALTER USER YOUR_USER SET RSA_PUBLIC_KEY='...';

Click I’ve run it. Clustr keeps the private key. Only the public key is shared.

New Snowflake accounts block password sign-in for drivers, so Clustr uses key-pair auth. No password is ever stored.

Pick your destination

Choose a warehouse and database from the dropdowns, then pick an existing schema or create a new one (defaults to EXPORTS). Click Continue.

Connect and sync

Review the destination and click Connect to save the connection and run the first full export. Clustr writes to <database>.<schema>.clustr_referral_paths.

After the initial sync, Clustr pushes new and updated opportunities at the end of every enrichment job automatically.

How It Works

Clustr writes a single table, <schema>.clustr_referral_paths, one flat, denormalized row per opportunity. Rows are upserted on id with a MERGE, so re-syncing never duplicates, and a full sync also removes opportunities that no longer exist in Clustr. Because it is keyed and idempotent, the table is safe to query live, build views on, or point a BI dashboard at.

Settings

The Snowflake panel shows connection status and sync controls.

Control	Description
Connection status	Destination account, `<database>.<schema>.clustr_referral_paths`, and last sync time.
Auto-sync	Every enrichment job upserts new/updated opportunities automatically.
Sync now	Trigger a manual full sync on demand.
Sync history	Recent export runs with status and row counts.
Disconnect	Removes the saved connection and stops syncs. Data already in Snowflake is not affected. Reconnect anytime.

Table Schema

clustr_referral_paths is keyed on id (used for upserts); all other data fields are stored as text so the export never fails on type coercion. Full column reference:

Keys & metadata

Column	Description
`id`	Opportunity ID (primary key)
`tenant_id`	Your Clustr tenant ID
`exported_at`	When the row was last written
`source_app`	Always `clustr`

Contact (client)

Column	Description
`contact_first_name`	Connector’s first name
`contact_last_name`	Connector’s last name
`contact_job_title`	Connector’s job title
`contact_company`	Connector’s company
`contact_linkedin_url`	Connector’s LinkedIn URL
`contact_linkedin_urn`	Connector’s LinkedIn URN, the stable member identifier (e.g. `ACoAA…`). Empty when not available.
`contact_tags`	Tags on the contact
`contact_in_crm`	Whether the contact exists in your CRM
`contact_crm_id`	The contact’s record ID in your CRM. Empty when not matched.
`contact_crm_provider`	Which CRM the ID is from (`hubspot`, `salesforce`, or `attio`)
`contact_associated_deals`	Deals associated with the contact
`contact_associated_deal_stage`	Stage of associated deals
`contact_recent_activities`	Recent CRM activity

Relationship quality

Column	Description
`relationship_quality_score_pct`	Confidence score for the referral path (%)

Prospect

Column	Description
`prospect_first_name`	Prospect’s first name
`prospect_last_name`	Prospect’s last name
`prospect_seniority_level`	Prospect’s seniority
`prospect_profile_headline`	Prospect’s profile headline
`prospect_job_title`	Prospect’s job title
`prospect_linkedin_url`	Prospect’s LinkedIn URL
`prospect_linkedin_urn`	Prospect’s LinkedIn URN, the stable member identifier (e.g. `ACoAA…`). Empty when not available.
`prospect_in_crm`	Whether the prospect exists in your CRM
`prospect_crm_id`	The prospect’s record ID in your CRM. Empty when not matched.
`prospect_crm_provider`	Which CRM the ID is from (`hubspot`, `salesforce`, or `attio`)
`prospect_associated_deals`	Deals associated with the prospect
`prospect_associated_deal_stage`	Stage of associated deals
`prospect_recent_activities`	Recent CRM activity

Prospect company

Column	Description
`prospect_company_name`	Company name
`prospect_company_linkedin_url`	Company LinkedIn URL
`prospect_company_linkedin_numeric_id`	Company LinkedIn numeric ID
`prospect_company_linkedin_vanity_name`	Company LinkedIn vanity name
`prospect_company_crm_id`	The company’s record ID in your CRM. Empty when not matched.
`prospect_company_crm_provider`	Which CRM the ID is from (`hubspot`, `salesforce`, or `attio`)
`prospect_company_domain`	Company domain
`prospect_company_industry`	Company industry
`prospect_company_size`	Company size
`prospect_company_revenue`	Company revenue
`prospect_country`	Prospect’s country

Engagement

Column	Description
`last_engagement_type`	Type of the most recent engagement
`last_engagement_url`	Link to the engagement
`last_engagement_context_url`	Link to the engagement context
`last_engagement_date`	Date of the most recent engagement
`total_engagements_found`	Total engagements found
`full_engagement_history`	Full engagement history

Shared experience

Column	Description
`common_company`	Company shared by contact and prospect
`overlap_in_months`	Months of overlap at the shared company
`shared_experience_company`	Shared experience company
`shared_education_institution`	Shared education institution
`shared_education_overlap_months`	Months of overlap in education

Troubleshooting

Problem	What to do
Snowflake rejected the key	Run the `ALTER USER ... SET RSA_PUBLIC_KEY` line from the Authorize step, on the same user you entered, then retry.
Database not found	Pick a database the user’s role can access, or grant it access.
Warehouse not found or suspended	Pick a warehouse the role can use, or resume it in Snowflake.
Invalid credentials	Check the username and the Snowsight URL you pasted.
Table shape mismatch	A `clustr_referral_paths` table with incompatible columns already exists. Pick a different schema, or drop it and reconnect.
An export is already running	Wait for the in-flight sync to finish before starting another.

Getting Started

Competitor Monitoring

Integrations

Snowflake Integration

Connect Snowflake

How It Works

Settings

Table Schema

Troubleshooting

​Connect Snowflake

​How It Works

​Settings

​Table Schema

​Troubleshooting

Connect Snowflake

How It Works

Settings

Table Schema

Troubleshooting