Failed to scan Snowflake source

Question

Failed to scan Snowflake source

Pehrsson, Andreas 65

Hi,

We are trying to run a scan on a registered Snowflake source but get the error:

Error: (3805) Connector Exception: Connection to the database (with URL jdbc:snowflake://xxxxxx.snowflakecomputing.com?db=%22xxxx%22&warehouse=purview_wh&application=Microsoft_Purview) failed: JDBC driver encountered communication error. Message: HTTP status=403

Added x to snowflake url and database name.

The key vault has been added as credential following these instructions https://learn.microsoft.com/en-us/purview/manage-credentials#grant-the-purview-managed-identity-access-to-your-azure-key-vault

What could be the reason for the error?

Thank you

Pehrsson, Andreas 65 Reputation points

2023-10-20T08:49:43.0633333+00:00

We are now getting the error :

failed: Incorrect username or password was specified.

Even though the user and password stored in the used key vault is correct (we are able to sign in to snowflake with same details)
Pehrsson, Andreas 65 Reputation points

2023-10-20T09:29:38.7466667+00:00

Role and permissions has been set up in Snowflake for the user according to instructions https://learn.microsoft.com/en-us/purview/register-scan-snowflake#required-permissions-for-scan
KranthiPakala-MSFT 46,627 Reputation points Microsoft Employee

2023-10-23T23:20:58.67+00:00

@Pehrsson, Andreas Checking to see if the above response was helpful in identifying the root cause of the issue or if you have filed a support ticket for deeper investigation? If you have filed a support ticket, please share the SR# with us here so that we can track it internally.

Thank you
Pehrsson, Andreas 65 Reputation points

2023-10-24T14:08:47.07+00:00

Hi, thank you for the support . The problem was an issue in the Key Vault setup that is solved now.

Another thing Im wondering is if lineage from Snowflake and Power Bi sources will be supported in coming updates of Purview?

Best regards
KranthiPakala-MSFT 46,627 Reputation points Microsoft Employee

2023-10-24T17:48:46.39+00:00

@Pehrsson, Andreas Glad to know your issue has been resolved. On your follow-up question related to lineage, we do not have any confirmation at this point, but I'm aware that product team are looking into those feature request feedback.

If you have any additional feedback, please feel free to log it in Azure Purview IDEAS forum here: https://feedback.azure.com/d365community/forum/82d7bddb-fb24-ec11-b6e6-000d3a4f07b8 and do share the link once it is submitted so that we can share it with respective product owners to further review it.

Accepted answer

0 additional answers

Your answer

Pehrsson, Andreas 65 Reputation points

2023-10-20T08:49:43.0633333+00:00

We are now getting the error :

failed: Incorrect username or password was specified.

Even though the user and password stored in the used key vault is correct (we are able to sign in to snowflake with same details)
Pehrsson, Andreas 65 Reputation points

2023-10-20T09:29:38.7466667+00:00

Role and permissions has been set up in Snowflake for the user according to instructions https://learn.microsoft.com/en-us/purview/register-scan-snowflake#required-permissions-for-scan
KranthiPakala-MSFT 46,627 Reputation points Microsoft Employee

2023-10-23T23:20:58.67+00:00

@Pehrsson, Andreas Checking to see if the above response was helpful in identifying the root cause of the issue or if you have filed a support ticket for deeper investigation? If you have filed a support ticket, please share the SR# with us here so that we can track it internally.

Thank you
Pehrsson, Andreas 65 Reputation points

2023-10-24T14:08:47.07+00:00

Hi, thank you for the support . The problem was an issue in the Key Vault setup that is solved now.

Another thing Im wondering is if lineage from Snowflake and Power Bi sources will be supported in coming updates of Purview?

Best regards
KranthiPakala-MSFT 46,627 Reputation points Microsoft Employee

2023-10-24T17:48:46.39+00:00

@Pehrsson, Andreas Glad to know your issue has been resolved. On your follow-up question related to lineage, we do not have any confirmation at this point, but I'm aware that product team are looking into those feature request feedback.

If you have any additional feedback, please feel free to log it in Azure Purview IDEAS forum here: https://feedback.azure.com/d365community/forum/82d7bddb-fb24-ec11-b6e6-000d3a4f07b8 and do share the link once it is submitted so that we can share it with respective product owners to further review it.

Answer 1

Update: 10/24/2023:
@Pehrsson, Andreas I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .

Error Message:

Error: (3805) Connector Exception: Connection to the database (with URL jdbc:snowflake://xxxxxx.snowflakecomputing.com?db=%22xxxx%22&warehouse=purview_wh&application=Microsoft_Purview) failed: JDBC driver encountered communication error. Message: HTTP status=403

Solution:

The issue was due to improper Key vault configuration. Reconfiguring key vault correctly resolved the connection issue.

If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

I hope this helps!

Update 10/20/2023:
@Pehrsson, Andreas Welcome to Microsoft Q&A forum and thanks for reaching out here.

As per your latest error message I suspect something wrong with your Scan credential's configuration or the keyValut configuration.

Kindly revalidate below troubleshooting steps and if the issue persists, I recommend filing a support ticket for deeper investigation as we need to go through step by step to identify the exact root cause of the issue.

User's image

Hope this helps.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Share via

Failed to scan Snowflake source

0 additional answers

Your answer