Forum Discussion

ustas55's avatar
ustas55
Helper II
9 months ago
Solved

Snowflake cloud connection: KeyPair authentication

Good Day Professionals,   We have a cloud connection to the Snowflake and successfully used it with "regular" authentication via user/password. The Snowflake user was configured as SYSTEM account w...
Need Help
  • ustas55's avatar
    ustas55
    8 months ago

    Hi to all,

    Quick update on this issue (Key-Pair authentication between Snowflake and Power BI).

    Finally got a “solution” from the support and was able refresh the model using Key-Pair authentication.

    What I ended up doing is to enable “Use legacy Snowflake connector implementation” within Preview features.

    According to Microsoft support: “Currently, Implementation 2.0 consumes more memory, which the engineering team is actively working to optimize. This issue has been documented in the reference document below, and the document will be updated once the fix is implemented and released”.

     

    Thank you.

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
8 months ago

Hi ustas55,

Could you please confirm if the issue has been resolved after raising the support ticket?

 

Thank you.

  • ustas55's avatar
    ustas55
    Helper II
    8 months ago

    Hi,

    Unfortunatelly, not yet. Support is still woring on my ticket, and I was told that ".... we're still waiting an update from our team.".....

    • diabb8899's avatar
      diabb8899
      Frequent Visitor
      5 months ago

      Hi ustas55 , any update from MS support on the issue? they release the update in Feb , did it help resolve ? or you are still having memory issues.

      • ustas55's avatar
        ustas55
        Helper II
        5 months ago

        Hi diabb8899, I wasn't aware of any updates with this connector, so for now we're using a user with PAT authentication. Actually, few days ago I did check documentation on Snowflake connector and didn't see any changes with known issues; same high memory utilization when using Implementation-2 option.

         

        Best Regards,

        Sam