Intelligent extracts
This section will discuss what a Tableau Data Extract (TDE) is as well as how to efficiently construct an extract.
Understanding the Tableau Data Extract
A Tableau Data Extract (TDE) is a proprietary compressed data source created by Tableau Desktop. A TDE can be stored locally and accessed by Tableau to render visualizations. Consider the following points; they make a .tde file an excellent choice for improved performance:
- A TDE can be quickly generated at an aggregate level:
- See the walkthrough of the Extract Data dialog box.
- A TDE is a columnar store:
- Relational databases typically store data using a Row store methodology. A columnar store records as sequences of columns.
- In the following example, note that Row store is excellent for returning individual rows, whereas Column store is much better for returning aggregated data:
|
Table | |||
|
Instrument |
Store |
Price | |
|
Row 1 |
Selmer Trumpet |
North |
$3500 |
|
Row 2 |
Conn French Horn |
East |
$4500 |
|
Row 3 |
Getzen Trombone... |
