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?
I had a major issue with the new Snowflake implementation.
It works fine in Desktop, but not in Service.
When using a native Snowflake query, I would get the expected number of rows, but with wrong data.
ID fields (long text strings) would replicate the same value on other, otherwise correct, rows.
Note that it's not row duplication. For example, suppose this is the correct query values:
| Product_ID | Product_Name |
| aaaaaaaaaaaaaa | Apple |
| bbbbbbbbbbbb | Bannana |
| ccccccccccccccc | Cereals |
| dddddddddddd | Donut |
The Service refresh would return:
| Product_ID | Product_Name |
| aaaaaaaaaaaaaa | Apple |
| bbbbbbbbbbbb | Bannana |
| bbbbbbbbbbbb | Cereals |
| bbbbbbbbbbbb | Donut |
It was hard picking up the reason for this. Removing the Implementation="2.0" tag fixed the issue.
It's really important that goes as feedback to the Microsoft team. I'm not exactly sure how to do that... I do recall that there may have been a feedback either in Power Query somewhere or on the Web page with the release details. Yea - found it. https://learn.microsoft.com/en-us/power-query/connectors/snowflake - that's the link to the Snowflake documentation. About half way down it tallks about the new connector and has a link for feedback - https://aka.ms/snowflake-connector-feedback - it's really important you provide this experience and direct feedback to the team.