I work for a school district, meaning most of my dashboards are not used throughout the summer. Since tableau automatically suspends any extract refreshes that are not accessed for over 32 days, this means I often get the notification that Tableau wants to stop refreshing my extracts to save resources. I also have several views that we need to look at incredibly frequently, but only seasonally (e.g. I need to be able to check students' test scores daily, but only in the months that they test).
The reality is that I have no need to refresh these extracts daily year round, but I do need them refreshing daily for the relevant timeframes. Is there a way to schedule extracts so that they refresh daily for some time period (say October thru June, or just the month of January or something), and then stop refreshing until the the same time next year?
#Tableau Cloud
Hi, my answers below:
Since tableau automatically suspends any extract refreshes that are not accessed for over 32 days, this means I often get the notification that Tableau wants to stop refreshing my extracts to save resourcesTo avoid suspended extracts: For this if the datasource is embedded in your workbook (thus you are not using a published datasource), you may create a subscription in a workbook or any of the following events:
If we are talking about a published datasource and Tableau Cloud, probably the easiest would be to create a Tableau Pulse metric and configure a digest:
If using Tableau Server, you can turn off the suspended extract option:
https://help.tableau.com/current/server/en-us/extract_auto_suspend.htmIf using Tableau Cloud, you may take a look of:
https://help.tableau.com/current/online/en-us/extract_auto_suspend.htm
The reality is that I have no need to refresh these extracts daily year round, but I do need them refreshing daily for the relevant timeframes.Currently, this is not possible with the built in options. However, this sounds like a wonderfult idea. You may create an idea for this on the Salesforce Idea Exchange:
https://ideas.salesforce.com/s/postIf this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Tableau Ambassador
