ALTERYX GALLERY Work Flow FAILS - Error running PreSQL

[srikant96]

No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command. (Tool Id: 3)

Works perfect in the desktop wondering if this DSN in Gallery is an issue ?

[TrevorS]

Hello @srikant96 ,

Can you please include a screenshot of the error message you are getting?

Thanks!

TrevorS

[srikant96 · Accepted solution]

ACTIVE WAREHOUSE, DATABASE, SCHEMA was missing and hence it failed .Desktop worked fine because , these things were built in differently

[srikant96]

use warehouse xxx;
use database.schema;

Adding these helped solve the issues I was facing 

Thank You 

[Devon]

I got some help internally for this one but wanted to post the solution that worked for us. We ended up needing to add the USE WAREHOUSE XXX to the "Pre SQL Statement"

Edit: Update image