ETL HubSpot data to Snowflake

Manages individual contact records, including personal details, lifecycle stages, and engagement history. This endpoint is central for accessing and updating customer and lead information.

Handles company profiles, storing organizational data such as company name, domain, industry, and associated contacts. Useful for B2B relationship management and account-based marketing.

Tracks sales opportunities and pipeline stages, capturing deal properties like amount, stage, close date, and associations with contacts and companies. Essential for sales forecasting and performance analysis.

Manages customer support requests, including ticket status, priority, and associated contacts or companies. Enables tracking and resolution of customer issues.

Records interactions such as emails, calls, meetings, and tasks linked to contacts, companies, or deals. Provides a comprehensive activity history for sales and support teams.

Stores catalog information for products or services offered, including SKU, price, and description. Supports deal line items and revenue reporting.

Manages user accounts and ownership assignments across records, facilitating team collaboration and access control within HubSpot.