I’ve pulled data from Hubspot to Postgres DB using AirByte and want to transform next areas:
- convert IDs from string to bigint
- create and synchronize association tables (deals<->contacts, companies<->contacts)
I’ve seen that AirByte supports dbt. So I believe it will run my project after data pull step. I tried sample models in dbt.
Is dbt fits for this purpose? What kind of models should I use to implement features described above?