Structured or scalar, your choice
Compound attributes land as VARIANT, and each one also exposes flat subfields you can select instead.
Replicate Attio into Snowflake with Polytomic so CRM records sit alongside product and billing data. Attio's compound attributes arrive both as structured VARIANT columns and as ready made scalar subfields, so you can query a person's last name without unpacking JSON.
Compound attributes land as VARIANT, and each one also exposes flat subfields you can select instead.
A derived stage history table carries validity periods, so pipeline velocity is reportable in SQL.
Standard and custom objects are read live from your workspace, and each list becomes its own table.

Jonathan Krangel
VP Global Head of Revenue Operations
“Polytomic handles so many ETL and sync jobs at Cursor. They are a true partner to us.”
Follow these simple steps to connect Attio with Snowflake in minutes
Connect Attio
Connect Snowflake
Create sync
Enable sync
Connect Attio to Polytomic with OAuth and grant access to the objects you want to sync.
Connect Snowflake to Polytomic with account details, a role, a warehouse, and credentials.
Sync data in either direction between Attio and Snowflake. Choose the source data and destination objects for the direction you need.
Map the fields, choose the sync schedule and behavior, then save and enable the sync.
Get answers to common questions about the integration process
Sync data in either direction between Attio and Snowflake.
Use both integrations' source and destination capabilities in one managed sync workflow.
Enterprise encryption and security protocols ensure your data remains protected.
Get up and running in minutes with our step-by-step integration guide.