Hi, I have question with Alteryx In-DB tool.
Can I write SQL script directly in In-DB tool?
For example, I would like to use any function like sort, lag , accumulation function and so on.
When I process large data in out of In-DB, it spend too much time...
So, I want to write SQL script directly in In-DB tool.
How Can I do it??
Solved! Go to Solution.
you can use the native sql functions and syntax of your underlying db. If your underlying db supports lag/explode/pivots etc - yes. you can. the limiations are: you can only send exactly one SQL command per In-DB activity -ie you cannot use a SET command. You also cannot use CTE (aka WITH).
Thanks for your reply!
I've tried with Alteryx IN-DB tool, and got succeeded :)