elementary-data
Support PostgreSQL with replicas
The issue happens when trying to set up elementary on PostgreSQL with replicas. We have AWS Aurora PostgreSQL. When I try itialize elementary the errors like "cannot delete from table "elementary_test_results" because it does not have a replica identity and publishes deletes" are thrown. Some elemetary models are not even created because of this issue. I'll try to create them manually and then set replica identity to full for all of them but that is not very convenient. Is there the way to set all these models for my use case?
- dbt Version 1.6.1
- elemetary version 0.10.0
Hey @pavel93yan , The Elementary tables are dbt models. How do you solve this for dbt models in your projects?
Hey @Maayan-s ! For regular dbt models that I created in our dbt project, I used custom post-hook to create primary key for the table if it doesn't exist. If a table didn't have column with unique values, I would come up with post-hook which alters replica indetity to FULL.