Issue
When performing an incremental extract refresh using a non-unique key (e.g. date), the job succeeds however the extracted data may be incorrect.
When performing an incremental extract refresh using a non-unique key (e.g. date), the job succeeds however the extracted data may be incorrect.
Upgrade to the appropriate releases from May of 2023 and newer:
If not able to upgrade, here are the workarounds for this issue.
Follow the steps under the Run a refresh on Tableau Cloud section in our Product Help
Disable the NonUniqueIncrementalKey feature flag by taking the following steps:
Windows:
Mac:
Open a terminal window
Run:
If you do not have sudo permission, run the following command
Run the below TSM commands to disable the non-unique incremental key feature.
tsm configuration set -k features.NonUniqueIncrementalKey -v false
tsm pending-changes apply
See tsm Command Line Reference for more information.
Regarding the Non-Unique key message, “unique” means the source database must have a uniqueness constraint for the column. If it doesn’t, then the extract may be impacted, regardless of whether every row is unique or not.