topic Re: ALTERYX GALLERY Work Flow FAILS - Error running PreSQL in Alteryx Server Discussions

ALTERYX GALLERY Work Flow FAILS - Error running PreSQL

srikant96 — Tue, 05 Mar 2019 19:38:35 GMT

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 ?

Re: ALTERYX GALLERY Work Flow FAILS - Error running PreSQL

TrevorS — Thu, 07 Mar 2019 15:02:21 GMT

Hello @srikant96 ,

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

Thanks!

TrevorS

Re: ALTERYX GALLERY Work Flow FAILS - Error running PreSQL

srikant96 — Mon, 11 Mar 2019 17:13:18 GMT

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

Re: ALTERYX GALLERY Work Flow FAILS - Error running PreSQL

srikant96 — Mon, 11 Mar 2019 17:32:48 GMT

use warehouse xxx;
use database.schema;

Adding these helped solve the issues I was facing

Thank You

Re: ALTERYX GALLERY Work Flow FAILS - Error running PreSQL

Devon — Wed, 27 May 2020 23:41:17 GMT

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