Forum Discussion
Snowflake Conector 2.0 Preview - January 2025
Answering my own question here... The syntax seems a bit different to the doc.
[Role=SF_Access_Role, Implementation="2.0"]
This
Source = Snowflake.Databases(SF_Address,SF_Warehouse, Implementation="2.0", [Role=SF_Access_Role]),
becomes
Source = Snowflake.Databases(SF_Address,SF_Warehouse, Implementation="2.0", [Role=SF_Access_Role, Implementation="2.0"]),It seemed very slow initially to retrieve a simple data set.
2nd go was quite fast. I'll have to try another table now... there may have been a background install maybe?
Hi dgwilson ,
Im getting below error when I removed the 2.0 part from the power query.
let
Source = Snowflake.Databases("uyt10278.west-us-2.azure.snowflakecomputing.com","COMPUTED_WH"),
XHANCE_OPTINOSE_Database = Source{[Name="XHANCE_OPTINOSE",Kind="Database"]}[Data],
XHANCE_OPTINOSE_DEV__HARSHAD_PARDESHI_Schema = XHANCE_OPTINOSE_Database{[Name="XHANCE_OPTINOSE_DEV__HARSHAD_PARDESHI",Kind="Schema"]}[Data],
FCT_MEDIA_KPIS_View = XHANCE_OPTINOSE_DEV__HARSHAD_PARDESHI_Schema{[Name="FCT_MEDIA_KPIS",Kind="View"]}[Data]
in
FCT_MEDIA_KPIS_View
Error:
DataSource.Error: ODBC: ERROR [HY000] [Microsoft][Snowflake] (4)
REST request for URL *** failed: CURLerror (curl_easy_perform() failed) - code=60 msg='SSL peer certificate or SSH remote key was not OK'.
Details:
DataSourceKind=Snowflake
DataSourcePath=uza80192.east-us-2.azure.snowflakecomputing.com;COMPUTE_WH
OdrbcErrors=[Table]
Hello,
I'm not expert but that looks like some issue that people had with ZScaler? If your organization have ZScaler set up on your machines, you might want to look into the related topics.