GitHub user dosubot[bot] added a comment to the discussion: Meta DB (superset://) returns “no such table”
<!-- Answer --> This is a known limitation in Superset 4.1.1: cross-database queries via the meta database (`superset://`) connection, using syntax like `"dev_my_db.ex.sample_data"`, do not work for PostgreSQL and result in `"no such table"` errors. This happens because Superset cannot properly resolve cross-database table references for PostgreSQL in the meta database context, regardless of escaping or encoding the table name. There is currently no documented workaround or configuration that enables this functionality, even if you follow the docs and whitelist the databases as described. For now, only queries within a single database (using just `schema.table`) are supported without elevated permissions, and cross-database queries require `all_database_access` or `all_datasource_access` permissions, but even then, table resolution issues persist for PostgreSQL. More details are discussed [here](https://github.com/apache/superset/discussions/35173) and [here](https://github.com/apache/superset/issue s/31406). <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/5e2cfea8-8b91-4124-bed7-1245fe2f95df?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/5e2cfea8-8b91-4124-bed7-1245fe2f95df?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/5e2cfea8-8b91-4124-bed7-1245fe2f95df?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/5e2cfea8-8b91-4124-bed7-1245fe2f95df?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/5e2cfea8-8b91-4124-bed7-1245fe2f95df?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/5e2cfea8-8b91-4124-bed7-1245fe2f95df?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/5e2cfea8-8b91-4124-bed7-1245fe2f95df?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)& nbsp;[](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/35278) GitHub link: https://github.com/apache/superset/discussions/35278#discussioncomment-14506332 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
