My best guess is that the size increase is metadata. Not sure why but that would be my best guess.
Hi Michael, try viewing the underlying data, or exporting it, to make sure that the data is correct. I wonder if you might be adding the same data multiple times.
The data are correct and appended as should. There are no duplicates.
I think you are right about the metadata. I'm just trying to find out how to clean that up within my script / API so that I don't end up with a tde file that is 500MB in a year.
I hope this will help you .
When full refreshes are performed on extracts on Tableau Server, calculated fields that are being used in the workbook are optimized to help improve performance. More specifically, Tableau moves your calculated fields into the extract, which then creates new measures that you do not see. These new measures contain pre-computed values so that your calculations do not have to be recomputed each time they are used. When extracts are optimized like this, the file size increases.
Thanks for your answer, but I'm not sure this helps me. The tde-files are in my case created with the data exract api. Furthermore, the tde 's are created by raw data so there are no calculated fields.