KNOWLEDGE BASE

Tableau Data Extract .tde Files in Temp Folder Consuming Disk Space


Published: 23 Sep 2014
Last Modified Date: 19 Jun 2017

Issue

When hosting workbooks published with incremental extracts, Tableau Server might consume large amounts of disk space.

Environment

  • Tableau Server
  • Workbooks published with incremental extracts

Resolution

Option 1: Perform a daily cleanup, to ensure temporary files are removed:

On the computer hosting Tableau Server, open the command prompt as an administrator and navigate to the Tableau Server bin folder, located by default at
C:\Program Files\Tableau\Tableau Server\[version]\bin

At the command prompt, run the following commands in order:
  • tabadmin stop
  • tabadmin cleanup
  • tabadmin start

Option 2: Configure temporary files to expire after 12 hours:

On the computer hosting Tableau Server, open the command prompt as an administrator and navigate to the Tableau Server bin folder. 
t the command prompt, run the following commands in order:
  • tabadmin stop
  • tabadmin set temp.file_expiry_s 43200
  • tabadmin config
  • tabadmin start

Cause

A new Tableau Data Extract (.tde) file is created every time an incremental extract occurs. Because incremental extracts are refreshed every 15 minutes, this can result in the creation of a large number of .tde files in the \Tableau\Tableau Server\data\tabsvc\temp folder, which might consume a considerable amount of disk space. By default, these files will expire after 24 hours and will be removed.
Did this article resolve the issue?