KNOWLEDGE BASE

Warming the Tableau Server Cache Using Subscriptions


Published: 28 Apr 2015
Last Modified Date: 27 Jun 2018

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.
Did this article resolve the issue?