I have a question regarding incremental refresh with SQL Query on a Tableau Server.
My plan was the following:
1) Run the query for data till yesterday(i.e 20/7/2021) . After this I will have the full extract until that Date.
2) The next day(22/7/2021), I will build a flow that will do this. Each day will run the query for the previous day (21/7/2021) and UNION the data with the extract. In that way, I will have the incremental extract using the SQL Query.
Problem:
For that Procedure, I must use the Output Extract, that the flow will produce .
I tried this Procedure on my local machine, but, Tableau Prep gives me the following Error.
What's the best solution to approach this problem? Is there a better way?
I also attach the full Flow.
Thank you in advance!
Menelaos
@Menelaos Ampartzakis
Hi,
a .you don't need this part of the flow:
b. In your input module select the incremental refresh option, select in the input the field date, select your output module and following the field date in the output module. What this will do, is to obtain the maximum date from the output module, and will use only the info in your input module that is greater than that maximum value.
c. In your Output module, select the option Append to table in the incremental option, and create table in your full refresh:
Then you can run your flow incrementally or full refresh.
If this post resolves the question "Select as Best" or if it assists in resolving the question, please "Upvote". This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego
