In-DB Tool Error

[jonathangonzales]

I am getting the below error when I am using the In-DB tools.

Due to the amount of data this query is pulling I am using In-DB tools and I am getting the error below.

When I use the Input Tool it runs (far too long) fine.

[jonathangonzales · Accepted solution]

issue had to due with aliases.

Because In-DB takes advantage of CTE’s, Alteryx adds its own alias to the CTE’s it creates, which conflicted with initial query already contains aliases.