Using Desktop, I'm able to convert connections to Key Pair and publish to Cloud no problem
However, if I change the Workbook ownership in Cloud or edit the Workbook in Cloud, it will cause Extracts to fail.
So are we stuck using Desktop for all Workbook changes going forward because of the Key Pair auth?
#Tableau Cloud
Unfortunatelly, the only way to set key pair credentials for Snowflake is using Tableau Desktop and publishing the datasource to Tableau Cloud.
Thus, you have two options:
a. You may preserve the ownership of the user who publishes the datasource/workbook and give the refresh extract permission to other users. (yeah there is a recently new permission for this)
b. The new owner, using Tableau Desktop, may need to connect to the published datasource, create a local copy, and publish again the datasource using the key pair stored under their user.
I would also recommend to look and upvote ideas already created in salesforce idea forum:
https://ideas.salesforce.com/s/idea/a0B8W00000QeoSrUAJ/add-snowflake-key-pair-option-to-tableau-cloud-web-authoringIf this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Tableau Ambassador
