How Do I properly Encode `extra` parameters while using `airflow connections add`

Question

Problem Statement

When editing the UI I can add modify the extra field to contain {"no_host_key_check": true}

But when I attempt to add this connection from the CLI with this command which follows the connections documentation format

airflow connections add local_sftp --conn-uri "sftp://test_user:test_pass@local_spark_sftp_server_1:22/schema?extra='{\"no_host_key_check\": true}"

The connection is added as {"extra": "'{\"no_host_key_check\": true}"}

How do I need to modify my airflow connections add command to properly format this connection configuration?

Answer 1

This is fundamentally a misunderstanding that all schema parameters for the airflow connections add command are extra parameters by default

airflow connections add local_sftp --conn-uri "sftp://test_user:test_pass@local_spark_sftp_server_1:22/schema?no_host_key_check=true"

Correctly sets the desired parameter.