galaxytemple opened a new issue, #76708:
URL: https://github.com/apache/airflow/issues/76708
### Under which category would you file this issue?
Providers
### Apache Airflow version
main (development)
### What happened and how to reproduce it?
When creating a SQLite connection in the Airflow UI (`Admin ->
Connections`), the form shows irrelevant fields: `Port`, `Schema`, `Login`, and
`Password`.
SQLite is an embedded file-based database that does not use network ports,
schemas, or user accounts. Moreover, entering values into `Login` or `Password`
pollutes the connection URI (e.g. `file:user:pass@/path/to/db`), causing
`sqlite3.OperationalError: unable to open database file` for absolute paths or
creating corrupted filenames for relative paths.
This occurs because `providers/sqlite` does not specify `ui-field-behaviour`
in `provider.yaml` or `SqliteHook`.
### What you think should happen instead?
Define `ui-field-behaviour` in `providers/sqlite/provider.yaml` (and
`SqliteHook`) to:
1. Hide unused fields: `["port", "schema", "login", "password"]`
2. Relabel `host` to `"File path"`
3. Add placeholders for `host` (`/path/to/database.db`) and `extra`
(`'{"mode": "ro"}'`)
### Operating System
macOS / Linux
### Deployment
Other Docker-based deployment
### Apache Airflow Provider(s)
_No response_
### Versions of Apache Airflow Providers
_No response_
### Official Helm Chart version
Not Applicable
### Kubernetes Version
_No response_
### Helm Chart configuration
_No response_
### Docker Image customizations
_No response_
### Anything else?
_No response_
### Are you willing to submit PR?
- [x] Yes I am willing to submit a PR!
### Code of Conduct
- [x] I agree to follow this project's [Code of
Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
--
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]
