GitHub user dosubot[bot] added a comment to the discussion: Cross database joins using extensions
<!-- Greeting --> Hi @Toreeyah! I'm [Dosu](https://go.dosu.dev/dosubot) and Iām helping the superset team. <!-- Answer --> I was unable to find any documentation or discussions in the Apache Superset repository specifically about securely injecting credentials when using the dblink extension in PostgreSQL, nor about common causes of fatal errors when saving SQL queries that use dblink. For your first question: in general, securely injecting credentials for dblink connections in PostgreSQL is not natively handled by Superset. Best practices outside of Superset typically involve storing credentials in secure configuration files (such as .pgpass with appropriate file permissions), using environment variables, or leveraging PostgreSQL roles and permissions to avoid hardcoding credentials in queries. Avoid embedding credentials directly in SQL code or UI fields to reduce the risk of accidental exposure. For your second question: without the exact error message, it's difficult to diagnose the fatal error you encountered when saving the SQL query. Fatal errors with dblink can result from issues like incorrect connection strings, missing or incorrect credentials, insufficient permissions, or syntax errors in the dblink function call. If you can provide the specific error message, I may be able to help you troubleshoot further. If you have more details about the error or your setup, please share them so I can assist you more effectively. <!-- Dosu Comment Footer --> *To reply, just mention my name [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/72e6c9a8-8f48-48e8-b7b1-0b659e148870?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/72e6c9a8-8f48-48e8-b7b1-0b659e148870?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/72e6c9a8-8f48-48e8-b7b1-0b659e148870?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/72e6c9a8-8f48-48e8-b7b1-0b659e148870?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/72e6c9a8-8f48-48e8-b7b1-0b659e148870?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/72e6c9a8-8f48-48e8-b7b1-0b659e148870?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/72e6c9a8-8f48-48e8-b7b1-0b659e148870?feedback_type=other)</sup> [](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/33689) GitHub link: https://github.com/apache/superset/discussions/33689#discussioncomment-13368316 ---- 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]
