Beginning in version 10.5, new extracts use the .hyper format instead of the .tde format. Extracts in the .hyper format take advantage of an improved data engine, which supports the same fast analytical and query performance as the data engine before it, but for even larger extracts.

Although there are many benefits of using .hyper extracts, the primary benefits include the following:

  • Create larger extracts: Extracts in the .hyper format can contain billions of rows of data. Because .hyper extracts can support more data, you can use version Tableau Desktop 2022.4 to consolidate .tde extracts that you previously had to create separately.

  • Faster extract creation and refreshes: While Tableau has always optimised performance for creating and refreshing extracts, this release supports faster extract creation and refreshes for even larger data sets.

  • Better performance when interacting with views that use larger extract data sources: Views that use extract data sources perform better than they did previously. Although smaller extracts continue to perform efficiently, larger extracts perform more efficiently.

What causes an extract upgrade?

Although you can continue to open and interact with .tde extracts in version 2022.4, when you perform an extract task on a .tde extract, the .tde extract is upgraded to a .hyper extract. After the extract is upgraded, you should be aware of the following backward limitations:

  • You can't convert the upgraded extract back to a .tde extract.

  • You can't open the upgraded extract in an earlier version of Tableau Desktop.

  • You can't use the Export as Version in Tableau Desktop to downgrade a workbook that contains a .hyper extract.

  • You can't open a workbook in Tableau Desktop 10.4 and earlier that is downloaded from Tableau Cloud using the Download Tableau Workbook option if the workbook contains a .hyper extract.

Tasks that cause an extract upgrade

There are three distinct ways a .tde extract can get upgraded to a .hyper extract: 1.) during an extract refresh (full or incremental), 2.) when appending data to an extract and 3.) when an extract is upgraded manually using Tableau Desktop 2022.4. After an extract has been upgraded, the original .tde extract is automatically removed from Tableau Cloud if it's not being reference by other workbooks.

The followings tasks will upgrade a .tde extract to a .hyper extract on Tableau Cloud:

  • Manual extract refresh

  • Incremental extract refresh using Tableau Bridge

    Note: A full refresh of a .tde extract using Tableau Bridge 10.4 and earlier does not upgrade the extract.

  • A scheduled full or incremental extract refresh

  • A scheduled incremental extract refresh using Tableau Bridge

    Note: A full refresh of a .tde extract using Tableau Bridge 10.4 and earlier does not upgrade the extract.

  • Automated refresh tasks that are performed through the Extract Command-Line Utility

  • Automated append data to an extract using tabcmd

  • Automated append data to an extract using the Extract Command-Line Utility

Impact of extract upgrade

In general, Tableau recommends that you upgrade to Tableau Desktop 2022.4 to match the latest version of Tableau Cloud. By using the latest version Tableau Desktop, you can avoid certain extract compatibility issues when working with extracts that were created using earlier versions of Tableau Desktop.

If you cannot upgrade to the latest version of Tableau Desktop, review a detailed explanation of the extract compatibility scenarios(Link opens in a new window) on the Tableau Support page or a summary explanation below to better understand when extract upgrades can occur and potential compatibility issues you or others might experience.

Note: In the tables below, "10.4" represents Tableau 10.4 and earlier and "10.5" represents Tableau 10.5 and later.

Performing tasks on Tableau Cloud

When working with extracts created in an earlier version of Tableau Desktop, you should be aware of the following extract-related compatibility scenarios around tasks performed on Tableau Cloud.

 

Task

10.4 workbook10.5 workbook
.tde extract.tde extract.hyper extract
Publish from Tableau Desktop 10.4Not possibleNot possible
Publish from Tableau Desktop 10.5
Refresh or scheduled refresh

Workbook version remains unchanged, but extract upgrades to .hyper format

Workbook version remains unchanged, but extract upgrades to .hyper format
Edit/save in web authoringWorkbook version changes to 10.5, but extract remains in .tde format
Edit/save in web authoring then refresh or append

