apache/airflow

Airflow Snowflake connection: extra JSON silently overwritten

Open

#57984 opened on Nov 6, 2025

View on GitHub
 (3 comments) (0 reactions) (0 assignees)Python (44,809 stars) (16,781 forks)batch import
_eol_affected_version:2.11area:providersgood first issuekind:bugprovider:snowflake

Description

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

Contributor guide

Tech stack
python
Domain
backenddatabase
Issue type
bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Python basicsAirflow connection basics
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65
Research direction
Look at the snowflake provider's connection extras handling, likely in `airflow/providers/snowflake/hooks/snowflake.py` or the connection form in `airflow/www/forms.py`. Examine how extras are merged with default values. Check if there is a mapping from the form fields to extras that overwrites user input. The issue suggests that the dedicated Snowflake field overwrites extras. The fix should ensure user supplied extras are not overwritten unless they collide with form fields. Also review any existing tests for Snowflake connection.