# Transformation Postgres existing data

**URL:** <https://discourse.getdbt.com/t/transformation-postgres-existing-data/7106>\
**Category:** Help\
**Tags:** postgres\
**Created:** [March 4, 2023, 8:05am UTC](https://discourse.getdbt.com/t/transformation-postgres-existing-data/7106 "2023-03-04T08:05:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![snb](https://avatars.discourse-cdn.com/v4/letter/s/d6d6ee/32.png) [@snb](https://discourse.getdbt.com/u/snb)\
**Post date:** [March 4, 2023, 8:05am UTC](https://discourse.getdbt.com/t/transformation-postgres-existing-data/7106/1 "2023-03-04T08:05:24Z")

</div>

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?