Reporting replica that allows writing
I'm trying to create a replica that allows writing so dbt can apply a reporting layer and a BI tool can run caching without messing with production. We tried using branches but the refresh does a full overwrite so we lose anything that had already been written, which is a problem for any data that we uploaded only for reporting purposes. Any ideas?
2 Replies
vicious-gold•4mo ago
It might be possible for you to use logical replication instead
automatic-azureOP•3mo ago
Thank you! We're trying to avoid doing that if possible to keep cost down, but that might end up being our best option