Microsoft Security | Microsoft Purview
A unified data governance solution that helps manage, protect, and discover data across your organization
@PRADEEPCHEEKATLA @VISHAL SHARMA - yes, the issue got sorted on its own. Wierd!
Error: (3805)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 91%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SM
5
Reputation points
Hi,
We are trying to run a snowflake scan in Purview and getting the below error: "Error: (3805) Connector Exception: Metadata Table 'INFORMATION_SCHEMA.DATABASES' is not accessible. Please verify 'SELECT' permissions." Its a scheduled scan and was working fine every week until Jan 5th 2024. As per snowflake admin, all the required permissions are in place and nothing changed since Jan 5th.
Any help is appreciated.
Regards, Sorabh
Microsoft Security | Microsoft Purview
-
PRADEEPCHEEKATLA 91,866 Reputation points2024-01-17T05:02:45.1033333+00:00 @SM - Thanks for the question and using MS Q&A platform.
It seems like there is an issue with the SELECT permissions for the INFORMATION_SCHEMA.DATABASES metadata table in Snowflake. This error message indicates that the Microsoft Purview scan is not able to access the metadata table.
To troubleshoot this issue, you can try the following steps:
- Verify that the credentials you set up in Microsoft Purview have the necessary permissions to access the Snowflake account. You can use the
DESCRIBE USER;command in Snowflake to verify the default role of the user you've specified for Microsoft Purview. - Check if there are any changes made to the Snowflake account since Jan 5th. If there are any changes made, you may need to update the credentials in Microsoft Purview accordingly.
- Try to register a new snowflake source and try to see if you able to connect.
For more details, refer to Connect to and manage Snowflake in Microsoft Purview
If none of the above steps help, you may need to open a Support ticket for further assistance.
I hope this helps! Let me know if you have any other questions.
- Verify that the credentials you set up in Microsoft Purview have the necessary permissions to access the Snowflake account. You can use the
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 52%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
VISHAL SHARMA 5 Reputation points2024-01-17T06:55:36.86+00:00 I am facing same issue, earlier it was working fine in different Azure subscription but in new Subscription I am following same steps mention in Microsoft document https://learn.microsoft.com/en-us/purview/register-scan-snowflake but getting same issues.
-
PRADEEPCHEEKATLA 91,866 Reputation points
2024-01-19T00:33:56.2066667+00:00 @SM & VISHAL SHARMA - I agree that this issue looks strange and I wasn't able to reproduce this issue. If you have a support plan could you please file a support ticket for deeper investigation and do share the SR# with us?
-
VISHAL SHARMA 5 Reputation points
2024-01-19T04:20:21.8533333+00:00 It's start working again without changing any access level.
-
PRADEEPCHEEKATLA 91,866 Reputation points
2024-01-19T05:16:53.2566667+00:00 @VISHAL SHARMA - Glad to know that the issue has been resolved.
Sign in to comment
3 answers
Sort by: Most helpful
-
SM 5 Reputation points
2024-01-30T18:36:14.9366667+00:00 -
PRADEEPCHEEKATLA 91,866 Reputation points
2024-01-31T03:59:54.36+00:00 @SM - Glad to know that your issue has been resolved and thanks for updating.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 52%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Debarchan Sarkar - MSFT 1,131 Reputation points Microsoft Employee2024-01-26T05:18:59.5833333+00:00 That's great to hear! Sometimes transient issues can occur with cloud services, which might resolve on their own after a short period. It's possible that was the case here. However, it's still important to monitor the situation moving forward. If the issue recurs, it could indicate a more persistent problem that needs in-depth investigation. Don't hesitate to reach out if you have any further questions or concerns about Microsoft Purview or any other topic. Here are some potential next steps you might consider: Review the results of the successful scan in Purview Studio. Consider setting up alerts or notifications for scan failures to stay informed about similar issues in the future. Explore advanced features of Purview such as data classification, labeling, and cataloging. Look into best practices for configuring and managing your Purview account.
Remember, continuous monitoring and proactive management can help ensure the smooth operation of your data governance efforts with Microsoft Purview.
-
SM 5 Reputation points
2024-01-30T18:39:07.95+00:00 @Debarchan Sarkar - MSFT - any documentation on how to set up alerts for scan failure?
-
Debarchan Sarkar - MSFT 1,131 Reputation points Microsoft Employee
2024-01-31T01:33:33.7566667+00:00 Hi - unfortunately, there is no step by step guide or Purview native out of the box answer to this. You could check out compliance manager tools and explore their alreting mechanisms. Also, as far I understand, You could also use the ScanStatusLogEvent log data to track scan results if you're utilizing Azure Monitor or Log Analytics. The
resultTypefield indicates the status of the scan, which can be "Failed", providing another way to detect and alert on scan failures. Please note that the detailed implementation would need customized coding and/or configuration adjustments based on your specific setup and needs.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 57.99999999999999%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOO%3C/text%3E%3C/svg%3E)
Ortiz Ocio Leire TEF-D 20 Reputation points2024-01-18T11:50:42.4466667+00:00 We have the same problem, and honestly I discard any issue with the configuration on our side as we are Re-running scans that previously (on 02 January 2024) were working properly.
-
VISHAL SHARMA 5 Reputation points
2024-01-19T05:36:10.3866667+00:00 Try now some how it's working again without any change.
-
VISHAL SHARMA 5 Reputation points
2024-01-19T05:37:25.9466667+00:00 @Ortiz Ocio Leire TEF-D : check now it's working without any change.
-
Ortiz Ocio Leire TEF-D 20 Reputation points
2024-01-19T08:03:08.54+00:00 @VISHAL SHARMA Great! It's working again. Thanks a lot!
Sign in to comment -