can we change the schema of redash database. currently redash tables are created in public schema. If we change what is the impact
Try it in a dev environment and see what happens?
HI Thank you so much for the response :). I renamed the schema , and application gave internal server error. So i changed redash/models files wherver tablename reference.
if db schema is changed to newschema
for example instead of tablename = “data_sources” , changed to tablename = “new.schema.data_sources”. likewise 4 or 5 files under models. Post that some errors are gone, but still getting foreign key error in changes and users,
sqlalchemy.exc.NoForeignKeysError: Can’t find any foreign key relationships between ‘newschema.changes’ and ‘newschema.users’.
Is there a common place where we can change the schema to connect to redash database?