KNOWLEDGE BASE

Warming the Tableau Server Cache Using Subscriptions


Published: 28 Apr 2015
Last Modified Date: 15 Jan 2020

Question

How to improve workbook performance by "warming" the Tableau Server cache using subscriptions.

Environment

Tableau Server

Answer

Starting with Tableau Server 9.0, the Cache Server can be "warmed" with data using the Subscription function. Triggering a subscription email that includes a thumbnail after executing an extract refresh will cause the queries to run for the viz and load into the external query cache.

Example Use Case Scenario: A user wants a fast-loading view for an 8 AM meeting.
  • Tableau Administrator schedules an extract refresh at 2 AM.
  • Tableau Administrator schedules a subscription email at 5 AM.
  • User loads workbook quickly from stored cache at 8 AM.
Note: if "Refresh More Often" is selected in the Data Connections tab of Configure Tableau Server, the cache will be cleared every time the view is loaded. Additionally, regardless of cache settings, if a user hits the "Refresh Data" button on the toolbar, the Tableau Server will fetch new data.

Additional Information

For more information about Cache Views, see the Tableau Server 9.0 Scalability: Powering Self Service Analytics at Scale White Paper and the following blog: Report from the Field: A Sith’s Tableau Server Cache Warmer.

Starting from Tableau Server 10.3 and later versions, the cache warming is built in. For more information, see the following documentation: 
Discuss this article... Feedback Forum
Did this article resolve the issue?