Snowflake - Failed to connect to Database

Hi,

We are running into an issue where our Snowflake connection is being timed out. The same configuration settings were working fine. We are running the open source version of metabase inside a container (on EC2) and our snowflake is hosted on AWS. Here is our diagnostic tool output. I've tried the following:

  1. Installed updated ojdbc8.jar
  2. Upgraded metabase to v0.50.6 (previously it was 0.46)
  3. Increased timeout from 10 seconds to 30 seconds to see if the initial setup was taking time
  4. My EC2 host is able to connect to my snowflake URL

Any leads would be appreciated, thank you.

{
  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.23+9",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.23",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.23+9",
    "os.name": "Linux",
    "os.version": "6.1.34-58.102.amzn2023.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "snowflake",
      "bigquery-cloud-sdk"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "14.10"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.7.3"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2024-06-19",
      "tag": "v0.50.6",
      "hash": "a5fbebf"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

What error are you getting in the logs?

Are you sure there was no change to the network?

I'm getting:

[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:09:30+05:00 DEBUG metabase.server.middleware.log PUT /api/database/3 400 30.2 s (1 DB calls) {:metabase-user-id 2} 
{:message "Timed out after 30.0 s"}

Yep, no change. Other databases are working fine e.g. BigQuery.

When you say My EC2 host is able to connect to my snowflake URL ... Is metabase running on the same EC2 host?

Yes, as a docker container.

Adding more logs, if they are relevant:

=> java.lang.String
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:10:48+05:00 ERROR metabase.api.database Cannot connect to Database,clojure.lang.ExceptionInfo: Timed out after 30.0 s {:message "Timed out after 30.0 s"},	at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:166),	at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:137),	at clojure.lang.RestFn.invoke(RestFn.java:442),	at metabase.api.database$test_database_connection.invokeStatic(database.clj:728),	at metabase.api.database$test_database_connection.doInvoke(database.clj:718),	at clojure.lang.RestFn.invoke(RestFn.java:425),	at metabase.api.database$fn__94146.invokeStatic(database.clj:937),	at metabase.api.database$fn__94146.invoke(database.clj:912),	at compojure.core$wrap_response$fn__52891.invoke(core.clj:160),	at compojure.core$wrap_route_middleware$fn__52875.invoke(core.clj:132),	at compojure.core$wrap_route_info$fn__52880.invoke(core.clj:139),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:151),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at metabase.server.middleware.auth$enforce_authentication$fn__97198.invoke(auth.clj:18),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at compojure.core$make_context$handler__52931.invoke(core.clj:290),	at compojure.core$make_context$fn__52935.invoke(core.clj:300),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at metabase.api.routes$fn__103641$fn__103644.invoke(routes.clj:73),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.core$apply.invokeStatic(core.clj:667),	at clojure.core$apply.invoke(core.clj:662),	at metabase.server.routes$fn__103921$fn__103922.doInvoke(routes.clj:73),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at compojure.core$make_context$handler__52931.invoke(core.clj:290),	at compojure.core$make_context$fn__52935.invoke(core.clj:300),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at metabase.server.routes$fn__103904$fn__103906.invoke(routes.clj:47),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__100069.invoke(exceptions.clj:107),	at metabase.server.middleware.exceptions$catch_api_exceptions$fn__100066.invoke(exceptions.clj:96),	at metabase.server.middleware.log$log_api_call$fn__104201$fn__104202$fn__104203.invoke(log.clj:236),	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:18),	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:12),	at metabase.server.middleware.log$log_api_call$fn__104201$fn__104202.invoke(log.clj:227),	at toucan2.execute$do_with_call_counts.invokeStatic(execute.clj:112),	at toucan2.execute$do_with_call_counts.invoke(execute.clj:103),	at metabase.server.middleware.log$log_api_call$fn__104201.invoke(log.clj:226),	at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__107467.invoke(browser_cookie.clj:40),	at metabase.server.middleware.security$add_security_headers$fn__100025.invoke(security.clj:238),	at ring.middleware.json$wrap_json_body$fn__107726.invoke(json.clj:64),	at metabase.server.middleware.offset_paging$handle_paging$fn__86507.invoke(offset_paging.clj:43),	at metabase.server.middleware.json$wrap_streamed_json_response$fn__54346.invoke(json.clj:83),	at ring.middleware.keyword_params$wrap_keyword_params$fn__107815.invoke(keyword_params.clj:55),	at ring.middleware.params$wrap_params$fn__107834.invoke(params.clj:77),	at metabase.server.middleware.misc$maybe_set_site_url$fn__69793.invoke(misc.clj:60),	at metabase.server.middleware.session$reset_session_timeout$fn__76937.invoke(session.clj:552),	at metabase.server.middleware.session$bind_current_user$fn__76903$fn__76904.invoke(session.clj:446),	at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:425),	at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:408),	at metabase.server.middleware.session$bind_current_user$fn__76903.invoke(session.clj:445),	at metabase.server.middleware.session$wrap_current_user_info$fn__76884.invoke(session.clj:383),	at metabase.server.middleware.session$wrap_session_id$fn__76856.invoke(session.clj:259),	at metabase.server.middleware.auth$wrap_static_api_key$fn__97206.invoke(auth.clj:32),	at ring.middleware.cookies$wrap_cookies$fn__107654.invoke(cookies.clj:200),	at metabase.server.middleware.misc$add_content_type$fn__69775.invoke(misc.clj:28),	at metabase.server.middleware.misc$disable_streaming_buffering$fn__69801.invoke(misc.clj:77),	at ring.middleware.gzip$wrap_gzip$fn__107696.invoke(gzip.clj:86),	at metabase.server.middleware.misc$bind_request$fn__69804.invoke(misc.clj:94),	at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__107483.invoke(ssl.clj:41),	at metabase.server$async_proxy_handler$fn__70139.invoke(server.clj:77),	at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source),	at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:173),	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122),	at org.eclipse.jetty.server.Server.handle(Server.java:563),	at org.eclipse.jetty.server.HttpChannel$RequestDispatchable.dispatch(HttpChannel.java:1598),	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:753),	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:501),	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:287),	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314),	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100),	at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:421),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:199),	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411),	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969),	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194),	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149),	at java.base/java.lang.Thread.run(Unknown Source),Caused by: java.util.concurrent.TimeoutException: Timed out after 30.0 s,	at metabase.util.jvm$deref_with_timeout.invokeStatic(jvm.clj:287),	at metabase.util.jvm$deref_with_timeout.invoke(jvm.clj:279),	at metabase.util.jvm$do_with_timeout.invokeStatic(jvm.clj:294),	at metabase.util.jvm$do_with_timeout.invoke(jvm.clj:290),	at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:148),	... 190 more
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:10:48+05:00 DEBUG metabase.server.middleware.log PUT /api/database/3 400 30.0 s (1 DB calls) {:metabase-user-id 2} 
{:message "Timed out after 30.0 s"}

