GitHub user dosubot[bot] added a comment to the discussion: Meta DB (superset://) returns “no such table”
<!-- Answer --> This isn't a permissions or syntax issue—it's a limitation of both PostgreSQL and Superset's meta DB implementation. PostgreSQL doesn't support cross-database queries using the `database.schema.table` pattern, so even with the correct Superset config and admin rights, you'll always get a "no such table" error when trying to reference tables across databases this way. Superset's meta DB engine (which uses Shillelagh) doesn't have special logic to resolve these references for PostgreSQL, so the error just bubbles up as-is. This is confirmed in both the code and recent discussions—there's no workaround or fix in recent releases, and no merged PRs address this limitation. If you need cross-database queries with PostgreSQL, you'll need to use a federated engine like Trino or Presto instead. [Reference 1](https://github.com/apache/superset/issues/32993) | [Reference 2](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/db_engine_specs/superset.py) <!-- 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/faac6109-64b7-4743-b7f3-5f100bf27c75?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/faac6109-64b7-4743-b7f3-5f100bf27c75?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/faac6109-64b7-4743-b7f3-5f100bf27c75?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/faac6109-64b7-4743-b7f3-5f100bf27c75?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/faac6109-64b7-4743-b7f3-5f100bf27c75?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/faac6109-64b7-4743-b7f3-5f100bf27c75?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/faac6109-64b7-4743-b7f3-5f100bf27c75?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-14506500 ---- 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]
