You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by ro...@apache.org on 2026/05/14 15:19:18 UTC
(airflow) branch feature/update-snowflake-documentation-for-PAT created (now 24aabcce36d)
This is an automated email from the ASF dual-hosted git repository.
romsharon98 pushed a change to branch feature/update-snowflake-documentation-for-PAT
in repository https://gitbox.apache.org/repos/asf/airflow.git
at 24aabcce36d Add PAT connection to snowflake in SnowflakeHook
This branch includes the following new commits:
new 24aabcce36d Add PAT connection to snowflake in SnowflakeHook
The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
(airflow) 01/01: Add PAT connection to snowflake in SnowflakeHook
Posted by ro...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
romsharon98 pushed a commit to branch feature/update-snowflake-documentation-for-PAT
in repository https://gitbox.apache.org/repos/asf/airflow.git
commit 24aabcce36db0a62f3af8a0cd24f5401a0b107f0
Author: rom sharon <ro...@gmail.com>
AuthorDate: Thu May 14 18:19:05 2026 +0300
Add PAT connection to snowflake in SnowflakeHook
---
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"
+ }
+ }'