Hi, I am looking for connection between UiPath (on Prem) and Snowflake either via OAuth or Key Pair authentication. Unfortunately, we do not have cloud integration services yet, we are only using on prem orchestrator, so we need the ways to connect UiPath [studio](on prem ) to snowflake (only acceptable authentication is via O Auth or Key Pair). Let me know if there is a dedicated way or any workarounds for the same..if so please share some helpful documentation
as you are on on prem you cannot use integration services
this leaves you with using http request activity and snowflake apis
cheers
hii @Anil_G
The best way to connect UiPath (on prem) to Snowflake using Key Pair or OAuth since you lack the cloud Integration Service is to use the Snowflake ODBC Driver along with the UiPath Database Activities package.