Is there a way for us to implement partitions on a postgres table using DBT , similar to partitions capability in BigQuery ? As as workaround I have created a partitioned table manually and doing an incremental load.
But “–full-refresh” of the model recreates the table without partitions, and we are trying to avoid this.
Please let me know if you have come across similar problem.
The solution provided here does help but it does require some manual effort.