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 · Accepted solution]

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).

[TimN]

And you can't use PreSQL for In-Database tools because it's not available yet (I'm on 2021.4).  There is an idea out there to add Pre and Post SQL to In-DB but I don't think it's been done yet.

[Kristie_Pires]

I ended up just adding the schema name! Even though it was the longer process - it does work! 

Thank you.

[TimN]

@Kristie_Pires - Great!  Can you mark my reply as the solution if it did solve the problem.  Thank You!