How to run multiple queries on the same table in series

How to run multiple queries in series on the same model/db object (Postgres)


I am migrating from a legacy system where data arrive at different times. Therefore I enrich different columns and append rows to my table.

What I tried

I created multple materialized views which referenze on the same database object.
I tried About run_query macro | dbt Developer Hub but It runs the queries concurrently

What I would like

I would like to apply multiple selfreferenzing queries with incremential load in series and/or parallel on the same data base object