Can tableau store huge amounts of data in memory engine? How to handle huge volume of data in Tableau?

Can tableau store huge amounts of data in memory engine? How to handle huge volume of data in Tableau?

Yes, tableau can store huge amounts of data.

But there is no straight answer for this question. Because, we can store huge amount of data based on the Tableau Server implementation (8 cores, 16 cores etc.) configurations. Whether Hyper is used or not, server memory and other factors can influence the volume of the data that we can store.

One important point to remember when dumping huge amounts of data in Tableau server – the volume should not impact the performance and response time of the dashboards. Also, the extract processing time. This is where Hyper is improving Tableau performance.


If we design the dashboard and referring view in a proper way, we don’t need to store huge amounts of data in Tableau. At the end of the day users see the visual dashboard which contains couple of GBs data (Majority of the time less than 5 GB). Because, dashboard presents consolidated information such as avg, sum, calculation results, drill downs, roll ups etc. If dashboard is not presenting RAW detailed data, there is no need for huge amounts of data in Tableau.

When there is a need for trend analysis based on detailed historic data in the dashboard then we may need more storage, even this can be consolidated. Example: instead of seconds and minutes raw data, it can be consolidated in to hourly, daily, weekly data to reduce the huge volume and to improve the performance. If for some reason users are looking for seconds and minutes data, it is possible to deliver all the detailed high-volume data by using right design techniques.


Can tableau store huge amounts of data in-memory engine?
How to handle huge volume of data in Tableau?

Explain What is Tableau Calculations - Addressing and Partitioning.

Tableau Hyper, Tableau Hyper's Unique Design, Tableau for Faster Analytics.

How to create Tableau Parameters, where to use and how to use Tableau parameters.

Tableau Dashboards Performance Issues and Challenges, data refresh, network and connectivity.

Tableau 2018.1 , 2018.2 and 2018.3 Features

What is performance recording in Tableau Server? How to implement performance recording in Tableau Server?

Differences between Tableau 9.3 and Tableau 10.0, 10.1, 10.2, 10.3 and 10.4 ( 9.x vs 10.x versions )

Differences between Tableau 8.3 and Tableau 9.2, 9.1, 9.0 versions ( 8.x vs 9.x versions)

Discuss Difference between 'Data Blending' and 'Data Joining'

Explain Tableau Architecture

MTD, YTD Reports using Tableau Table Calculations

Difference between RANK and INDEX

Types of Data Connections, LIVE vs EXTRACT (IN-MEMORY)

Difference between Individual, Dual and Blended Axis

Types of Filters Quick, Global, Context, At Source, On Dimensions and Measures

Differences between Tiled and Floating in Tableau Dashboard.

Custom Geocoding in Tableau.

Tableau File Types extensions .twb vs .twbx .tde .tdsx .tds .tbs

Tableau Automatic vs Custom Hierarchies Creation

Tableau Actions Difference Filter vs Highlight vs URL

Tableau Workbook Stories Dashboards Worksheets

Tableau Trend Analysis Forecast Models Difference

Summary of Tableau Desktop 9.2 new features (includes Tableau 9.2, 9.1 and 9.0)

Level of detail ( LOD ) expressions, Calculation,Cohort analysis