The Order of SQL Issued From Tableau Prep Does Not Match the Process of the Flow

Published: 13 Apr 2022
Last Modified Date: 14 Apr 2022


The order in which the SQL query is issued for each table is not the same as the order of the flow process in Tableau Prep. 
For example, when running the sample flow in the below image, the SQL should be [cal1 / cal --> demo1], however, the actual SQL order in the log is [demo1 --> cal --> cal1] to database.
What is the rule for the order of SQL from Tableau Prep?

User-added image


  • Tableau Prep Builder
  • Oracle
  • SQL


No action is required. Tableau Prep optimizes the order of operations and the order of SQL may not match the process order of the flow.


This is by design.
Did this article resolve the issue?