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