snowflake-grafana-datasource icon indicating copy to clipboard operation
snowflake-grafana-datasource copied to clipboard

Published 20 hours ago • verified publisher icon michelin

Validation query error : 390100 (08004): Incorrect username or password was specified.

Open reshdesu opened this issue 1 year ago • 2 comments

Even after specifying correct id and password the package fails to connect to snowflake. Things that I can share,

  1. Our snowflake admins were able to look at their logs and noted a rejection for wrong password on their end. 5-16-2024 3-47-45 PM
  2. Using snowflake UI allows me to log in with the account.
  3. We tried with 2 accounts, one with some special characters in password and other with a very simple alphanumeric password

reshdesu avatar May 16 '24 19:05 reshdesu

I can't reproduce your problem.

  • Which version of Grafana and plugin do you use?
  • Do you have any other errors in Grafana logs?

devnied avatar May 17 '24 08:05 devnied

Same issue on my side

nalberto avatar Jun 06 '24 02:06 nalberto

This is an issue when the password contains a + (plus sign), because getConnectionString uses url.UserPassword (which does not URL-escape +) while the gosnowflake library uses url.QueryUnescape in ParseDSN, which does unescape the + to a space character . @devnied , I can submit a patch for this (which I've verified as working) if you'd like to reopen this issue.

a2intl avatar Nov 30 '24 20:11 a2intl