1

Hi,

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
        FROM INFORMATION_SCHEMA.COLUMNS
        WHERE table_schema NOT IN ('guest','INFORMATION_SCHEMA','sys','db_owner','db_accessadmin'
                                  ,'db_securityadmin','db_ddladmin','db_backupoperator','db_datareader'
                                  ,'db_datawriter','db_denydatareader','db_denydatawriter'
                                  );

Although, this query works fine when it is run.

Let me know if you’ll need more information.

2

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