Is it possible to perform alter session on Redash?

adp_asilva · July 12, 2021, 8:28pm

I’m trying to run the following query “alter session set current_schema = RECEIVABLES_ADM;” in an Oracle database!

jesse · July 12, 2021, 9:09pm

Probably not. Generally the schema is chosen as part of the data source setup. I don’t have an Oracle database to test on, though, so it could be I’ve misunderstood something.

griffinator76 · July 15, 2021, 1:24am

You can either write queries to include the schema name e.g. MYSCHEMA.MYOBJECT or you can create an after logon trigger for the user specified in the Redash data source e.g. oracle11g - In oracle, can I associate a default Schema with my USER ID where SCHEMA <> USERID? - Stack Overflow