[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:10:49+05:00 DEBUG metabase.server.middleware.log GET /api/database 200 16.5 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (36 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:10:51+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"ME8wTTBLMEkwRzAHBgUrDgMCGgQUKhyPrHZmqWsEJ3C9a6QhGWfIE0gEFFXZGF\/SHMwB4Vi0vqvZVUIB1y4CAhAIgJFyPSIo\/EPFUhFZ5mp3","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.aws.snowflakecomputing.com","ocspResponderURL":"http:\/\/ocsp.r2m03.amazontrust.com","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEcwBwYFKw4DAhoEFCocj6x2ZqlrBCdwvWukIRlnyBNIBBRV2Rhf0hzMAeFYtL6r2VVCAdcuAgIQCICRcj0iKPxDxVIRWeZqdw=="}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:00+05:00 INFO metabase.task.sync-databases Starting sync task for Database 4.
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:01+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"MFIwUDBOMEwwSjAHBgUrDgMCGgQUT1mjlFPPuVWef2vYxU2lPaZCtxQEFIQYzIU07LwMlJQuCFmcx7IQTgoIAhMHcxJM1AbSZ8CZHN0pmp84MXmF","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.aws.snowflakecomputing.com","ocspResponderURL":"http:\/\/ocsp.rootca1.amazontrust.com","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEowBwYFKw4DAhoEFE9Zo5RTz7lVnn9r2MVNpT2mQrcUBBSEGMyFNOy8DJSULghZnMeyEE4KCAITB3MSTNQG0mfAmRzdKZqfODF5hQ=="}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:11+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"MFIwUDBOMEwwSjAHBgUrDgMCGgQUiH2kRF5n6nyUd05DGJw+zuTIcxIEFJxfAN+qAdcwKziIorhtSpzyEZGDAhMGf5RKKifN8\/rCrisB+QjuucTG","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.aws.snowflakecomputing.com","ocspResponderURL":"http:\/\/ocsp.rootg2.amazontrust.com","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEowBwYFKw4DAhoEFIh9pEReZ+p8lHdOQxicPs7kyHMSBBScXwDfqgHXMCs4iKK4bUqc8hGRgwITBn+USionzfP6wq4rAfkI7rnExg=="}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:21+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"MEgwRjBEMEIwQDAHBgUrDgMCGgQUi8GehFuYHWHPVGkhGmi44xEzbZAEFL9ft9HO3R+G9FtVrNzXEMIOqYjnAgkApw5KTDSCt38=","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.aws.snowflakecomputing.com","ocspResponderURL":"http:\/\/o.ss2.us\/","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEAwBwYFKw4DAhoEFIvBnoRbmB1hz1RpIRpouOMRM22QBBS\/X7fRzt0fhvRbVazc1xDCDqmI5wIJAKcOSkw0grd\/"}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:21+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"ME8wTTBLMEkwRzAHBgUrDgMCGgQUKhyPrHZmqWsEJ3C9a6QhGWfIE0gEFFXZGF\/SHMwB4Vi0vqvZVUIB1y4CAhAIgJFyPSIo\/EPFUhFZ5mp3","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.aws.snowflakecomputing.com","ocspResponderURL":"http:\/\/ocsp.r2m03.amazontrust.com","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEcwBwYFKw4DAhoEFCocj6x2ZqlrBCdwvWukIRlnyBNIBBRV2Rhf0hzMAeFYtL6r2VVCAdcuAgIQCICRcj0iKPxDxVIRWeZqdw=="}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:21+05:00 ERROR net.snowflake.client.core.HeartbeatBackground heartbeat error - message=Session no longer exists.  New login required to access the service.,net.snowflake.client.jdbc.SnowflakeSQLException: Session no longer exists.  New login required to access the service.,	at net.snowflake.client.jdbc.SnowflakeUtil.checkErrorAndThrowExceptionSub(SnowflakeUtil.java:161),	at net.snowflake.client.jdbc.SnowflakeUtil.checkErrorAndThrowException(SnowflakeUtil.java:94),	at net.snowflake.client.core.SFSession.heartbeat(SFSession.java:985),	at net.snowflake.client.core.HeartbeatBackground.run(HeartbeatBackground.java:192),	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source),	at java.base/java.util.concurrent.FutureTask.run(Unknown Source),	at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source),	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source),	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source),	at java.base/java.lang.Thread.run(Unknown Source)
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:30+05:00 ERROR metabase.driver.util Failed to connect to Database,java.util.concurrent.TimeoutException: Timed out after 30.0 s,	at metabase.util.jvm$deref_with_timeout.invokeStatic(jvm.clj:287),	at metabase.util.jvm$deref_with_timeout.invoke(jvm.clj:279),	at metabase.util.jvm$do_with_timeout.invokeStatic(jvm.clj:294),	at metabase.util.jvm$do_with_timeout.invoke(jvm.clj:290),	at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:148),	at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:137),	at clojure.lang.RestFn.invoke(RestFn.java:442),	at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_$fn__108508$fn__108509.invoke(sync_databases.clj:82),	at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_$fn__108508.invoke(sync_databases.clj:81),	at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_.invokeStatic(sync_databases.clj:78),	at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_.invoke(sync_databases.clj:71),	at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:107),	at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:95),	at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:112),	at org.quartz.core.JobRunShell.run(JobRunShell.java:202),	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:11:30+05:00 ERROR metabase.driver.snowflake (type message)

