Custom SQL only supports a minimum set of SQL syntax. For example, CTE is
1.Test your syntax using a simple example like: select OneField from
2.If you have to use some not so basic SQL syntax, create a store procedure
or a view. Tableau is not an all-around SQL client.
On Fri, Oct 14, 2016 at 8:46 AM, Hemant Tikyani <
Custom SQL must be a single SQL statement that returns one resultset.
To query Custom SQL, Tableau wraps is in additional SELECT statement as below:
SELECT ... FROM ( <your SQL> ) "Custom SQL Query"
If you have more that 1 statement in your SQL then wrapped query becomes invalid.
Thanks for the explanation!
BTW, is CTE not considered a single statement?
On Fri, Oct 14, 2016 at 10:22 AM, Dmitry Chirkov <