Accessing Snowflake with SSO

[SBark_CBRE]

I am trying to create a database connection in ArcGIS Pro to Snowflake using SSO. I have successfully created an OLE DB connection to view my tables, but I'm unable to view their spatial component.

The solution would be to create a database connection and then a query layer, but within the settings to create a db connection under 'Authentication Type' it is only possible to select 'User' - which requires a username and login (not possible via SSO). 

This is confirmed on Esri's help page - "Only user authentication is supported when you connect to Snowflake from ArcGIS."

Is there a possible workaround to accessing my snowflake data through the database connection option? If not, how can I view the spatial component of my tables that have geography fields? 

Info: ArcGIS Pro (v3.0), Enterprise (10.9.1)

[rcGIS]

If anyone else is following up on this, below some recent news shared on a different thread: 

https://community.esri.com/t5/data-pipelines-questions/connect-data-pipelines-to-snowflake-via-sso/m... (Thanks @BethanyScott).

[NanaDei]

Thanks @rcGIS . Yes, work is underway to extend support for additional authentication options, starting with key-pair authentication this year. Please create ideas for other authentication options with any specific security policies, if you are looking to use it in ArcGIS Pro and ArcGIS Enterprise.

[rcGIS]

For everyone in this thread, I have just got informed thorugh ENH-000173235 that key pair authentication will be supported in ArcGIS Enterprise 11.5 and ArcGIS Pro 3.5.