)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
HubSpot custom objects and properties add complexity to Snowflake Data Share views, requiring schema modifications and view updates whenever new properties are added. Managing these changes manually slows down data access and requires ongoing SQL maintenance.
Here’s how to work with HubSpot custom objects without the complexity of maintaining SQL views.
Access custom objects automatically using Coefficient
CoefficientHubSpotprovides automatic detection and import of allcustom objects (except Marketing Events, Marketing Emails, and Deal Splits). The system includes full support for custom properties on both standard and custom objects, with a dynamic field selection interface that updates as new properties are added.
You get zero-configuration access to custom objects with no schema modifications required when properties change. The system handles associations automatically and provides real-time schema updates so new custom properties are immediately available.
How to make it work
Step 1. Connect to HubSpot and access custom objects automatically.
Open Coefficient’s sidebar and connect to HubSpot. Your custom objects will appear automatically in the import menu without any configuration or SQL view creation required.
Step 2. Select custom properties through the visual interface.
Choose specific custom properties using checkboxes rather than writing SELECT statements. The interface shows all available custom properties and updates automatically when new ones are added in HubSpot.
Step 3. Configure associations for related custom object data.
Set up associations between custom objects and standard HubSpot objects using the built-in association options. Choose Primary, Comma Separated, or Row Expanded formats based on how you want to view related data.
Step 4. Apply filters using custom property values.
Use custom property values in your filter conditions to focus on specific data subsets. The system supports up to 25 filter conditions across custom and standard properties without complex WHERE clause syntax.
Start working with custom objects today
Get started with CoefficientCoefficient eliminates the complexity of maintaining SQL views for HubSpot custom objects while providing more flexible access to custom data structures.to access your custom objects immediately without SQL expertise.
