Snowsql query not getting executed on gallery

pkumardayal

Hi,

I wanted to execute a snowsql script in my workflow. I am able to do the same on Alteryx Designer but when I execute the same workflow on gallery, it gets stuck on run command tool.

Attached is the run command tool configuration, messages on gallery and sample code (alias db, schema are used) that I wanted to execute.

rkapoor

@pkumardayal it looks like the sql is trying to access the tables on the db. Do you know if the Alteryx Server / Gallery user has permissions to that Snow DB or table(s)?