How to Refresh Extracts on a Schedule?

How to Refresh Extracts on a Schedule

Tableau Desktop authors and data stewards can create and publish data extracts. Extracts are copies or subsets of the original data connection. Because extracted data is imported into the Tableau data engine, workbooks that connect to extracts generally perform faster than those that use live database connections. Extracts can also increase functionality.
Setting up refresh schedules
As a server administrator, you can enable scheduling for extract refresh tasks, and then create, change, and reassign schedules. General scheduling options you change on the server are available as part of the publishing process when a Tableau Desktop user publishes an extract.
Schedules that you create have the following options:

How to Refresh Extracts on a Schedule
The priority determines the order in which refresh tasks are run, where 0 is the highest priority and 100 is the lowest priority. The priority is set to 50 by default.
Execution mode
The execution mode indicates to the Tableau Server backgrounder processes whether to run refreshes in parallel or serially. Schedules that run in parallel use all available backgrounder processes, even if the schedule contains only one refresh task. Serial schedules run on only one backgrounder process.
By default, the execution mode is set to parallel, so that refresh tasks finish as quickly as possible. You might want to set the execution mode to serial (and set a lower priority) if you have a very large schedule that prevents other schedules from running.
You can set the frequency to hourly, daily, weekly, or monthly.

Leave a Reply

Your email address will not be published. Required fields are marked *