Snowflake cloud connection: KeyPair authentication

[ustas55]

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 with Programming Access Token.

Recently, as of last week, Microsoft released an option of utilizing KeyPair authentication (which is preferred method). Unfortunately, the same model which was successfully refreshing via PAT authentication is failing to refresh with KeyPair account. Both accounts have identical privileges in Snowflake: members of the same role.

The error message I'm receiving states that: “Data source error: Resource Governance: This operation was canceled because there wasn't enough memory to finish running it….”

Any ideas of what could be wrong and/or what could be an issue?

Is KeyPair authentication still in preview mode?

Best Regards,

Sam

[ustas55]

Hi Taylor,

Yes, we do have a ticket open, but not much of the traction on it as of yet.

Once I have some updates from the support, I will update this thread.

[mohitkumawat]

Hi @ustas55 ,

Error  "Resource Governance" usually denotes that a memory threshold was passed during the processing/refresh of your data, and we never see that associated with authentication as much as how big the data is or how complicated the query is.

Solved: Error: Resource Governing - Microsoft Fabric Community

Go back to use PAT/User/Password method temporarily for testing in order to ensure the model still updates successfully. This removes the problem to entirely be in our Key Pair auth setup.

[ustas55]

Thank you Mohit. 

that's exactly what we did, switch the model to use PAT user and model refreshed successfully. I assume that keypair authentication in the cloud is not fully functional?