KNOWLEDGE BASE

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

Issue

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

Environment

  • Tableau Prep Builder
  • Oracle
  • SQL

Resolution

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.

Cause

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