Execute SQL Script

Sad — Fri, 04 Aug 2023 14:19:36 GMT

Can I run SQL scripts in cloud Alteryx, also can I call snowflake stored procedures ?

if possible, please le me know how should I execute. currently I don't see any options

Re: Execute SQL Script

nkuipers — Mon, 07 Aug 2023 07:32:28 GMT

This functionality is currently available in the Designer Cloud (Trifacta Classic) application. (If this application is not visible in your AACP landing page, then please review the discussion here to enable it.) You can create pre-job or post-job SQL scripts, which run after a job has been initiated but before ingestion takes place, and after results have been generated and published, respectively. For more information, please see the doc here. I am not sure if stored procedures can be called, though based on the Limitations section in that doc...

"There are no explicit limitations on the types of SQL statements that can be executed."

...I would assume so!

I hope this helps.

Cheers,

Nathanael

topic Execute SQL Script in Alteryx Designer Cloud Discussions

Execute SQL Script

Re: Execute SQL Script