SQL script in IN-DB

[aYaNe_o]

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??

[apathetichell · Accepted 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).

[aYaNe_o]

Thanks for your reply!

I've tried with Alteryx IN-DB tool, and got succeeded :)