Unable to connect to Snowflake

Driver Development
1

Hello

I am trying to connect to Snowflake with Metabase and for the moment no success.
Be advised that i am able to connect to this SNowflake instance with DBeaver using SSO.

In Metabase, when i click the Save button in the database administration page, it opens my browser for SSO well -just like DBeaver does) but then i end up immediately with a timeout after 5.0 s message.

Here is what i see in the Metabase log :
[7f89e3d5-3bbd-4fe7-998b-229082b0104e] 2020-06-17T14:13:28+02:00 ERROR metabase.driver.util Database connection error [7f89e3d5-3bbd-4fe7-998b-229082b0104e] 2020-06-17T14:13:28+02:00 ERROR metabase.api.database Cannot connect to Database [7f89e3d5-3bbd-4fe7-998b-229082b0104e] 2020-06-17T14:13:28+02:00 DEBUG metabase.middleware.log POST /api/database 400 5.0 s (0 DB calls) {:valid false, :dbname "Timed out after 5.0 s", :message "Timed out after 5.0 s"}

Would you have any idea please ?

best
E.

2

Hi @eozturk
Please post “Diagnostic Info” from Admin > Troubleshooting.
Normally the timeout error has something to do with bad network connection - wrong host or port, or a firewall is blocking something.
Unless the SSO process takes more than 5 seconds, then perhaps that’s the problem? You then need to extend the timeout to something longer:
https://github.com/metabase/metabase/blob/master/docs/operations-guide/environment-variables.md#mb_db_connection_timeout_ms

3

Hi flamber

Thank you very much, i’ll try that.