Unable to view database schemas when connecting to a SQL server datasource


I am unable to view the schemas in the Query editor when I select SQL server(ODBC) datasource.
I am using a read-only user for connecting to the datasource.

Upon further investigating, I found the query that is used to fetch the schema and table names.

SELECT table_schema, table_name, column_name
        WHERE table_schema NOT IN ('guest','INFORMATION_SCHEMA','sys','db_owner','db_accessadmin'

Although, this query works fine when it is run.

Let me know if you’ll need more information.

Thanks for your report. Do you see anything in Redash’s logs about the failed query?