SQL Queries - No Schema Specified

Kristie_Pires

Hello there!! Happy holidays  

I inherited a lot of SQL queries that used to be run manually in DBeaver. To run these queries in DBeaver, since no schema was specified, they had the following statement included at the beginning of the code:

 ALTER session Set current_schema = schema_name

So, I am trying to run these in Alteryx automatically, but Alteryx is unable to run them.

Is there an easy way for me to include the schema name or another statement like the one above (Alter session...) in Alteryx that would allow me to run the queries?

Thank you so much for any ideas! 

TimN

Just add Schema name to the SQL as one option.  You could try putting that Alter statement in the PreSQL of Input Data tool is that's easier then editing the SQL.  However, you'd need to add that to every Input data tool because each alteryx DB execution is a new session (I believe).