Is there any way to do an UPSERT with data coming from Postgres?
Our main SQL database is Postgres, and we're populating DataSets with calls similar to
select * from view_for_domo
We're using full replacement, rather than incremental pulls.
We're interested in using incremental updates rather than full refreshes of the DataSet to speed things up. After checking the options I can find in Domo, and see that
INSERT ON CONFLICT in Postgres) and
MERGE are not supported for the Postgres connector.
The replace method is fine, until it's too slow for the amount of data we're accumulating.
The incremental method is likely fine, for an append-only table, but we don't have many of those.
There's no way to reliably fake an
MERGE, and we do regularly delete and revise rows that have already been imported into Domo.
Is there some feature, behavior, or beta feature that might help us out here?
Thanks a lot.