KNOWLEDGE BASE

Database Schema Changes Do Not Affect Published Extract


Published: 28 Feb 2013
Last Modified Date: 31 Aug 2016

Issue

Underlying database schema changes are not in published Tableau Data Extract.

Environment

  • Tableau Server
  • Tableau Online

Resolution

  1. Connect to the extract from Tableau Desktop
  2. Remove the data extract by right clicking the data connection in the left pane and selecting 'Extract' > 'Remove'
  3. Edit the data connection to use the new schema by right clicking the data connection in the left pane and selecting 'Edit Connection'
  4. Recreate the Tableau data extract by right clicking the data connection in the left pane and selecting 'Extract Data'
  5. When the extract is complete, republish the data connection to Tableau Server, overwriting the original data connection.

Cause

The behavior is by design since the Tableau Data Extract contains information about the data schema at the time of its creation.
Did this article resolve the issue?