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?
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?
It wasn't an install.
Another simple table is taking minutes to load... and that's just the preview.