mistercrunch commented on issue #4916: Readonly Databases not Supported (eg Dremio or lower permissioned connections) URL: https://github.com/apache/incubator-superset/issues/4916#issuecomment-385699143 I think you're misinterpreting the logs. Superset does not require writing to target databases. `SELECT EXISTS` is against your Superset metadata database as it should as it tries to add a new entry on the Superset side to store the table's metadata from Dremio. My guess it that the call that tries to extract the metadata from Dremio here https://github.com/apache/incubator-superset/blob/master/superset/models/core.py#L809 isn't working properly in the dialect. Some database don't have a direct notion or schema, or sometimes have 2 levels of namespacing (Postgres has database and schema/owner) and that doesn't always fits the SQLAlchemy model perfectly. Dialects implementation have to be careful to line things up properly.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
