Snowflake provider: The `private_key_content` field is no longer a multi-line text input in Connections

[mbarugelCA]

Apache Airflow Provider(s)

snowflake

Versions of Apache Airflow Providers

apache-airflow-providers-snowflake==6.0.0

Apache Airflow version

2.10.5

Operating System

Debian GNU/Linux 12 (bookworm)

Deployment

Docker-Compose

Deployment details

No response

What happened

The "Private key (text)" field for Snowflake connections should be a multi-line text input box, but is a password field instead:

This seems to be a regression introduced in this commit. Pasting a private key in PEM format fails because the line breaks do not paste well in the box as is.

This used to work well in version 5.7.0 of the provider.

What you think should happen instead

No response

How to reproduce

Install Apache Airflow with apache-airflow[snowflake]==2.10.5, start the webserver and go to Connections. Open the snowflake_default connection to see the incorrect input type for private key content.

Anything else

This prevents setting up a Snowflake connection with private key authentication.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[gagandeepnum]

Same for us

[rawwar]

Same for us

As a workaround, does it work if you just remove the new lines and pass it as a single line?

You can probably do the below and test it

with open("privatekey.pem", "r") as pem_file:
    single_line_key = "".join(pem_file.read().splitlines())

print(single_line_key)

[rawwar]

it is intentionally updated to be a sensitive field to make it hidden on the UI.

But I think I should also update docs to add some hints to reformat the private key to be in a single line.

[mbarugelCA]

@rawwar I haven't tried this but I don't think it would work, because the -----BEGIN PRIVATE KEY----- should be in its own line afaik.

[rawwar]

@rawwar I haven't tried this but I don't think it would work, because the -----BEGIN PRIVATE KEY----- should be in its own line afaik.

I don't have a Snowflake account handy; if you can, please try it and confirm here. Thanks!