How to shift from Replace to Append Mode for RedShift tables without loosing data ?
We have connected a bunch of massive volume of data to Domo by connecting to our RedShift database. Some of those tables are 50M+ rows and the nightly sync of those becomes longer and longer as we position them as "replace".
Can you share best tricks to move Domo to an "append" mode while ensuring that there's no data gap or data duplication by doing so?
Currently we had to stop a few of the bigger tables to be ingested (300M+ rows / 12Gb + datasets) and some of our tables takes more than 8 hours to sync.
Thanks in advance
- 10.7K All Categories
- 13 Getting Started in the Community
- 34 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 302 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board