If you are trying to setup a new Elasticube using the Snowflake ODBC connection functionality, but keep getting a password related connection error (image1), there might be a need to hardcode the credentials in the Windows Registry.
(image1)
According to the Snowflake documentation this is a safety precaution by Windows: "The Password field accepts a value, but does not store the value. This is a security precaution to ensure passwords are never stored directly in the driver."
To workaround that, we can hard code the credentials in the Windows Registry. To do so, please follow the steps below:
- Open the Registry Editor (Windows key + R and then type regedit).
- Once it's open, navigate to
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\{Snowflake driver name}
- In the right hand pane, right-click on the screen and select New > String value.
- Name this value uid. After adding, right-click on the newly created object and in the Edit String window, enter in the Value data cell the Snowflake login name.
- Repeat step 3.
- Name the new value pwd and repeat step 4) but enter the Snowflake password.