Skip to content

Airflow Snowflake connection: extra JSON silently overwritten #57984

@manipatnam

Description

@manipatnam

Apache Airflow Provider(s)

snowflake

Versions of Apache Airflow Providers

apache-airflow-providers-snowflake==6.6.0

Apache Airflow version

2.11.0

Operating System

debian

Deployment

Astronomer

Deployment details

No response

What happened

When creating/editing a Snowflake connection, adding raw JSON to Extras like:

{"account": "1234"}

gets replaced on save by:

{"insecure_mode": false}

If you instead type “Account” in the dedicated Snowflake field and save, the value reappears in Extras on reopen. But entering account directly in Extras is lost/overwritten.

What you think should happen instead

  • Saving a connection should not delete/overwrite user-supplied keys entered directly in Extras if they’re valid for the connection type.

How to reproduce

  1. Go to Admin → Connections → + (or edit an existing connection).

  2. Set Conn Type = Snowflake.

  3. In Extras (raw JSON), paste:

    {"account": "1234"}
  4. Click Save.

  5. Reopen the connection.

Result: Extras now shows:

{"insecure_mode": false}

Your account key is gone.

Anything else

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    area:providerskind:bugThis is a clearly a bugneeds-triagelabel for new issues that we didn't triage yetprovider:snowflakeIssues related to Snowflake provider

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions