Was this page helpful?
Yes No
Tableau Help > Tableau Online Help > 

Extract Upgrade to .hyper Format

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 2018.2 to consolidate .tde extracts that you previously had to create separately.

  • Faster extract creation and refreshes: While Tableau has always optimized 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 2018.2, 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 Online 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 2018.2. After an extract has been upgraded, the original .tde extract is automatically removed from Tableau Online if it's not being reference by other workbooks.

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

  • 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 2018.2 to match the latest version of Tableau Online. 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 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 Online

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 Online.

 

Task

10.4 workbook 10.5 workbook
.tde extract .tde extract .hyper extract
Publish from Tableau Desktop 10.4 Not possible Not 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 authoring Workbook 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 workbook 10.5 workbook
.tde extract .tde extract .hyper extract
Full refresh from Tableau Bridge 10.4
Incremental refresh or append Workbook version remains unchanged, but extract upgrades to .hyper format Workbook version remains unchanged, but extract upgrades to .hyper format
Full refresh from Tableau Bridge 10.5 Workbook version remains unchanged, but extract upgrades to .hyper format Workbook version remains unchanged, but extract upgrades to .hyper format
Incremental refresh and append Workbook version remains unchanged, but extract upgrades to .hyper format Workbook version remains unchanged, but extract upgrades to .hyper format

Downloading from Tableau Online

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 Online.

 

Task

10.4 workbook 10.5 workbook
.tde extract .tde extract .hyper extract
Download and open in Tableau Desktop 10.4 Can'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 extract Can'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 Version from Tableau Desktop 10.5 Option 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 workbook 10.5 workbook
.tde extract .tde extract .hyper extract
Refresh or append using 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 extract using 10.4 tabcmd Not possible
using 10.5 tabcmd Not possible Not possible
Refresh or append using 10.4 Tableau Command-Line Utility Not possible Not possible
using 10.5 Tableau Command-Line Utility Workbook version remains unchanged, but extract upgrades to .hyper format Workbook 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 Online, 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 Online 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 2018.2. For more information, see After an extract upgrade section in Tableau Help.