Workbook version changes to 10.5, and extract upgrades to .hyper format

Workbook version remains unchanged, but extract upgrades to .hyper format

Refreshing extracts using Tableau Bridge

When working with extracts created in earlier versions of Tableau, you should be aware of the following extract-related compatibility scenarios around refreshing extracts using Tableau Bridge.

 

Task

10.4 workbook10.5 workbook
.tde extract.tde extract.hyper extract
Full refreshfrom Tableau Bridge 10.4
Incremental refresh or appendWorkbook version remains unchanged, but extract upgrades to .hyper formatWorkbook version remains unchanged, but extract upgrades to .hyper format
Full refreshfrom Tableau Bridge 10.5Workbook version remains unchanged, but extract upgrades to .hyper formatWorkbook version remains unchanged, but extract upgrades to .hyper format
Incremental refresh and appendWorkbook version remains unchanged, but extract upgrades to .hyper formatWorkbook version remains unchanged, but extract upgrades to .hyper format

Downloading from Tableau Cloud

When working with extracts created in earlier versions of Tableau, you should be aware of the following extract-related compatibility scenarios when downloading from Tableau Cloud.

 

Task

10.4 workbook10.5 workbook
.tde extract.tde extract.hyper extract
Download and openin Tableau Desktop 10.4Can't open workbook; you see a "this workbook uses a .hyper extract and is not compatible with this version; open the workbook in version 10.5 or later" error message, and then asked to locate the extractCan't open workbook; you see a “this file was created by a newer version; upgrade Tableau” error message
in Tableau Desktop 10.5
Export As Versionfrom Tableau Desktop 10.5Option is greyed out

Automating extract refresh and append tasks

When working with extracts created in earlier versions of Tableau, you should be aware of the following extract-related compatibility scenarios around automating refresh and append tasks from tabcmd and the Tableau Command-Line Utility.

 

Task

10.4 workbook10.5 workbook
.tde extract.tde extract.hyper extract
Refresh or appendusing 10.4 tabcmd

Workbook version remains unchanged, but extract upgrades to .hyper format

Workbook version remains unchanged, but extract upgrades to .hyper format
using 10.5 tabcmd

Workbook version remains unchanged, but extract upgrades to .hyper format

Workbook version remains unchanged, but extract upgrades to .hyper format
Publish extractusing 10.4 tabcmdNot possible
using 10.5 tabcmdNot possibleNot possible
Refresh or appendusing 10.4 Tableau Command-Line UtilityNot possibleNot possible
using 10.5 Tableau Command-Line UtilityWorkbook version remains unchanged, but extract upgrades to .hyper formatWorkbook version remains unchanged, but extract upgrades to .hyper format

Why keep an extract in .tde format?

If you cannot upgrade to the latest version of Tableau Desktop or Tableau Bridge, you'll need to keep your extract in .tde format.

How to keep an extract in .tde format

To keep an extract in the .tde format, you'll need to avoid upgrading the extract. To avoid upgrading the extract, do not perform any of the tasks listed above in the Tasks that cause an extract upgrade section to a .tde extract.

Then, consider the following suggestions if you need to maintain a .tde version of an extract:

  • Perform extracts tasks using Tableau Cloud, but maintain an earlier version of Tableau Desktop and the ability to connect to the original data to recreate .tde extracts.

  • Use an earlier version of Tableau Desktop to perform extract tasks, such as extract refresh or append data.

  • Disable existing extract refresh schedules on Tableau Cloud or Tableau Bridge until you can identify which extracts should and shouldn't be upgraded.

    Note: To access an extract's refresh schedule, you must be a data source owner, site administrator or Project Leader. For more information about which site roles allow full Project Leader capabilities, see Project-level administration.

What to expect after an extract upgrade

After your extract has been upgraded, there are some additional changes you can expect when working with extracts in version 2022.4. For more information, see After an extract upgrade(Link opens in a new window) section in Tableau Help.

Thanks for your feedback!