dosubot[bot] commented on issue #29575:
URL: https://github.com/apache/superset/issues/29575#issuecomment-2233497193
<!-- Answer -->
It looks like the issue is related to the new `DISALLOWED_SQL_FUNCTIONS`
setting introduced in version 4.0.2. You can adjust this setting in your
Superset configuration to allow the necessary SQL functions.
Here's how you can modify the configuration:
```py
DISALLOWED_SQL_FUNCTIONS: dict[str, set[str]] = {
"postgresql": {"version", "query_to_xml", "inet_server_addr",
"inet_client_addr"},
"clickhouse": {"url"},
"mysql": {"version"},
}
```
If you need to allow specific functions, you can remove them from the list.
For example, to allow the `version` function for PostgreSQL:
```py
DISALLOWED_SQL_FUNCTIONS: dict[str, set[str]] = {
"postgresql": {"query_to_xml", "inet_server_addr", "inet_client_addr"},
"clickhouse": {"url"},
"mysql": {"version"},
}
```
Make sure to update your configuration file accordingly and restart
Superset. This should resolve the `DISALLOWED_SQL_FUNCTIONS` error.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
