Hi All,
I'm trying to utilize snowflake connector to connect to the Snowflake DB through Key pair authentication. Though the parameters are correct and we can establish the connectivity otherwise, connectivity from OutSystems is returning error status 403.
Please suggest if any modifications that might be needed to avoid this error.
Please see if this this discussion helps @ https://www.outsystems.com/forums/discussion/94175/snowflake-connector-snowflake-connector-keypairauth/
It seams that you have authentication issue. Please check following articles. It might help you.
https://community.snowflake.com/s/article/How-to-connect-to-Snowflake-from-OutSystems
https://www.outsystems.com/forums/discussion/65010/snowflake-connector-documentation/
Hi Priyadharshini Sridharan!Are you using this Forge Component ?I used this Forge component, and filled all the mandatory inputs and everything worked wellThese are the mandatory parameters that you must fill in and I will help you with this task.
For Username and Password parameters, you just have to use the set you used to log in your account.
Regarding Port and Role, although they are required, you don’t need to fill them to retrieve you entity’s data, so you can leave them as empty text.
For Scheme, Warehouse and Database parameters you will find the information you need to fill these parameters in the image below, in your snowflake account.
For the two remaining parameters, the Account and the Host, you will use the values inside the red border box, in the URL of the image below, to fill them. For the Account you just have to link them with the “-“ character in the middle, instead of "/". Regarding the Host you just have to add “.snowflakecomputing.com“ to you Account previously created and you will get your Host.Note: This is the way I found to integrate a snowflake entity with an OutSytems application and it may not be the only way to do it. Feel free to reach me out if you need.