Sharashchandra opened a new pull request, #47191: URL: https://github.com/apache/airflow/pull/47191
This PR enhances the SnowflakeHook in the Airflow repo by completing the OAuth authentication flow. It adds logic to fetch the access token using the refresh_token, client_id, and client_secret, which are already managed in the extras of the Snowflake connection object. Changes & Fixes: Implements logic to exchange the refresh_token for a new access token before establishing a connection. Resolves an issue where using refresh_token, client_id, and client_secret directly with SnowflakeHook results in the error: main/newsfragments). snowflake.connector.errors.DatabaseError: 250001 (08001): None: Failed to connect to DB: <account>.snowflakecomputing.com:443. Invalid OAuth access token. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
