@pat_nadolny and all, from Meltano v3.1 will be there an implementation for inserting data with a pending or truncating method? If don't have it yet, how do we accomplish that with the current version? really appreciated your response

1. activate version does this, not all targets implement it 2. Easiest thing to do is drop the schema you're pointing to, run tap in full table mode. ie

meltano run dbt:drop_bamboodata tap-bamboohr target-postgres

@visch with drop, it will delete the table, thus it will change the table's structure like datatype, etc. In some cases, the tables already existed with specified structures and need only the data to load. If it can only truncate the data without deleting the table, it would be nice.

@rida

meltano run dbt:truncate'_bamboodata tap-bamboohr target-postgres

@visch is it a custom sql on dbt? If so, i wonder how to config it