Are you sure the credentials are correct and nothing changed? There seem to be a bunch of snowflake related network errors there

ERROR net.snowflake.client.core.HeartbeatBackground heartbeat error - message=Session no longer exists.

Can you try to create a new connection to snowflake with the same credentials and see what happens?

I just created a new connection with the same credentials.

=> java.lang.String
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:36:48+05:00 ERROR metabase.api.database Cannot connect to Database,clojure.lang.ExceptionInfo: Timed out after 30.0 s {:message "Timed out after 30.0 s"},	at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:166),	at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:137),	at clojure.lang.RestFn.invoke(RestFn.java:442),	at metabase.api.database$test_database_connection.invokeStatic(database.clj:728),	at metabase.api.database$test_database_connection.doInvoke(database.clj:718),	at clojure.lang.RestFn.invoke(RestFn.java:425),	at metabase.api.database$test_connection_details.invokeStatic(database.clj:782),	at metabase.api.database$test_connection_details.invoke(database.clj:762),	at metabase.api.database$fn__94101.invokeStatic(database.clj:803),	at metabase.api.database$fn__94101.invoke(database.clj:786),	at compojure.core$wrap_response$fn__52891.invoke(core.clj:160),	at compojure.core$wrap_route_middleware$fn__52875.invoke(core.clj:132),	at compojure.core$wrap_route_info$fn__52880.invoke(core.clj:139),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:151),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:152),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at metabase.server.middleware.auth$enforce_authentication$fn__97198.invoke(auth.clj:18),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at compojure.core$make_context$handler__52931.invoke(core.clj:290),	at compojure.core$make_context$fn__52935.invoke(core.clj:300),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$make_context$fn__52935.invoke(core.clj:301),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.lang.AFunction$1.doInvoke(AFunction.java:31),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at clojure.lang.Var.invoke(Var.java:393),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at metabase.api.routes$fn__103641$fn__103644.invoke(routes.clj:73),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at clojure.lang.AFn.applyToHelper(AFn.java:160),	at clojure.lang.AFn.applyTo(AFn.java:144),	at clojure.core$apply.invokeStatic(core.clj:667),	at clojure.core$apply.invoke(core.clj:662),	at metabase.server.routes$fn__103921$fn__103922.doInvoke(routes.clj:73),	at clojure.lang.RestFn.invoke(RestFn.java:436),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at compojure.core$make_context$handler__52931.invoke(core.clj:290),	at compojure.core$make_context$fn__52935.invoke(core.clj:300),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at compojure.core$wrap_route_matches$fn__52884.invoke(core.clj:153),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903$f__52904$respond_SINGLEQUOTE___52905.invoke(core.clj:197),	at metabase.server.routes$fn__103904$fn__103906.invoke(routes.clj:47),	at compojure.core$routes$fn__52903$f__52904.invoke(core.clj:198),	at compojure.core$routes$fn__52903.invoke(core.clj:200),	at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__100069.invoke(exceptions.clj:107),	at metabase.server.middleware.exceptions$catch_api_exceptions$fn__100066.invoke(exceptions.clj:96),	at metabase.server.middleware.log$log_api_call$fn__104201$fn__104202$fn__104203.invoke(log.clj:236),	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:18),	at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:12),	at metabase.server.middleware.log$log_api_call$fn__104201$fn__104202.invoke(log.clj:227),	at toucan2.execute$do_with_call_counts.invokeStatic(execute.clj:112),	at toucan2.execute$do_with_call_counts.invoke(execute.clj:103),	at metabase.server.middleware.log$log_api_call$fn__104201.invoke(log.clj:226),	at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__107467.invoke(browser_cookie.clj:40),	at metabase.server.middleware.security$add_security_headers$fn__100025.invoke(security.clj:238),	at ring.middleware.json$wrap_json_body$fn__107726.invoke(json.clj:64),	at metabase.server.middleware.offset_paging$handle_paging$fn__86507.invoke(offset_paging.clj:43),	at metabase.server.middleware.json$wrap_streamed_json_response$fn__54346.invoke(json.clj:83),	at ring.middleware.keyword_params$wrap_keyword_params$fn__107815.invoke(keyword_params.clj:55),	at ring.middleware.params$wrap_params$fn__107834.invoke(params.clj:77),	at metabase.server.middleware.misc$maybe_set_site_url$fn__69793.invoke(misc.clj:60),	at metabase.server.middleware.session$reset_session_timeout$fn__76937.invoke(session.clj:552),	at metabase.server.middleware.session$bind_current_user$fn__76903$fn__76904.invoke(session.clj:446),	at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:425),	at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:408),	at metabase.server.middleware.session$bind_current_user$fn__76903.invoke(session.clj:445),	at metabase.server.middleware.session$wrap_current_user_info$fn__76884.invoke(session.clj:383),	at metabase.server.middleware.session$wrap_session_id$fn__76856.invoke(session.clj:259),	at metabase.server.middleware.auth$wrap_static_api_key$fn__97206.invoke(auth.clj:32),	at ring.middleware.cookies$wrap_cookies$fn__107654.invoke(cookies.clj:200),	at metabase.server.middleware.misc$add_content_type$fn__69775.invoke(misc.clj:28),	at metabase.server.middleware.misc$disable_streaming_buffering$fn__69801.invoke(misc.clj:77),	at ring.middleware.gzip$wrap_gzip$fn__107696.invoke(gzip.clj:86),	at metabase.server.middleware.misc$bind_request$fn__69804.invoke(misc.clj:94),	at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__107483.invoke(ssl.clj:41),	at metabase.server$async_proxy_handler$fn__70139.invoke(server.clj:77),	at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source),	at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:173),	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122),	at org.eclipse.jetty.server.Server.handle(Server.java:563),	at org.eclipse.jetty.server.HttpChannel$RequestDispatchable.dispatch(HttpChannel.java:1598),	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:753),	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:501),	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:287),	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314),	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100),	at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:421),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277),	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:199),	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411),	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969),	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194),	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149),	at java.base/java.lang.Thread.run(Unknown Source),Caused by: java.util.concurrent.TimeoutException: Timed out after 30.0 s,	at metabase.util.jvm$deref_with_timeout.invokeStatic(jvm.clj:287),	at metabase.util.jvm$deref_with_timeout.invoke(jvm.clj:279),	at metabase.util.jvm$do_with_timeout.invokeStatic(jvm.clj:294),	at metabase.util.jvm$do_with_timeout.invoke(jvm.clj:290),	at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:148),	... 188 more
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:36:48+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"MEgwRjBEMEIwQDAHBgUrDgMCGgQUi8GehFuYHWHPVGkhGmi44xEzbZAEFL9ft9HO3R+G9FtVrNzXEMIOqYjnAgkApw5KTDSCt38=","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.aws.snowflakecomputing.com","ocspResponderURL":"http:\/\/o.ss2.us\/","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEAwBwYFKw4DAhoEFIvBnoRbmB1hz1RpIRpouOMRM22QBBS\/X7fRzt0fhvRbVazc1xDCDqmI5wIJAKcOSkw0grd\/"}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:36:48+05:00 DEBUG metabase.server.middleware.log POST /api/database 400 30.0 s (1 DB calls) {:metabase-user-id 2} 
{:message "Timed out after 30.0 s"}

