Last Modified Date: 14 Oct 2019
- Tableau Desktop
Option 1Only use full refreshes. For more information, see Refresh Extracts.
Option 2Truncate the timestamp in the Vertica database to 1000th of a second or less precision.
CauseTableau Desktop stores timestamps only to the 1000th of a second precision, which looks like 2017-03-09 16:35:08.000.
- Vertica databases can store the timestamp to a higher level of precision.
- Sometimes the last timestamp in the extract is rounded down, which means that the full timestamp in Vertica is technically after the last timestamp in the Tableau extract.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials