What steps are required to map custom deal properties from HubSpot into our Snowflake data warehouse without breaking incremental dbt models?
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
What steps are required to map custom deal properties from HubSpot into our Snowflake data warehouse without breaking incremental dbt models?
2 real searches · 1 real-search pass
Badge and edge weight = share of passes that produced the query. Hover a query for its intent and routing format.
Query classes
Google's semantic query class for every sub-query: what kind of answer each search is after, simulated vs real.
ChatGPT real searches (2)
Classes come from the query-classifier (a local Laya model). 2 of 2 calls are low-confidence (under 50%) — hover a query in the table to see its confidence.
Searches and sources
ChatGPT2 real searches · gpt-6
HubSpot CRM API deal properties custom properties propertiesWithHistory documentation dbt incremental models schema changes on_schema_change documentation Snowflake Google ↗
Fivetran HubSpot connector custom deal properties schema refresh documentation Google ↗
- Configure incremental models · docs.getdbt.com
- dbt_hubspot/README.md at main · fivetran/dbt_hubspot · github.com
- dbt Docs · fivetran.github.io
- Choosing incremental models or snapshots · docs.getdbt.com
- Clone incremental models as the first step of your CI job · docs.getdbt.com
Queries
2 queries · click a column to sort
| Query / type | Search | Intent | Query class | Routing format | Cluster | Freq ↓ | Weight |
|---|---|---|---|---|---|---|---|
HubSpot CRM API deal properties custom properties propertiesWithHistory documentation dbt incremental models schema changes on_schema_change documentation Snowflake OBSERVED | Google ↗ AI Mode ↗ | — | Instruction | — | — | 1x of 1 | |
Fivetran HubSpot connector custom deal properties schema refresh documentation OBSERVED | Google ↗ AI Mode ↗ | — | Instruction | — | — | 1x of 1 |