Forum Discussion
Purview and Snowflake
we are trying to create scans connecting to Snowflake. I successfully created snowflake subscription, established connection creating new data source in Purview and created new scan details following the documentation Microsoft provided. When I try run the scans, I am getting the below error. Can please help what I am missing here. When I look at the log file, I can see the connection is successfully establishing but Metadata Discovery is getting failed. The steps seem to be straight forward, but I am not able to run scans successfully. Please help what I am missing here.
Error: Snowflake Internal Error: Unable to connect. Invalid URI: The hostname could not be parsed. SqlState: 08006, VendorCode: 270001, QueryId:
Errorcode : FailToConnect
OperationItem : snowflake://abcdefg.snowflakecomputing.com/databases/SNOWFLAKE_SAMPLE_DATA/schemas/TPCDS_SF100TCL/tables/CALL_CENTER
Purview successfully establishing the connection and Ingesting successfully but failing at Metadata Discovery state.
Please help how to we resolve this issue.
Sincerely,
Krishna.
1 Reply
This issue is resolved, I make some adjustments to the key vault and Scan level based on the source database.
Thanks,
Krishna.
