Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Snowsql query not getting executed on gallery

pkumardayal
5 - Atom

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.

 

Capture.PNG

Capture2.PNG

 

pkumardayal_0-1612854751946.png

 

1 REPLY 1
RishiK
Alteryx
Alteryx

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