GitHub user dosubot[bot] added a comment to the discussion: while writing query in sql lab of apache superset i getting error You can't write against a read only replica.
<!-- Answer --> This error comes from your database, not Superset itselfâSuperset just relays it. It means your query is trying to perform a write operation (like INSERT, UPDATE, or DELETE) on a database connection that only allows reads. Superset surfaces this as a generic database error (Issue 1002) when it doesn't have a more specific handler for the message from your database engine [[source](https://github.com/apache/superset/blob/f802474b07bc7a2765e57fcd6612d2b4454f5c62/superset/errors.py)]. Check if your query is trying to modify data. If so, you'll need to connect Superset to a database endpoint that allows writes, not a read-only replica. If you expect to be able to write, review your Superset database connection settings or talk to your database admin to make sure you're using the correct endpoint for your needs. If you share your database backend or connection details, I can help you dig deeper. <!-- 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/e1231422-9c79-4aa9-966a-8d10472dd263?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/e1231422-9c79-4aa9-966a-8d10472dd263?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/e1231422-9c79-4aa9-966a-8d10472dd263?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/e1231422-9c79-4aa9-966a-8d10472dd263?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/e1231422-9c79-4aa9-966a-8d10472dd263?feedback_type=hallucination) | [Report đ](https://app.dosu.dev/response-feedback/e1231422-9c79-4aa9-966a-8d10472dd263?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/e1231422-9c79-4aa9-966a-8d10472dd263?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/33915) GitHub link: https://github.com/apache/superset/discussions/33915#discussioncomment-13580895 ---- 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]
