SQL inputs for reports

Question

What does everyone use to input SQL? When inputting more complex SQL pulling from different databases, Alteryx input tools hate it. Plus, they may not support certain functions that are used in the query I am trying to input.  Does everyone just use excel?? Seems to be a huge issue we are having!

Any other insight would be awesome.

apathetichell · Answer

I do not drop tables in Alteryx. I do a decent amount of subqueries. It really depends on the syntax of your backend db.

CGadbury · Answer

How complex of Queries do you use? Once I have drop tables and subqueries and pull from a separate table nothing works in Alteryx.

We are trying to get permission to create procedures, which should theoretically solve our issue.

apathetichell · Answer

Is it Alteryx or is it your source db? Other than using WITH statements IN-DB. I don't really see too many differences between a worksheet/notebook in Snowflake/Databricks/BQ vs Alteryx. I use a text input tool - which I summarize and add a connection too. The I use Dynamic Input In-DB.