markporoshin / dbt-greenplum

Adaptation postgres adapter for Greenplum
32 stars 20 forks source link

Feature/truncate insert strategy #25

Closed egor-popov closed 11 months ago

egor-popov commented 1 year ago

In order to deal with PostgreSQL binding views and non-obvious cascade object dropping via standart "table" materialization, I propose using custom materialization strategy "truncate+insert", cause TRUNCATE operation in Greenplum is transactional and can be rolled back.

markporoshin commented 1 year ago

@egor-popov Could you please update README.md according changes?