Greetings! A question for the community: since target-postgres load_method is not implemented yet, anyone has any idea on how to truncate/empty the target table before inserting new data??

Hey @Samuel Nogueira Farrus, I'm curious what your solution looks like!

Oi mate, sorry, should have posted it. I created a

dbt-postgres

transform with the following content:

{{
  config(
    pre_hook='truncate <schema>.<table>',
    post_hook='drop view <schema>.<transform_sql_file_name>'
  )
}}

select now()

and then set a

commands

in the

meltano.yml

:

commands:
  truncate:
    args: run --select models/<truncate_file>.sql
  transform:
    args: run --exclude models/<truncate_file>.sql

So I run the ELT with:

meltano run dbt-postgres:truncate <extractor> target-postgres dbt-postgres:transform

There you go, the target table is emptied before the insertion of new data

Oh that's nice and clever!