[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:36:48+05:00 DEBUG metabase.server.middleware.log GET /api/database 200 13.1 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 4/50 (3 idle, 0 queued) (40 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:36:51+05:00 ERROR net.snowflake.client.core.SFTrustManager WARNING!!! Using fail-open to connect. Driver is connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use from the CA OCSP responder. Details: 
{"cacheEnabled":true,"ocspReqBase64":"MEgwRjBEMEIwQDAHBgUrDgMCGgQUi8GehFuYHWHPVGkhGmi44xEzbZAEFL9ft9HO3R+G9FtVrNzXEMIOqYjnAgkApw5KTDSCt38=","ocspMode":"FAIL_OPEN","sfcPeerHost":"nw18763.ap-south-1.snowflakecomputing.com","ocspResponderURL":"http:\/\/o.ss2.us\/","cacheHit":false,"eventType":"OCSPValidationError","certId":"MEAwBwYFKw4DAhoEFIvBnoRbmB1hz1RpIRpouOMRM22QBBS\/X7fRzt0fhvRbVazc1xDCDqmI5wIJAKcOSkw0grd\/"}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:37:27+05:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 41.8 ms (10 DB calls) App DB connections: 1/4 Jetty threads: 4/50 (3 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:37:27+05:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 49.1 ms (7 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:37:27+05:00 DEBUG metabase.server.middleware.log GET /api/database 200 30.1 ms (1 DB calls) App DB connections: 2/4 Jetty threads: 4/50 (3 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:37:27+05:00 DEBUG metabase.server.middleware.log GET /api/setting 200 41.5 ms (10 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:37:27+05:00 DEBUG metabase.server.middleware.log GET /api/search 200 54.7 ms (4 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}
[b9214cf8-1f46-482e-b59c-09b9fd9706f9] 2024-06-24T17:37:27+05:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 25.4 ms (6 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (39 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 2}

Are you able to create the connection or it says Failed? Since it doesn't look like you are able to ... Ao are you sure you are able to connect in the first place?

Ah, sorry for the confusion. My connection is not created. It fails with the timeout and I get the above logs.

So it seems there is a problem with the credentials or with some certificate you are providing? You can download Dbeaver and try to connect to snowflake to see if it's a metabase issue or just a snowflake issue

Got it, let me try that. Thank you for the help!

LEt me know!

It works seamlessly with Dbeaver. I provided it with the full snowflake URL.

https://nw18763.ap-south-1.aws.snowflakecomputing.com

It has to be metabase then. I give nw18763.ap-south-1.aws to the metabase as it was working with this configuration beforehand as well. Let me look into certificates then.

Share as well a screenshot of the database connection ... Since you said it failed on 46 as well so I doubt its a 50 version issue ... Anything else you might be aware you changed when this happened?

Here it is:

The only other thing I can think of is we cleaned up our AWS infrastructure before the weekend, deleted some resources. But a working BigQuery connection would rule out any issue caused because of this, correct?

click on avanced options and add the following to the jdbc parameters:
insecureMode=true

1 Like

Not sure! Ie the Database correct? Since it's case sensitive? No real ideas right now form my end

This worked. Thank you so much! :sweat_smile:

The above solution by Luiggi worked. Thank you so much for your time! :pray:

1 Like