GitHub user dosubot[bot] added a comment to the discussion: How to hide queries from superset responses
<!-- Answer --> Superset does not offer a built-in configuration to hide or remove the SQL query from API responses for authenticated users. By default, the `/api/v1/chart/data` endpoint includes the actual query in the `query` field. However, for guest (embedded) users, Superset removes the `query` field from the response using logic in the backend ([source](https://github.com/apache/superset/blob/master/superset/charts/data/api.py)). To apply this for all users, you would need to modify the backend codeāspecifically, update the `_send_chart_response` method in `ChartDataRestApi` to remove or redact the `query` key for every user, not just guests. There is no documented configuration or feature flag for this, so a code change is required ([source](https://github.com/apache/superset/blob/master/tests/integration_tests/charts/data/api_tests.py)). If you need implementation pointers, look for the section in `_send_chart_response` where it checks `security_manager.is_guest_user()` and pops the `query` key from each query object. You can generalize this logic to apply for all users. <!-- 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/a58096a9-58e5-4a00-8e48-22bb9a6cca81?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/a58096a9-58e5-4a00-8e48-22bb9a6cca81?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/a58096a9-58e5-4a00-8e48-22bb9a6cca81?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/a58096a9-58e5-4a00-8e48-22bb9a6cca81?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/a58096a9-58e5-4a00-8e48-22bb9a6cca81?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/a58096a9-58e5-4a00-8e48-22bb9a6cca81?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/a58096a9-58e5-4a00-8e48-22bb9a6cca81?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/35711) GitHub link: https://github.com/apache/superset/discussions/35711#discussioncomment-14707344 ---- 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]
