Skip to Content (Press Enter)
UserImage.jpg
saravanakumar v
19Views
4Comments
getting invalid username and password in snowflake
Question
Beginner

Hi All

I am getting an invalid username and password error message when i try to execute a query using snowflake connector in outsystems (same as snowflake demo project). when i use the same username and password in snowflake to login using SSO it is working.

Question 1

Do we need to pass some more information in extra param for connection ? if yes, what parameters needs to be passed. please advise

Question 2

Do we need to do any other functionality other than the demo project ? kindly confirm

Thanks

kumar

0
0
29 May 2024
Copy Link
2021-11-12 04-59-31
Manikandan Sambasivam

Question 1: Extra Parameters for Connection

Yes, you might need to pass additional parameters in the connection string when using Snowflake's connector, especially if you are using SSO (Single Sign-On) or other specific configurations. Here are some key parameters you may need to include:

  1. Authenticator: Specifies the type of authentication. If you are using SSO, you need to specify the authenticator parameter. This parameter directs the Snowflake connector to use an external browser for authentication, which is typically required for SSO.
  2. Account: Specifies your Snowflake account name.
  3. Role: Specifies the default role for the session. 
  4. Warehouse: Specifies the default warehouse for the session. 
  5. Database and Schema: Specifies the default database and schema for the session. 

Question 2: Other Functionalities or Configurations

  1. Network Policies: Ensure that your network policies allow connections from your OutSystems environment to Snowflake. This might involve configuring firewalls, VPCs, or proxies.
  2. Snowflake Permissions: Ensure the user has the necessary permissions in Snowflake to access the database, schema, and execute queries.
  3. SSO Configuration: If you are using SSO, ensure it is correctly configured in Snowflake. This typically involves setting up an Identity Provider (IdP) and configuring the Snowflake account to trust the IdP.
  4. Environment Variables: Ensure any required environment variables for Snowflake connection are correctly set in your OutSystems environment.


0
0
29 May 2024
Copy Link
UserImage.jpg
saravanakumar v

Hi Manikandan Sambasivam

I am trying to use oauth as authenticator and pass the token in the extra parameter but still i am getting invalid username and password. any idea on it ?

Thanks

Kumar

0
0
29 May 2024
Copy Link
2021-11-12 04-59-31
Manikandan Sambasivam

please share me the oml file

0
0
29 May 2024
Copy Link
UserImage.jpg
saravanakumar v

Hi Mani

I cannot share the oml file due to client security concerns. i have just mimicked the same what is given in the demo application of snowflake connector. i did not do any other configuration additional other than that

Thanks

Kumar

0
0
29 May 2024
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.