Hello everyone.
I have a question regarding the Tableau Full Refresh and Incremental Refresh on Extract using SQL Query.
In both cases, Tableau will run the "whole" query.
In case of Full Refresh, Tableau will create the whole schema again (I suppose).
In case of Incremental Refresh, Tableau will run the "whole" query, it will select the rows that should add and it will UNION them with the rest dataset.
So, which of the above flows is "cheaper"? From the perspective of the database, it "costs" the same since the same query runs for both cases. But what happens from the perspective of Tableau?
Thank you!
Hello Menelaos
The incremental refresh is good to save Tableau Server resources as the backgrounder process which handles the extract refresh takes shorter time. It is however adviced to do a full refresh every week with daily incremental refreshs or to do a monthly full with weekly incremental refreshs to get newly added columns.
