Is it possible to perform alter session on Redash?

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

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.

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

1 Like