While creating a table using redash we get “local variable ‘error’ referenced before assignment” while the table is getting created in the database but the output in the Redash query editor is “local variable ‘error’ referenced before assignment”.

PFA error log and error

screenshot

Technical details:

  • Redash Version: 8.0
  • Browser/OS: chrome/rhel7.6
  • How did you install Redash: docker-compose

Please help on this.

Are you able to run other queries with your instance?

Redash is not designed to issue DDL statements to your database.

Yes other queries run fine and for this DDL (create) table actually gets created.

How did you install the Oracle dependencies?

Following the steps mentioned in this dockerfile. Is there any other way to do it apart from the one i used.

https://hub.docker.com/r/joaoleite/redash_oracle/dockerfile