GitHub user dosubot[bot] added a comment to the discussion: How to disable the encryption of long field names?
<!-- Answer --> I found a similar unsolved discussion titled "[Why does sqlLab encrypt long fieldnames?](https://github.com/apache/superset/discussions/31997)" which might be relevant to your question <sup>[[1]](https://github.com/apache/superset/discussions/31997)</sup>. Regarding your question, the hashing of long field names in Superset is controlled by the `_truncate_label` method, which uses the `max_column_name_length` attribute to determine when to apply hashing. For Oracle, this length is set to 30 by default in the `OracleEngineSpec` class. Since Oracle 19 allows field names of up to 128 characters, you might want to adjust the `max_column_name_length` to accommodate this. However, there is no direct configuration option or environment variable in Superset to override the `max_column_name_length` for Oracle without modifying the source code. You would need to change the `max_column_name_length` attribute in the `OracleEngineSpec` class to a higher value, such as 128, to prevent the hashing of long field names <sup>[[2]](https://github.com/apache/superset/blob/master/superset/db_engine_specs/base.py)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/70211df5-79fa-4430-b8a8-998bb6126304?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/70211df5-79fa-4430-b8a8-998bb6126304?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/70211df5-79fa-4430-b8a8-998bb6126304?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/70211df5-79fa-4430-b8a8-998bb6126304?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/70211df5-79fa-4430-b8a8-998bb6126304?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/70211df5-79fa-4430-b8a8-998bb6126304?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/70211df5-79fa-4430-b8a8-998bb6126304?feedback_type=other)</sup> GitHub link: https://github.com/apache/superset/discussions/33016#discussioncomment-12749666 ---- 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]
