This is an automated email from the ASF dual-hosted git repository.
shahar1 pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/airflow.git
The following commit(s) were added to refs/heads/main by this push:
new 4d5649349ff Add PAT connection to snowflake in SnowflakeHook (#66953)
4d5649349ff is described below
commit 4d5649349ffce99264f50bd59c87d320b31bc0cb
Author: rom sharon <[email protected]>
AuthorDate: Fri May 15 08:12:16 2026 +0300
Add PAT connection to snowflake in SnowflakeHook (#66953)
---
providers/snowflake/docs/connections/snowflake.rst | 27 ++++++++++++++++++++--
1 file changed, 25 insertions(+), 2 deletions(-)
diff --git a/providers/snowflake/docs/connections/snowflake.rst
b/providers/snowflake/docs/connections/snowflake.rst
index ffe98e665a7..ba73dd4a5b9 100644
--- a/providers/snowflake/docs/connections/snowflake.rst
+++ b/providers/snowflake/docs/connections/snowflake.rst
@@ -43,7 +43,8 @@ Login
Password
Specify the snowflake password. For public key authentication, the
passphrase for the private key.
- For OAuth, the OAuth Client Secret.
+ For OAuth, the OAuth Client Secret. For Programmatic Access Token (PAT)
authentication, specify
+ the PAT token value.
Schema (optional)
Specify the snowflake schema to be used.
@@ -57,7 +58,9 @@ Extra (optional)
* ``region``: Warehouse region.
* ``warehouse``: Snowflake warehouse name.
* ``role``: Snowflake role.
- * ``authenticator``: To connect using OAuth set this parameter ``oauth``.
+ * ``authenticator``: To connect using OAuth set this parameter ``oauth``.
For Programmatic Access
+ Token (PAT) authentication, no special authenticator is required —
simply set the PAT token as
+ the Password field. See `Snowflake PAT documentation
<https://docs.snowflake.com/en/user-guide/programmatic-access-tokens>`_.
* ``token_endpoint``: Specify token endpoint for external OAuth provider.
* ``grant_type``: Specify grant type for OAuth authentication. Currently
supported: ``refresh_token`` (default), ``client_credentials``.
* ``scope``: Specify OAuth scope to include in the access token request
for any OAuth grant type.
@@ -115,3 +118,23 @@ If serializing with JSON:
"warehouse": "snow-warehouse"
}
}'
+
+JSON format example with Programmatic Access Token (PAT)
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+
+To authenticate using a `Programmatic Access Token
<https://docs.snowflake.com/en/user-guide/programmatic-access-tokens>`_,
+set the PAT token as the password with no special authenticator required:
+
+.. code-block:: bash
+
+ export AIRFLOW_CONN_SNOWFLAKE_DEFAULT='{
+ "conn_type": "snowflake",
+ "login": "user",
+ "password": "<programmatic_access_token>",
+ "extra": {
+ "account": "account",
+ "database": "database",
+ "warehouse": "snow-warehouse",
+ "role": "role"
+ }
+ }'
