ADF Snowflake New Connector Issues with KeyPair Authentication and Private Link

Question

ADF Snowflake New Connector Issues with KeyPair Authentication and Private Link

Datta, Vinay 10

We are using Azure Data Factory (ADF) to connect to Snowflake with a Self-hosted Integration Runtime configured for Private Link. Recently, we migrated the Snowflake connector to the latest version that supports Key Pair authentication.

Currently, Basic authentication is set up using the account123.privatelink value in the Snowflake Account identifier field. However, switching to Key Pair authentication is not functioning as expected.

We are suspecting that the JWT token generated may be utilizing the .privatelink extension, leading to authentication failures on the Snowflake side. It works as expected when using the public link which we would like to avoid.

Any assistance would be greatly appreciated.

Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-10-18T12:25:52.7566667+00:00

@Datta, Vinay We are checking with our internal team regarding your issue and will get back to you as soon as possible with an update. Thank you for your patience and understanding.
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-10-18T15:54:18.6066667+00:00

@Datta, Vinay To help us better understand and troubleshoot the issue you're facing, could you please share the exact error message or any additional details you're encountering? This will allow us to review the issue more effectively and provide you with a solution.
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-10-21T04:14:02.25+00:00

@Datta, Vinay We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-10-22T05:24:12.6233333+00:00

@Datta, Vinay We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Datta, Vinay 10 Reputation points

2024-10-24T09:53:36.4433333+00:00

Hi, Apologies for the late reply but this is the error we get when we test the connector.Test connection operation failed. Failed to open the database connection. [Snowflake] 390144 (08004): JWT token is invalid. [55ef8dbf-ce60-4298-bfa2-564b087fd169]

FYI: The account name is configured as account-identifier.privatelink
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-10-24T10:46:20.5966667+00:00

@Datta, Vinay This issue has already been added to our known limitations/bugs backlog, Internal team is working on it. We will keep you informed.
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-11-04T08:53:27.6033333+00:00

Hi @Datta, Vinay
We don't have a defined timeline for this fix yet. But once it is done, we will keep you posted. Thank you for your patience.
Ravikumar S Minajigi 0 Reputation points

2025-04-01T04:04:15.51+00:00

Hi Smaran,

We are facing the issue when we create a linked service using "AutoresolveIntegrationRuntime", "Key Pair" Authentication Type, passed the Private Key file, provided the Private Key Pass Phrase. When I try testing, I am getting the below error:

Test connection operation failed.

Failed to open the database connection.

[Snowflake] 390144 (08004): JWT token is invalid. [16ddfe1e-31bf-4c1b-83bd-76404a1b4aad]

Any help is greatly appreciated.

Thanks,

Ravi

1 answer

Your answer

Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-10-18T12:25:52.7566667+00:00

@Datta, Vinay We are checking with our internal team regarding your issue and will get back to you as soon as possible with an update. Thank you for your patience and understanding.
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-10-18T15:54:18.6066667+00:00

@Datta, Vinay To help us better understand and troubleshoot the issue you're facing, could you please share the exact error message or any additional details you're encountering? This will allow us to review the issue more effectively and provide you with a solution.
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-10-21T04:14:02.25+00:00

@Datta, Vinay We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-10-22T05:24:12.6233333+00:00

@Datta, Vinay We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Datta, Vinay 10 Reputation points

2024-10-24T09:53:36.4433333+00:00

Hi, Apologies for the late reply but this is the error we get when we test the connector.Test connection operation failed. Failed to open the database connection. [Snowflake] 390144 (08004): JWT token is invalid. [55ef8dbf-ce60-4298-bfa2-564b087fd169]

FYI: The account name is configured as account-identifier.privatelink
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-10-24T10:46:20.5966667+00:00

@Datta, Vinay This issue has already been added to our known limitations/bugs backlog, Internal team is working on it. We will keep you informed.
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-11-04T08:53:27.6033333+00:00

Hi @Datta, Vinay
We don't have a defined timeline for this fix yet. But once it is done, we will keep you posted. Thank you for your patience.
Ravikumar S Minajigi 0 Reputation points

2025-04-01T04:04:15.51+00:00

Hi Smaran,

We are facing the issue when we create a linked service using "AutoresolveIntegrationRuntime", "Key Pair" Authentication Type, passed the Private Key file, provided the Private Key Pass Phrase. When I try testing, I am getting the below error:

Test connection operation failed.

Failed to open the database connection.

[Snowflake] 390144 (08004): JWT token is invalid. [16ddfe1e-31bf-4c1b-83bd-76404a1b4aad]

Any help is greatly appreciated.

Thanks,

Ravi

Answer 1

Ravikumar S Minajigi 0

As per the instructions provided in the below link, we followed:
https://docs.snowflake.com/en/user-guide/key-pair-auth

Post creating the Private and Public Keys using the openssl tool commands, assigning the public key to the user in snowflake resolved the issue.

Key things to remember: When creating the linked service for Snowflake, please provide valid account name in the below format:
<myorg-account123>.snowflakecomputing.com

Thanks,

Ravi

Share via

ADF Snowflake New Connector Issues with KeyPair Authentication and Private Link

1 answer

Your answer