Airflow: Increase max password length in Airflow Connections

[pablosjv]

Description

Increase max password length stored in Airflow Connections from the 500 characters to 5000 characters.

Use case / motivation

The current password length in the Airflow Connections is 500 characters. This is enough for most of the use cases. However, we should be able to store longer passwords in the databases.

Right now, I am increasing the size of the password by modifying the column in PostgreSQL. But as a user, I would want that this is the default configuration for the database so I don't need to do any custom tweaking to store the connections in Airflow.

The "extra" field length is 5000 characters and potentially, I could store the passwords there. However, this is not the most secure approach as that field is not encrypted.

Related Issues

None.

[boring-cyborg[bot]]

Thanks for opening your first issue here! Be sure to follow the issue template!

[kaxil]

We have already increased the limit to 5000 in Airflow 1.10.7

https://github.com/apache/airflow/pull/6241

[pablosjv]

Thanks! I was working with 1.10.4 version.

However, I couldn't find that issue in the changelog for 1.10.7. Is the changelog updated? Or Am I not looking at the correct place?

[kaxil]

Thanks! I was working with 1.10.4 version.

However, I couldn't find that issue in the changelog for 1.10.7. Is the changelog updated? Or Am I not looking at the correct place?

It is not nicely worded but it is at https://airflow.apache.org/docs/stable/changelog.html#id9

[AIRFLOW-6185] SQLAlchemy Connection model schema not aligned with Alembic schema (#6754)

[potiuk]

Indeed :). If you are looking for Password length change, you'd not find it :)