From Hubspot to Redshift: managed, scheduled, no code.
Creating a pipeline that sends data from Hubspot to Redshift data warehouses takes only a few minutes with Kondado. And the whole integration from Hubspot to Redshift is managed and executed by our platform. With Kondado, you can focus on extracting value from Hubspot data and combining it with other data in your Redshift data warehouse
How to send Hubspot data to Redshift? Kondado provides a direct integration that replicates your marketing, sales, and customer service data from Hubspot to your Amazon Redshift warehouse automatically. Configure your data replication to run on a schedule that fits your business needs, whether every 5 minutes or daily, without writing any code. Once connected, your Hubspot data source continuously updates your Redshift database with fresh information from contacts, deals, and engagement activities. Marketing analysts and data engineers use this automated pipeline to unify Hubspot metrics with other business data in Redshift, enabling comprehensive reporting across the entire customer journey. Build custom dashboards in Power BI, Looker Studio, or Google Sheets connected to your Redshift warehouse to visualize campaign performance alongside financial and operational data.
Kondado is a data integration platform that replicates data from Hubspot to Amazon Redshift on a configurable schedule, offering 24 pipelines including Companies, Contacts, Deals, and Email Events with 805 total fields available for analysis.
Available pipelines include Companies, Contacts, Deals, Email Events, and Engagements, giving you complete visibility into your marketing funnel and sales pipeline. Replicate your Contacts and Companies pipelines to Redshift to segment audiences based on lifecycle stage and firmographic data, then combine this information with Deals data to calculate conversion rates and revenue attribution by campaign source. With Email Events data in Redshift, marketing teams can analyze open rates, click-through patterns, and engagement trends across different customer segments using SQL queries to optimize future campaigns. This unified data foundation supports advanced analytics workflows, allowing you to join Hubspot engagement metrics with transactional data from PostgreSQL or BigQuery for complete customer intelligence.
Try out all the features for free for 14 days
Replicated to Redshift
Hubspot data available for Redshift
Tables Kondado writes into your Redshift, on a schedule you control.
24
available pipelines
805
extractable fields
Redshift
Destination
Available integrations
Companies
Includes information such as id, name, and properties related to contacts and deals.
Contact lists
Presents contact lists with details on membership and relevant properties.
Contacts
Brings contact information such as id, email, name, and created date.
Contacts: form submissions
Includes form submissions with fields such as conversion id, content type, and form id.
Contacts: lists membership
Displays the association of contacts to specific lists and their properties.
Custom object
Represents custom objects with fields such as id and specific properties.
Deals
Contains information about deals, including id, value, and related contacts.
Email events
Records email events with details on sending, opens, and clicks.
Engagements: Calls
Includes call details such as id, dispositions, and related objects.
Engagements: Emails
Presents email details including id and related objects.
Engagements: Meetings
This table contains information about meetings, including fields such as id, contact_id, company_id, and updated_at.
Engagements: Notes
Notes table includes fields such as id, contact_id, body, and created_at, allowing tracking of relevant information.
Engagements: Tasks
Tasks table presents fields such as id, contact_id, due_date, and status, facilitating activity management.
Feedback Submissions
Feedback submissions table includes fields such as id, contact_id, feedback_type, and created_at, allowing analysis of responses.
Leads
Leads table contains information such as id, email, status, and created_at, essential for managing potential customers.
Line Items
Line items table presents fields such as id, deal_id, product_id, and quantity, useful for tracking sales.
Marketing Emails
Marketing emails table includes fields such as id, subject, sent_date, and open_rate, allowing analysis of campaigns.
Owners
Owners table contains fields such as id, name, email, and created_at, essential for user management.
Payments
Payments table includes fields such as id, amount, payment_date, and status, useful for financial control.
Pipelines
Pipelines table presents fields such as id, name, stage, and created_at, important for sales management.
Products
Table contains information about products, including fields such as id, name, price, and description.
Properties Metadata
Table presents metadata of properties, including fields such as name, type, and description.
Property History
Table logs changes to properties, with fields such as id, created_at, and previous_value.
Tickets
Table includes information about tickets, with fields such as id, status, priority, and created_at.
Sync data automatically — no code, no manual exports.
1
Connect your Hubspot account
Authenticate your Hubspot data source in Kondado by entering your API credentials, allowing the platform to access your marketing, sales, and service data.
2
Configure Redshift destination
Enter your Amazon Redshift cluster connection details including host, database name, and credentials to establish the target warehouse where your Hubspot data will land.
3
Select pipelines and schedule
Choose which of the 24 available Hubspot pipelines to replicate, such as Contacts, Deals, or Email Events, then set your preferred update frequency from every 5 minutes to daily.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending Hubspot data to Redshift automatically
How does Hubspot to Redshift replication work on Kondado?▼
Kondado connects directly to your Hubspot account using API authentication to extract data from your selected pipelines. The platform then loads this information into your Amazon Redshift warehouse, automatically handling schema creation and data type mapping. Updates occur on your chosen schedule, appending new records and refreshing existing data to maintain accuracy.
What Hubspot data can I replicate to Redshift?▼
You can replicate 24 different pipelines including Contacts, Companies, Deals, Email Events, Marketing Emails, and various Engagement types such as Calls, Meetings, and Tasks. Each pipeline contains specific fields, totaling 805 available data points covering marketing activities, sales interactions, and customer service tickets. Select only the pipelines relevant to your analysis needs to optimize storage and query performance in Redshift.
How often does Kondado update Hubspot data in Redshift?▼
Kondado replicates data on a configurable schedule that you control, with options ranging from every 5 minutes to daily or weekly intervals. This flexibility allows marketing teams to access near-real-time campaign metrics while controlling compute costs in Redshift. You can modify the update frequency at any time based on your reporting requirements and data freshness needs.
Can I combine Hubspot data with other sources in Redshift?▼
Yes, Redshift serves as a central repository where Hubspot data can coexist alongside information from other platforms or databases. Join your Hubspot Contacts and Deals data with financial records from PostgreSQL or web analytics from BigQuery to create comprehensive customer views. This unified approach enables cross-functional analysis that connects marketing touchpoints to revenue outcomes.
What format does Hubspot data take in Redshift?▼
Each Hubspot pipeline becomes a separate table in your Redshift schema, preserving the original field names and data structures from your Hubspot account. Kondado automatically maps Hubspot data types to compatible Redshift formats, handling timestamps, text fields, and numerical values appropriately. The relational structure maintains referential integrity between related objects like Contacts, Companies, and Deals for seamless SQL querying.
Do I need coding skills to connect Hubspot to Redshift?▼
No coding is required to establish the connection, as Kondado provides a visual interface for authenticating your Hubspot account and configuring your Redshift destination. Simply enter your API credentials for Hubspot and database connection details for Redshift to begin replication immediately. The platform manages all technical aspects of data extraction, transformation, and loading automatically.
Can I filter which Hubspot pipelines replicate to Redshift?▼
Yes, you have complete control over which of the 24 available pipelines send data to your Redshift warehouse. Select specific pipelines like Contacts, Deals, or Email Events during setup, and add or remove pipelines later as your reporting needs evolve. This selective approach helps you manage storage costs in Redshift while ensuring only relevant marketing and sales data populates your analytics environment.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
