Transformation Postgres existing data

Hi everybody.

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?