Is it possible to change DATABASE_CELERY_CMD to REDIS_CONNECTION_CMD

[ityulkanov]

I'm trying to find a way to replace result_backend postgres database with redis as was recommended to avoid duplicates in celery_taskmeta due to OOM.

If you’re using the Postgres backend (celery_taskmeta):
	•	task_id is supposed to be unique.
	•	If race conditions or OOM crashes cause duplicate rows or integrity errors:
	•	Airflow’s call to AsyncResult(task_id).state may fail or return inconsistent results.
	•	The scheduler may not get a valid terminal state (SUCCESS/FAILURE).
Result: the Airflow task instance stays stuck in queued because from Airflow’s perspective, the executor never confirmed the outcome. It will only move on when retries kick in (or when the duplicate condition clears and Airflow finally sees a valid result).

Why Redis backend avoids this
	•	Redis result backend uses one key per task_id.
	•	If multiple workers try to report results for the same task, Redis just overwrites the key — last write wins.
	•	Airflow never sees “duplicate rows,” so AsyncResult queries always resolve cleanly.
	•	That’s why Airflow docs generally recommend Redis result backend instead of DB result backend for CeleryExecutor.

Since there is no information available anywhere I had to use LLM to figure out the solution and this is what I got from it.
But when I override the value AIRFLOW__CELERY__RESULT_BACKEND directly I got to this error:

{{- if or (.Values.airflow.config.AIRFLOW__CELERY__RESULT_BACKEND) (.Values.airflow.config.AIRFLOW__CELERY__RESULT_BACKEND_CMD) }}
  {{ required "Don't define `airflow.config.AIRFLOW__CELERY__RESULT_BACKEND`, it will be automatically set by the chart!" nil }}
{{- end }}

So, my question is: is it possible to redefine it someway else, or it is it, and such change is not possible to do at all?