How to insert data in existing tables using dbt

Hi,
I am new to dbt and trying to understand the things here. I am in a bit of situation where, we are creating facts and dimensions using CI/CD process. However, dbt creates its own DB objects based on materialization and insert data in it.

My requirement is to insert data into pre-created db objects like fact and dimension tables. Can you help me understand the flow and how can I achieve this?

I have never done this before :face_with_raised_eyebrow: but I think you should be able configure an incremental model to load to your existing table. Just make sure your model name matches the existing table name. So if your current table is “fact_super_cool_events” then name your file in dbt project “fact_super_cool_events.sql” and configure it with an incremental materialization. Materializations | dbt Docs

2 Likes