Error adding Snowflake - Attempting to call unbound fn: #'metabase.driver.sql-jdbc.connection/do-with-connection-spec-for-testing-connection

Get Help
1

I was able to get authenticated to snowflake through Okta, but I'm now getting this error:

Attempting to call unbound fn: #'metabase.driver.sql-jdbc.connection/do-with-connection-spec-for-testing-connection

I don't see any errors in the Snowflake Trace. To get the driver authenticating due to the issue here: Snowflake connection using Federated Authentication SSO with Okta fails to connect because of incorrect `account` parameter · Issue #26272 · metabase/metabase · GitHub I made the following 2 edits to modules/drivers/snowflake/src/metabase/driver/snowflake.clj

Line 72
From this:
(format "jdbc:snowflake://%s.snowflakecomputing.com" account))
To this:
(format "jdbc:snowflake://%s.us-east-1.snowflakecomputing.com" account))

Line 112
From this:
:subname (str "//" account ".snowflakecomputing.com/")
To this:
:subname (str "//" account ".us-east-1.snowflakecomputing.com/")

I had attempted to bring in the region-id parameter back, instead of hard-coding the region, but that results in the same error as well. So I figured I would try to make the least amount of changes to see if I could get it working, before trying a more generic fix.

Any ideas why is this failing?

Here are the values on the adding database form:
Account name: myaccount
Username: first.last@mycomp.com
Warehouse: MYWAREHOUSE
Database: MYDB
Additional JDBC connection string options: authenticator=https://myidp.okta.com&tracing=ALL&JDBC_QUERY_RESULT_FORMAT=JSON

image
image1310×2406 92.2 KB

Here is the log from Metabase

[6765660c-125e-470f-9722-88fdc84419b4] 2022-12-12T10:26:51-05:00 ERROR metabase.driver.snowflake (type message)
=> java.lang.String
[6765660c-125e-470f-9722-88fdc84419b4] 2022-12-12T10:26:51-05:00 ERROR metabase.api.database Cannot connect to Database
clojure.lang.ExceptionInfo: Attempting to call unbound fn: #'metabase.driver.sql-jdbc.connection/do-with-connection-spec-for-testing-connection {:message "Attempting to call unbound fn: #'metabase.driver.sql-jdbc.connection/do-with-connection-spec-for-testing-connection"}
at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:153)
at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:126)
at clojure.lang.RestFn.invoke(RestFn.java:442)
at metabase.api.database$test_database_connection.invokeStatic(database.clj:540)
at metabase.api.database$test_database_connection.doInvoke(database.clj:530)
at clojure.lang.RestFn.invoke(RestFn.java:425)
at metabase.api.database$fn__76503$test_connection_details__76508$fn__76509.invoke(database.clj:593)
at metabase.api.database$fn__76503$test_connection_details__76508.invoke(database.clj:574)
at metabase.api.database$fn__76536.invokeStatic(database.clj:611)
at metabase.api.database$fn__76536.invoke(database.clj:597)
at compojure.core$wrap_response$fn__28102.invoke(core.clj:160)
at compojure.core$wrap_route_middleware$fn__28086.invoke(core.clj:132)
at compojure.core$wrap_route_info$fn__28091.invoke(core.clj:139)
at compojure.core$wrap_route_matches$fn__28095.invoke(core.clj:151)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28095.invoke(core.clj:152)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114.invoke(core.clj:200)
at metabase.server.middleware.auth$enforce_authentication$fn__68964.invoke(auth.clj:14)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114.invoke(core.clj:200)
at compojure.core$make_context$handler__28142.invoke(core.clj:289)
at compojure.core$make_context$fn__28146.invoke(core.clj:299)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116.invoke(core.clj:197)
at compojure.core$make_context$fn__28146.invoke(core.clj:300)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116.invoke(core.clj:197)
at compojure.core$make_context$fn__28146.invoke(core.clj:300)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116.invoke(core.clj:197)
at compojure.core$make_context$fn__28146.invoke(core.clj:300)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116.invoke(core.clj:197)
at compojure.core$make_context$fn__28146.invoke(core.clj:300)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116.invoke(core.clj:197)
at compojure.core$make_context$fn__28146.invoke(core.clj:300)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116.invoke(core.clj:197)
at compojure.core$make_context$fn__28146.invoke(core.clj:300)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116.invoke(core.clj:197)
at compojure.core$make_context$fn__28146.invoke(core.clj:300)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116.invoke(core.clj:197)
at metabase.api.routes$fn__79953$fn__79956.invoke(routes.clj:60)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114.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__80108$fn__80109.doInvoke(routes.clj:67)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114.invoke(core.clj:200)
at compojure.core$make_context$handler__28142.invoke(core.clj:289)
at compojure.core$make_context$fn__28146.invoke(core.clj:299)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28095.invoke(core.clj:153)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28095.invoke(core.clj:153)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28095.invoke(core.clj:153)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116.invoke(core.clj:197)
at metabase.server.routes$fn__80094$fn__80096.invoke(routes.clj:45)
at compojure.core$routes$fn__28114$f__28115.invoke(core.clj:198)
at compojure.core$routes$fn__28114.invoke(core.clj:200)
at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__76842.invoke(exceptions.clj:98)
at metabase.server.middleware.exceptions$catch_api_exceptions$fn__76839.invoke(exceptions.clj:86)
at metabase.server.middleware.log$log_api_call$fn__81520$fn__81521$fn__81522.invoke(log.clj:211)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:15)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:9)
at metabase.server.middleware.log$log_api_call$fn__81520$fn__81521.invoke(log.clj:203)
at toucan.db$_do_with_call_counting.invokeStatic(db.clj:236)
at toucan.db$do_with_call_counting.invoke(db.clj:229)
at metabase.server.middleware.log$log_api_call$fn__81520.invoke(log.clj:202)
at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__84620.invoke(browser_cookie.clj:38)
at metabase.server.middleware.security$add_security_headers$fn__62357.invoke(security.clj:149)
at metabase.server.middleware.json$wrap_json_body$fn__83578.invoke(json.clj:63)
at metabase.server.middleware.json$wrap_streamed_json_response$fn__83596.invoke(json.clj:99)
at metabase.server.middleware.offset_paging$handle_paging$fn__62381.invoke(offset_paging.clj:42)
at ring.middleware.keyword_params$wrap_keyword_params$fn__84887.invoke(keyword_params.clj:55)
at ring.middleware.params$wrap_params$fn__84906.invoke(params.clj:77)
at metabase.server.middleware.misc$maybe_set_site_url$fn__35786.invoke(misc.clj:59)
at metabase.server.middleware.session$reset_session_timeout$fn__47478.invoke(session.clj:377)
at metabase.server.middleware.session$bind_current_user$fn__47461$fn__47462.invoke(session.clj:313)
at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:292)
at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:281)
at metabase.server.middleware.session$bind_current_user$fn__47461.invoke(session.clj:312)
at metabase.server.middleware.session$wrap_current_user_info$fn__47443.invoke(session.clj:262)
at metabase.server.middleware.session$wrap_session_id$fn__47427.invoke(session.clj:195)
at metabase.server.middleware.auth$wrap_api_key$fn__68972.invoke(auth.clj:27)
at ring.middleware.cookies$wrap_cookies$fn__84807.invoke(cookies.clj:216)
at metabase.server.middleware.misc$add_content_type$fn__35769.invoke(misc.clj:27)
at metabase.server.middleware.misc$disable_streaming_buffering$fn__35794.invoke(misc.clj:76)
at ring.middleware.gzip$wrap_gzip$fn__84849.invoke(gzip.clj:86)
at metabase.server.middleware.misc$bind_request$fn__35797.invoke(misc.clj:93)
at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__84636.invoke(ssl.clj:38)
at metabase.server$async_proxy_handler$fn__80316.invoke(server.clj:73)
at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:181)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.lang.IllegalStateException: Attempting to call unbound fn: #'metabase.driver.sql-jdbc.connection/do-with-connection-spec-for-testing-connection
at clojure.lang.Var$Unbound.throwArity(Var.java:45)
at clojure.lang.AFn.invoke(AFn.java:40)
at metabase.driver.snowflake$fn__82735.invokeStatic(snowflake.clj:428)
at metabase.driver.snowflake$fn__82735.invoke(snowflake.clj:425)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK$fn__33141.invoke(util.clj:138)
at clojure.core$binding_conveyor_fn$fn__5823.invoke(core.clj:2047)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
... 1 more
[6765660c-125e-470f-9722-88fdc84419b4] 2022-12-12T10:26:51-05:00 DEBUG metabase.server.middleware.log POST /api/database 400 2.9 s (0 DB calls)
{:message
"Attempting to call unbound fn: #'metabase.driver.sql-jdbc.connection/do-with-connection-spec-for-testing-connection"}

Here is the diagnostics info:
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36 Edg/107.0.1418.56",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.17+8-LTS",
"java.vendor": "Red Hat, Inc.",
"java.vendor.url": "https://www.redhat.com/",
"java.version": "11.0.17",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.17+8-LTS",
"os.name": "Linux",
"os.version": "4.18.0-425.3.1.el8.x86_64",
"user.language": "en",
"user.timezone": "America/New_York"
},
"metabase-info": {
"databases": [
"h2"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2022-11-01",
"tag": "v0.44.6",
"branch": "release-x.44.x",
"hash": "5c6ae21"
},
"settings": {
"report-timezone": null
}
}
}

2

Here is the snowflake trace:

2022-12-12 15:26:48.800 n.s.c.jdbc.DefaultSFConnectionHandler FINE initialize:96 - Trying to establish session, JDBC driver version: 3.13.25
2022-12-12 15:26:48.801 n.s.c.core.SFSession FINE open:385 - input: server=https://myaccount.us-east-1.snowflakecomputing.com:443/, account=myaccount, user=first.last@mycomp.com, password=, role=, database=MYDB, schema=, warehouse=MYWAREHOUSE, validate_default_parameters=null, authenticator=https://myidp.okta.com, ocsp_mode=FAIL_OPEN, passcode_in_password=null, passcode=* private_key=(null), disable_socks_proxy=null, application=null, app_id=JDBC, app_version=3.13.25, login_timeout=null, network_timeout=null, query_timeout=null, tracing=ALL, private_key_file=null, private_key_file_pwd=**** session_parameters: client_store_temporary_credential=null
2022-12-12 15:26:48.801 n.s.c.core.SFBaseSession FINE getHttpClientKey:420 - http.useProxy={}. JVM proxy not used.
2022-12-12 15:26:48.801 n.s.c.core.SFSession FINE open:428 - connection proxy parameters: use_proxy=false, proxy_host=, proxy_port=0, proxy_user=, proxy_password=**** non_proxy_hosts=, proxy_protocol=http
2022-12-12 15:26:48.802 n.s.c.core.HttpUtil FINE executeRequestInternal:728 - Pool: [leased: 0; pending: 0; available: 0; max: 300] Executing: POST https://myaccount.us-east-1.snowflakecomputing.com:443/session/authenticator-request HTTP/1.1
2022-12-12 15:26:48.802 n.s.c.jdbc.RestRequest FINE execute:122 - Retry count: 0
2022-12-12 15:26:48.843 n.s.c.core.SFTrustManager FINE isCached:1074 - CertID. NameHash: 33F5AAC61D66E7055D03173A4D1F3E187138850D, KeyHash: 59A4660652A07B95923CA394072796745BF93DD0, Serial Number: 20085231629180124373856508868574790289
2022-12-12 15:26:48.843 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1371 - Certificate is NOT attached for verification. Verifying OCSP signature by the issuer public key.
2022-12-12 15:26:48.844 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/12/22, 12:15 AM, Next Update: 12/18/22, 11:30 PM
2022-12-12 15:26:48.844 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:48.844 n.s.c.core.SFTrustManager FINE isCached:1074 - CertID. NameHash: 4F59A39453CFB9559E7F6BD8C54DA53DA642B714, KeyHash: 8418CC8534ECBC0C94942E08599CC7B2104E0A08, Serial Number: 144918209630989264145272943054026349679957517
2022-12-12 15:26:48.845 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1339 - Certificate is attached for verification. Verifying it by the issuer certificate.
2022-12-12 15:26:48.845 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1369 - Verifying OCSP signature by the attached certificate public key.
2022-12-12 15:26:48.846 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/10/22, 3:22 AM, Next Update: 12/17/22, 4:22 AM
2022-12-12 15:26:48.846 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:48.846 n.s.c.core.SFTrustManager FINE isCached:1074 - CertID. NameHash: 887DA4445E67EA7C94774E43189C3ECEE4C87312, KeyHash: 9C5F00DFAA01D7302B3888A2B86D4A9CF2119183, Serial Number: 144918191876577076464031512351042010504348870
2022-12-12 15:26:48.846 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1339 - Certificate is attached for verification. Verifying it by the issuer certificate.
2022-12-12 15:26:48.847 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1369 - Verifying OCSP signature by the attached certificate public key.
2022-12-12 15:26:48.847 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/12/22, 1:15 AM, Next Update: 12/19/22, 2:15 AM
2022-12-12 15:26:48.847 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:48.848 n.s.c.core.SFTrustManager FINE isCached:1074 - CertID. NameHash: 8BC19E845B981D61CF5469211A68B8E311336D90, KeyHash: BF5FB7D1CEDD1F86F45B55ACDCD710C20EA988E7, Serial Number: 12037640545166866303
2022-12-12 15:26:48.848 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1339 - Certificate is attached for verification. Verifying it by the issuer certificate.
2022-12-12 15:26:48.848 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1369 - Verifying OCSP signature by the attached certificate public key.
2022-12-12 15:26:48.849 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/11/22, 2:40 PM, Next Update: 12/13/22, 2:40 AM
2022-12-12 15:26:48.849 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:48.849 n.s.c.core.SFTrustManager FINE executeOneRevocationStatusCheck:948 - validating. CertID. NameHash: 33F5AAC61D66E7055D03173A4D1F3E187138850D, KeyHash: 59A4660652A07B95923CA394072796745BF93DD0, Serial Number: 20085231629180124373856508868574790289
2022-12-12 15:26:48.849 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1371 - Certificate is NOT attached for verification. Verifying OCSP signature by the issuer public key.
2022-12-12 15:26:48.850 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/12/22, 12:15 AM, Next Update: 12/18/22, 11:30 PM
2022-12-12 15:26:48.850 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:48.850 n.s.c.core.SFTrustManager FINE executeOneRevocationStatusCheck:948 - validating. CertID. NameHash: 4F59A39453CFB9559E7F6BD8C54DA53DA642B714, KeyHash: 8418CC8534ECBC0C94942E08599CC7B2104E0A08, Serial Number: 144918209630989264145272943054026349679957517
2022-12-12 15:26:48.850 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1339 - Certificate is attached for verification. Verifying it by the issuer certificate.
2022-12-12 15:26:48.851 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1369 - Verifying OCSP signature by the attached certificate public key.
2022-12-12 15:26:48.851 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/10/22, 3:22 AM, Next Update: 12/17/22, 4:22 AM
2022-12-12 15:26:48.851 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:48.855 n.s.c.core.SFTrustManager FINE executeOneRevocationStatusCheck:948 - validating. CertID. NameHash: 887DA4445E67EA7C94774E43189C3ECEE4C87312, KeyHash: 9C5F00DFAA01D7302B3888A2B86D4A9CF2119183, Serial Number: 144918191876577076464031512351042010504348870
2022-12-12 15:26:48.855 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1339 - Certificate is attached for verification. Verifying it by the issuer certificate.
2022-12-12 15:26:48.855 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1369 - Verifying OCSP signature by the attached certificate public key.
2022-12-12 15:26:48.856 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/12/22, 1:15 AM, Next Update: 12/19/22, 2:15 AM
2022-12-12 15:26:48.856 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:48.856 n.s.c.core.SFTrustManager FINE executeOneRevocationStatusCheck:948 - validating. CertID. NameHash: 8BC19E845B981D61CF5469211A68B8E311336D90, KeyHash: BF5FB7D1CEDD1F86F45B55ACDCD710C20EA988E7, Serial Number: 12037640545166866303
2022-12-12 15:26:48.857 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1339 - Certificate is attached for verification. Verifying it by the issuer certificate.
2022-12-12 15:26:48.857 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1369 - Verifying OCSP signature by the attached certificate public key.
2022-12-12 15:26:48.857 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/11/22, 2:40 PM, Next Update: 12/13/22, 2:40 AM
2022-12-12 15:26:48.858 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:48.916 n.s.c.jdbc.RestRequest FINE execute:213 - HTTP response code: 200
2022-12-12 15:26:48.917 n.s.c.core.HttpUtil FINE executeRequestInternal:780 - Pool: [leased: 0; pending: 0; available: 1; max: 300] Request returned for: POST https://myaccount.us-east-1.snowflakecomputing.com:443/session/authenticator-request HTTP/1.1
2022-12-12 15:26:48.917 n.s.c.core.SessionUtil FINE federatedFlowStep1:1247 - authenticator-request response: {
"data" : {
"tokenUrl" : "https://myidp.okta.com/api/v1/authn",
"ssoUrl" : "https://myidp.okta.com/app/snowflake/exk1h5nt7snJPsOQP0h8/sso/saml",
"proofKey" : null
},
"code" : null,
"message" : null,
"success" : true
}
2022-12-12 15:26:48.919 n.s.c.core.HttpUtil FINE executeRequestInternal:728 - Pool: [leased: 0; pending: 0; available: 1; max: 300] Executing: POST https://myidp.okta.com/api/v1/authn HTTP/1.1
2022-12-12 15:26:48.919 n.s.c.jdbc.RestRequest FINE execute:122 - Retry count: 0
2022-12-12 15:26:48.953 n.s.c.core.SFTrustManager FINE isCached:1074 - CertID. NameHash: E4E395A229D3D4C1C31FF0980C0B4EC0098AABD8, KeyHash: B76BA2EAA8AA848C79EAB4DA0F98B2C59576B9F4, Serial Number: 16558702268414078056135800034555668122
2022-12-12 15:26:48.953 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1371 - Certificate is NOT attached for verification. Verifying OCSP signature by the issuer public key.
2022-12-12 15:26:48.954 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/11/22, 8:03 PM, Next Update: 12/18/22, 7:18 PM
2022-12-12 15:26:48.954 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:48.954 n.s.c.core.SFTrustManager FINE isCached:1074 - CertID. NameHash: 8051060132AD9AC27D5187A0E887FB01620155EE, KeyHash: 03DE503556D14CBB66F0A3E21B1BC397B23DD155, Serial Number: 13567650854749339296468135199911180260
2022-12-12 15:26:48.954 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1371 - Certificate is NOT attached for verification. Verifying OCSP signature by the issuer public key.
2022-12-12 15:26:48.955 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/11/22, 3:10 PM, Next Update: 12/18/22, 3:10 PM
2022-12-12 15:26:48.955 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:48.956 n.s.c.core.SFTrustManager FINE executeOneRevocationStatusCheck:948 - validating. CertID. NameHash: E4E395A229D3D4C1C31FF0980C0B4EC0098AABD8, KeyHash: B76BA2EAA8AA848C79EAB4DA0F98B2C59576B9F4, Serial Number: 16558702268414078056135800034555668122
2022-12-12 15:26:48.956 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1371 - Certificate is NOT attached for verification. Verifying OCSP signature by the issuer public key.
2022-12-12 15:26:48.956 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/11/22, 8:03 PM, Next Update: 12/18/22, 7:18 PM
2022-12-12 15:26:48.956 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:48.957 n.s.c.core.SFTrustManager FINE executeOneRevocationStatusCheck:948 - validating. CertID. NameHash: 8051060132AD9AC27D5187A0E887FB01620155EE, KeyHash: 03DE503556D14CBB66F0A3E21B1BC397B23DD155, Serial Number: 13567650854749339296468135199911180260
2022-12-12 15:26:48.957 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1371 - Certificate is NOT attached for verification. Verifying OCSP signature by the issuer public key.
2022-12-12 15:26:48.957 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/11/22, 3:10 PM, Next Update: 12/18/22, 3:10 PM
2022-12-12 15:26:48.957 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:50.813 n.s.c.jdbc.RestRequest FINE execute:213 - HTTP response code: 200
2022-12-12 15:26:50.814 n.s.c.core.HttpUtil FINE executeRequestInternal:780 - Pool: [leased: 0; pending: 0; available: 2; max: 300] Request returned for: POST https://myidp.okta.com/api/v1/authn HTTP/1.1
2022-12-12 15:26:50.814 n.s.c.core.SessionUtil FINE federatedFlowStep3:1163 - user is authenticated against https://myidp.okta.com.
2022-12-12 15:26:50.815 n.s.c.core.HttpUtil FINE executeRequestInternal:728 - Pool: [leased: 0; pending: 0; available: 2; max: 300] Executing: GET https://myidp.okta.com/app/snowflake/exk1h5nt7snJPsOQP0h8/sso/saml?RelayState=%252Fsome%252Fdeep%252Flink&onetimetoken=**** HTTP/1.1
2022-12-12 15:26:50.815 n.s.c.jdbc.RestRequest FINE execute:122 - Retry count: 0
2022-12-12 15:26:51.106 n.s.c.jdbc.RestRequest FINE execute:213 - HTTP response code: 200
2022-12-12 15:26:51.108 n.s.c.core.HttpUtil FINE executeRequestInternal:780 - Pool: [leased: 0; pending: 0; available: 2; max: 300] Request returned for: GET https://myidp.okta.com/app/snowflake/exk1h5nt7snJPsOQP0h8/sso/saml?RelayState=%252Fsome%252Fdeep%252Flink&onetimetoken=**** HTTP/1.1
2022-12-12 15:26:51.173 n.s.c.core.HttpUtil FINE executeRequestInternal:728 - Pool: [leased: 0; pending: 0; available: 2; max: 300] Executing: POST https://myaccount.us-east-1.snowflakecomputing.com:443/session/v1/login-request?databaseName=MYDB&schemaName=&warehouse=MYWAREHOUSE&roleName=&requestId=a216b6fb-fee5-4aa4-bf32-d9b1d47a212e HTTP/1.1
2022-12-12 15:26:51.174 n.s.c.jdbc.RestRequest FINE execute:122 - Retry count: 0
2022-12-12 15:26:51.389 n.s.c.jdbc.RestRequest FINE execute:213 - HTTP response code: 200
2022-12-12 15:26:51.389 n.s.c.core.HttpUtil FINE executeRequestInternal:780 - Pool: [leased: 0; pending: 0; available: 2; max: 300] Request returned for: POST https://myaccount.us-east-1.snowflakecomputing.com:443/session/v1/login-request?databaseName=MYDB&schemaName=&warehouse=MYWAREHOUSE&roleName=&requestId=a216b6fb-fee5-4aa4-bf32-d9b1d47a212e HTTP/1.1
2022-12-12 15:26:51.390 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter TIMESTAMP_OUTPUT_FORMAT: YYYY-MM-DD HH24:MI:SS.FF3 TZHTZM
2022-12-12 15:26:51.390 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_PREFETCH_THREADS: 4
2022-12-12 15:26:51.390 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter TIME_OUTPUT_FORMAT: HH24:MI:SS
2022-12-12 15:26:51.390 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_RESULT_CHUNK_SIZE: 160
2022-12-12 15:26:51.391 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter TIMESTAMP_TZ_OUTPUT_FORMAT:
2022-12-12 15:26:51.391 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_SESSION_KEEP_ALIVE: true
2022-12-12 15:26:51.391 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_RS_COLUMN_CASE_INSENSITIVE: false
2022-12-12 15:26:51.402 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: SNOWPARK_HIDE_INTERNAL_ALIAS
2022-12-12 15:26:51.402 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter SNOWPARK_HIDE_INTERNAL_ALIAS: true
2022-12-12 15:26:51.402 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_CONSERVATIVE_MEMORY_ADJUST_STEP
2022-12-12 15:26:51.402 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_CONSERVATIVE_MEMORY_ADJUST_STEP: 64
2022-12-12 15:26:51.402 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: QUERY_CONTEXT_CACHE_SIZE
2022-12-12 15:26:51.402 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter QUERY_CONTEXT_CACHE_SIZE: 5
2022-12-12 15:26:51.402 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_METADATA_USE_SESSION_DATABASE: false
2022-12-12 15:26:51.402 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_ENABLE_COMBINED_DESCRIBE: false
2022-12-12 15:26:51.402 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter ENABLE_STAGE_S3_PRIVATELINK_FOR_US_EAST_1: false
2022-12-12 15:26:51.402 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_RESULT_PREFETCH_THREADS
2022-12-12 15:26:51.402 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_RESULT_PREFETCH_THREADS: 1
2022-12-12 15:26:51.402 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter TIMESTAMP_NTZ_OUTPUT_FORMAT: YYYY-MM-DD HH24:MI:SS.FF3
2022-12-12 15:26:51.402 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_TREAT_DECIMAL_AS_INT: true
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX: true
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_HONOR_CLIENT_TZ_FOR_TIMESTAMP_NTZ: true
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_MEMORY_LIMIT: 1536
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_EFFICIENT_CHUNK_STORAGE: true
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_TIMESTAMP_TYPE_MAPPING: TIMESTAMP_LTZ
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter TIMEZONE: UTC
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: SNOWPARK_REQUEST_TIMEOUT_IN_SECONDS
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter SNOWPARK_REQUEST_TIMEOUT_IN_SECONDS: 86400
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_RESULT_PREFETCH_SLOTS
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_RESULT_PREFETCH_SLOTS: 2
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_DISABLE_INCIDENTS: true
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_ENABLE_CONSERVATIVE_MEMORY_USAGE: true
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter BINARY_OUTPUT_FORMAT: HEX
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CSV_TIMESTAMP_FORMAT
2022-12-12 15:26:51.403 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CSV_TIMESTAMP_FORMAT:
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_TELEMETRY_SESSIONLESS_ENABLED
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_TELEMETRY_SESSIONLESS_ENABLED: true
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_FORMAT_DATE_WITH_TIMEZONE: true
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_FORCE_PROTECT_ID_TOKEN
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_FORCE_PROTECT_ID_TOKEN: true
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter DATE_OUTPUT_FORMAT: YYYY-MM-DD
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_CONSENT_CACHE_ID_TOKEN
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_CONSENT_CACHE_ID_TOKEN: false
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter SNOWPARK_LAZY_ANALYSIS: true
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_USE_JSON_PARSER: true
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_SESSION_KEEP_ALIVE_HEARTBEAT_FREQUENCY: 3600
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter AUTOCOMMIT: true
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_SESSION_CLONE
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_SESSION_CLONE: false
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter TIMESTAMP_LTZ_OUTPUT_FORMAT:
2022-12-12 15:26:51.404 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_USE_SESSION_TIMEZONE: true
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_TREAT_TIMESTAMP_NTZ_AS_UTC: false
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: JDBC_EXECUTE_RETURN_COUNT_FOR_DML
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_EXECUTE_RETURN_COUNT_FOR_DML: false
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_OUT_OF_BAND_TELEMETRY_ENABLED: false
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: SNOWPARK_USE_SCOPED_TEMP_OBJECTS
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter SNOWPARK_USE_SCOPED_TEMP_OBJECTS: false
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_TELEMETRY_ENABLED: true
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_USE_V1_QUERY_API
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_USE_V1_QUERY_API: true
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_RESULT_COLUMN_CASE_INSENSITIVE: false
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_ENABLE_LOG_INFO_STATEMENT_PARAMETERS: false
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_STAGE_ARRAY_BINDING_THRESHOLD: 65280
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE newSession:721 - server version = 6.40.1
2022-12-12 15:26:51.405 n.s.c.core.SessionUtil FINE newSession:752 - new client: 3.12.3
2022-12-12 15:26:51.406 n.s.c.core.SessionUtil FINE newSession:758 - health check interval = 45
2022-12-12 15:26:51.406 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter TIMESTAMP_OUTPUT_FORMAT
2022-12-12 15:26:51.406 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_PREFETCH_THREADS
2022-12-12 15:26:51.406 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter TIME_OUTPUT_FORMAT
2022-12-12 15:26:51.406 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_RESULT_CHUNK_SIZE
2022-12-12 15:26:51.406 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter TIMESTAMP_TZ_OUTPUT_FORMAT
2022-12-12 15:26:51.406 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_SESSION_KEEP_ALIVE
2022-12-12 15:26:51.406 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_RS_COLUMN_CASE_INSENSITIVE
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter SNOWPARK_HIDE_INTERNAL_ALIAS
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_CONSERVATIVE_MEMORY_ADJUST_STEP
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter QUERY_CONTEXT_CACHE_SIZE
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_METADATA_USE_SESSION_DATABASE
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_ENABLE_COMBINED_DESCRIBE
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter ENABLE_STAGE_S3_PRIVATELINK_FOR_US_EAST_1
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_RESULT_PREFETCH_THREADS
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter TIMESTAMP_NTZ_OUTPUT_FORMAT
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_TREAT_DECIMAL_AS_INT
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_HONOR_CLIENT_TZ_FOR_TIMESTAMP_NTZ
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_MEMORY_LIMIT
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_EFFICIENT_CHUNK_STORAGE
2022-12-12 15:26:51.407 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_TIMESTAMP_TYPE_MAPPING
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter TIMEZONE
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter SNOWPARK_REQUEST_TIMEOUT_IN_SECONDS
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_RESULT_PREFETCH_SLOTS
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_DISABLE_INCIDENTS
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_ENABLE_CONSERVATIVE_MEMORY_USAGE
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter BINARY_OUTPUT_FORMAT
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CSV_TIMESTAMP_FORMAT
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_TELEMETRY_SESSIONLESS_ENABLED
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_FORMAT_DATE_WITH_TIMEZONE
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_FORCE_PROTECT_ID_TOKEN
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter DATE_OUTPUT_FORMAT
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_CONSENT_CACHE_ID_TOKEN
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter SNOWPARK_LAZY_ANALYSIS
2022-12-12 15:26:51.408 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_USE_JSON_PARSER
2022-12-12 15:26:51.409 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_SESSION_KEEP_ALIVE_HEARTBEAT_FREQUENCY
2022-12-12 15:26:51.409 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter AUTOCOMMIT
2022-12-12 15:26:51.409 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_SESSION_CLONE
2022-12-12 15:26:51.409 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter TIMESTAMP_LTZ_OUTPUT_FORMAT
2022-12-12 15:26:51.409 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_USE_SESSION_TIMEZONE
2022-12-12 15:26:51.409 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_TREAT_TIMESTAMP_NTZ_AS_UTC
2022-12-12 15:26:51.409 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_EXECUTE_RETURN_COUNT_FOR_DML
2022-12-12 15:26:51.409 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_OUT_OF_BAND_TELEMETRY_ENABLED
2022-12-12 15:26:51.410 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter SNOWPARK_USE_SCOPED_TEMP_OBJECTS
2022-12-12 15:26:51.410 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_TELEMETRY_ENABLED
2022-12-12 15:26:51.410 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_USE_V1_QUERY_API
2022-12-12 15:26:51.410 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_RESULT_COLUMN_CASE_INSENSITIVE
2022-12-12 15:26:51.410 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_ENABLE_LOG_INFO_STATEMENT_PARAMETERS
2022-12-12 15:26:51.410 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_STAGE_ARRAY_BINDING_THRESHOLD
2022-12-12 15:26:51.410 n.s.c.core.SFSession FINE startHeartbeatForThisSession:717 - start heartbeat, master token ****: 14400
2022-12-12 15:26:51.411 n.s.c.core.HeartbeatBackground FINE addSession:82 - update heartbeat interval from 3,600 to 3,600
2022-12-12 15:26:51.411 n.s.c.core.HeartbeatBackground FINE addSession:99 - create heartbeat thread pool
2022-12-12 15:26:51.412 n.s.c.core.HeartbeatBackground FINE addSession:116 - schedule heartbeat task
2022-12-12 15:26:51.412 n.s.c.core.HeartbeatBackground FINE scheduleHeartbeat:158 - schedule heartbeat task with initial delay of 0 seconds
2022-12-12 15:26:51.416 n.s.c.core.SFSession FINE heartbeat:744 - public void heartbeat()
2022-12-12 15:26:51.417 n.s.c.core.SFSession FINE heartbeat:782 - Executing heartbeat request: POST https://myaccount.us-east-1.snowflakecomputing.com:443/session/heartbeat?requestId=6c7fcfc6-d3e0-4553-b9d7-e5241eea4f79 HTTP/1.1
2022-12-12 15:26:51.423 n.s.c.jdbc.SnowflakeConnectionV1 FINE prepareStatement:451 - PreparedStatement prepareStatement(String sql)
2022-12-12 15:26:51.424 n.s.c.jdbc.SnowflakeConnectionV1 FINE prepareStatement:511 - PreparedStatement prepareStatement(String sql, boolean skipParsing)
2022-12-12 15:26:51.427 n.s.c.jdbc.SnowflakeStatementV1 FINE :83 - public SnowflakeStatement(SnowflakeConnectionV1 conn)
2022-12-12 15:26:51.417 n.s.c.core.HttpUtil FINE executeRequestInternal:728 - Pool: [leased: 0; pending: 0; available: 2; max: 300] Executing: POST https://myaccount.us-east-1.snowflakecomputing.com:443/session/heartbeat?requestId=6c7fcfc6-d3e0-4553-b9d7-e5241eea4f79 HTTP/1.1
2022-12-12 15:26:51.428 n.s.c.jdbc.RestRequest FINE execute:122 - Retry count: 0
2022-12-12 15:26:51.439 n.s.c.core.SFStatement FINE :71 - public SFStatement(SFSession session)
2022-12-12 15:26:51.440 n.s.c.jdbc.SnowflakePreparedStatementV1 FINE executeQuery:116 - executeQuery()
2022-12-12 15:26:51.441 n.s.c.core.SFStatement FINE execute:733 - execute: SELECT 1
2022-12-12 15:26:51.442 n.s.c.core.SFStatement FINE executeQueryInternal:185 - executeQuery: SELECT 1
2022-12-12 15:26:51.444 n.s.c.core.SFStatement FINE executeHelper:364 - JDBC conservative memory usage is enabled.
2022-12-12 15:26:51.445 n.s.c.core.SFStatement FINE updateConservativeResultChunkSize:558 - conservativeResultChunkSize changed from 0 to 48
2022-12-12 15:26:51.450 n.s.c.core.StmtUtil FINE execute:323 - JSON: {"sqlText":"SELECT 1","sequenceId":0,"bindings":{},"bindStage":null,"describeOnly":false,"parameters":{"CLIENT_RESULT_CHUNK_SIZE":48},"describedJobId":null,"querySubmissionTime":1670858811445,"isInternal":false,"asyncExec":false}
2022-12-12 15:26:51.451 n.s.c.core.HttpUtil FINE executeRequestInternal:728 - Pool: [leased: 1; pending: 0; available: 1; max: 300] Executing: POST https://myaccount.us-east-1.snowflakecomputing.com:443/queries/v1/query-request?requestId=5e990ccb-c20f-450d-8360-3e6c84def0b4 HTTP/1.1
2022-12-12 15:26:51.451 n.s.c.jdbc.RestRequest FINE execute:122 - Retry count: 0
2022-12-12 15:26:51.480 n.s.c.jdbc.RestRequest FINE execute:213 - HTTP response code: 200
2022-12-12 15:26:51.480 n.s.c.core.HttpUtil FINE executeRequestInternal:780 - Pool: [leased: 1; pending: 0; available: 2; max: 300] Request returned for: POST https://myaccount.us-east-1.snowflakecomputing.com:443/session/heartbeat?requestId=6c7fcfc6-d3e0-4553-b9d7-e5241eea4f79 HTTP/1.1
2022-12-12 15:26:51.480 n.s.c.core.SFSession FINE heartbeat:799 - connection heartbeat response: {
"data" : null,
"code" : null,
"message" : null,
"success" : true
}
2022-12-12 15:26:51.481 n.s.c.core.HeartbeatBackground FINE run:206 - schedule next heartbeat run
2022-12-12 15:26:51.482 n.s.c.core.HeartbeatBackground FINE scheduleHeartbeat:158 - schedule heartbeat task with initial delay of 3,600 seconds
2022-12-12 15:26:51.484 n.s.c.core.SFTrustManager FINE isCached:1074 - CertID. NameHash: 33F5AAC61D66E7055D03173A4D1F3E187138850D, KeyHash: 59A4660652A07B95923CA394072796745BF93DD0, Serial Number: 20085231629180124373856508868574790289
2022-12-12 15:26:51.484 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1371 - Certificate is NOT attached for verification. Verifying OCSP signature by the issuer public key.
2022-12-12 15:26:51.485 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/12/22, 12:15 AM, Next Update: 12/18/22, 11:30 PM
2022-12-12 15:26:51.485 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:51.485 n.s.c.core.SFTrustManager FINE isCached:1074 - CertID. NameHash: 4F59A39453CFB9559E7F6BD8C54DA53DA642B714, KeyHash: 8418CC8534ECBC0C94942E08599CC7B2104E0A08, Serial Number: 144918209630989264145272943054026349679957517
2022-12-12 15:26:51.485 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1339 - Certificate is attached for verification. Verifying it by the issuer certificate.
2022-12-12 15:26:51.486 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1369 - Verifying OCSP signature by the attached certificate public key.
2022-12-12 15:26:51.486 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/10/22, 3:22 AM, Next Update: 12/17/22, 4:22 AM
2022-12-12 15:26:51.486 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:51.487 n.s.c.core.SFTrustManager FINE isCached:1074 - CertID. NameHash: 887DA4445E67EA7C94774E43189C3ECEE4C87312, KeyHash: 9C5F00DFAA01D7302B3888A2B86D4A9CF2119183, Serial Number: 144918191876577076464031512351042010504348870
2022-12-12 15:26:51.487 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1339 - Certificate is attached for verification. Verifying it by the issuer certificate.
2022-12-12 15:26:51.487 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1369 - Verifying OCSP signature by the attached certificate public key.
2022-12-12 15:26:51.488 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/12/22, 1:15 AM, Next Update: 12/19/22, 2:15 AM
2022-12-12 15:26:51.488 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:51.488 n.s.c.core.SFTrustManager FINE isCached:1074 - CertID. NameHash: 8BC19E845B981D61CF5469211A68B8E311336D90, KeyHash: BF5FB7D1CEDD1F86F45B55ACDCD710C20EA988E7, Serial Number: 12037640545166866303
2022-12-12 15:26:51.488 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1339 - Certificate is attached for verification. Verifying it by the issuer certificate.
2022-12-12 15:26:51.489 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1369 - Verifying OCSP signature by the attached certificate public key.
2022-12-12 15:26:51.489 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/11/22, 2:40 PM, Next Update: 12/13/22, 2:40 AM
2022-12-12 15:26:51.489 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:51.489 n.s.c.core.SFTrustManager FINE executeOneRevocationStatusCheck:948 - validating. CertID. NameHash: 33F5AAC61D66E7055D03173A4D1F3E187138850D, KeyHash: 59A4660652A07B95923CA394072796745BF93DD0, Serial Number: 20085231629180124373856508868574790289
2022-12-12 15:26:51.490 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1371 - Certificate is NOT attached for verification. Verifying OCSP signature by the issuer public key.
2022-12-12 15:26:51.490 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/12/22, 12:15 AM, Next Update: 12/18/22, 11:30 PM
2022-12-12 15:26:51.490 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:51.491 n.s.c.core.SFTrustManager FINE executeOneRevocationStatusCheck:948 - validating. CertID. NameHash: 4F59A39453CFB9559E7F6BD8C54DA53DA642B714, KeyHash: 8418CC8534ECBC0C94942E08599CC7B2104E0A08, Serial Number: 144918209630989264145272943054026349679957517
2022-12-12 15:26:51.491 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1339 - Certificate is attached for verification. Verifying it by the issuer certificate.
2022-12-12 15:26:51.493 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1369 - Verifying OCSP signature by the attached certificate public key.
2022-12-12 15:26:51.494 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/10/22, 3:22 AM, Next Update: 12/17/22, 4:22 AM
2022-12-12 15:26:51.494 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:51.494 n.s.c.core.SFTrustManager FINE executeOneRevocationStatusCheck:948 - validating. CertID. NameHash: 887DA4445E67EA7C94774E43189C3ECEE4C87312, KeyHash: 9C5F00DFAA01D7302B3888A2B86D4A9CF2119183, Serial Number: 144918191876577076464031512351042010504348870
2022-12-12 15:26:51.494 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1339 - Certificate is attached for verification. Verifying it by the issuer certificate.
2022-12-12 15:26:51.495 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1369 - Verifying OCSP signature by the attached certificate public key.
2022-12-12 15:26:51.495 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/12/22, 1:15 AM, Next Update: 12/19/22, 2:15 AM
2022-12-12 15:26:51.495 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:51.496 n.s.c.core.SFTrustManager FINE executeOneRevocationStatusCheck:948 - validating. CertID. NameHash: 8BC19E845B981D61CF5469211A68B8E311336D90, KeyHash: BF5FB7D1CEDD1F86F45B55ACDCD710C20EA988E7, Serial Number: 12037640545166866303
2022-12-12 15:26:51.496 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1339 - Certificate is attached for verification. Verifying it by the issuer certificate.
2022-12-12 15:26:51.496 n.s.c.core.SFTrustManager FINE validateRevocationStatusMain:1369 - Verifying OCSP signature by the attached certificate public key.
2022-12-12 15:26:51.497 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1443 - Current Time: 12/12/22, 10:26 AM, This Update: 12/11/22, 2:40 PM, Next Update: 12/13/22, 2:40 AM
2022-12-12 15:26:51.497 n.s.c.core.SFTrustManager FINE validateBasicOcspResponse:1459 - OK. Verified the certificate revocation status.
2022-12-12 15:26:51.624 n.s.c.jdbc.RestRequest FINE execute:213 - HTTP response code: 200
2022-12-12 15:26:51.625 n.s.c.core.HttpUtil FINE executeRequestInternal:780 - Pool: [leased: 0; pending: 0; available: 3; max: 300] Request returned for: POST https://myaccount.us-east-1.snowflakecomputing.com:443/queries/v1/query-request?requestId=5e990ccb-c20f-450d-8360-3e6c84def0b4 HTTP/1.1
2022-12-12 15:26:51.625 n.s.c.core.StmtUtil FINE pollForOutput:505 - Returning result
2022-12-12 15:26:51.626 n.s.c.core.SFStatement FINE executeHelper:514 - Returning from executeHelper
2022-12-12 15:26:51.626 n.s.c.core.SFStatement FINE executeQueryInternal:210 - Creating result set
2022-12-12 15:26:51.630 n.s.c.jdbc.SnowflakeResultSetSerializableV1 FINE create:511 - Entering create()
2022-12-12 15:26:51.631 n.s.c.jdbc.SnowflakeResultSetSerializableV1 FINE create:539 - query id: 01a8ebde-0406-475f-0000-13f98b567e9e
2022-12-12 15:26:51.631 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter TIMESTAMP_OUTPUT_FORMAT: YYYY-MM-DD HH24:MI:SS.FF3 TZHTZM
2022-12-12 15:26:51.631 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_PREFETCH_THREADS: 4
2022-12-12 15:26:51.631 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter TIME_OUTPUT_FORMAT: HH24:MI:SS
2022-12-12 15:26:51.631 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_RESULT_CHUNK_SIZE: 48
2022-12-12 15:26:51.631 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter TIMESTAMP_TZ_OUTPUT_FORMAT:
2022-12-12 15:26:51.631 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_SESSION_KEEP_ALIVE: true
2022-12-12 15:26:51.631 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_RS_COLUMN_CASE_INSENSITIVE: false
2022-12-12 15:26:51.631 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: SNOWPARK_HIDE_INTERNAL_ALIAS
2022-12-12 15:26:51.631 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter SNOWPARK_HIDE_INTERNAL_ALIAS: true
2022-12-12 15:26:51.631 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_CONSERVATIVE_MEMORY_ADJUST_STEP
2022-12-12 15:26:51.631 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_CONSERVATIVE_MEMORY_ADJUST_STEP: 64
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: QUERY_CONTEXT_CACHE_SIZE
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter QUERY_CONTEXT_CACHE_SIZE: 5
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_METADATA_USE_SESSION_DATABASE: false
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_ENABLE_COMBINED_DESCRIBE: false
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter ENABLE_STAGE_S3_PRIVATELINK_FOR_US_EAST_1: false
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_RESULT_PREFETCH_THREADS
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_RESULT_PREFETCH_THREADS: 1
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter TIMESTAMP_NTZ_OUTPUT_FORMAT: YYYY-MM-DD HH24:MI:SS.FF3
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_TREAT_DECIMAL_AS_INT: true
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX: true
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_HONOR_CLIENT_TZ_FOR_TIMESTAMP_NTZ: true
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_MEMORY_LIMIT: 1536
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_EFFICIENT_CHUNK_STORAGE: true
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_TIMESTAMP_TYPE_MAPPING: TIMESTAMP_LTZ
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter TIMEZONE: UTC
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: SNOWPARK_REQUEST_TIMEOUT_IN_SECONDS
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter SNOWPARK_REQUEST_TIMEOUT_IN_SECONDS: 86400
2022-12-12 15:26:51.632 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_RESULT_PREFETCH_SLOTS
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_RESULT_PREFETCH_SLOTS: 2
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_DISABLE_INCIDENTS: true
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_ENABLE_CONSERVATIVE_MEMORY_USAGE: true
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter BINARY_OUTPUT_FORMAT: HEX
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CSV_TIMESTAMP_FORMAT
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CSV_TIMESTAMP_FORMAT:
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_TELEMETRY_SESSIONLESS_ENABLED
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_TELEMETRY_SESSIONLESS_ENABLED: true
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_FORMAT_DATE_WITH_TIMEZONE: true
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_FORCE_PROTECT_ID_TOKEN
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_FORCE_PROTECT_ID_TOKEN: true
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter DATE_OUTPUT_FORMAT: YYYY-MM-DD
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_CONSENT_CACHE_ID_TOKEN
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_CONSENT_CACHE_ID_TOKEN: false
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter SNOWPARK_LAZY_ANALYSIS: true
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_USE_JSON_PARSER: true
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_SESSION_KEEP_ALIVE_HEARTBEAT_FREQUENCY: 3600
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter AUTOCOMMIT: true
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_SESSION_CLONE
2022-12-12 15:26:51.633 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_SESSION_CLONE: false
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter TIMESTAMP_LTZ_OUTPUT_FORMAT:
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_USE_SESSION_TIMEZONE: true
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_TREAT_TIMESTAMP_NTZ_AS_UTC: false
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: JDBC_EXECUTE_RETURN_COUNT_FOR_DML
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter JDBC_EXECUTE_RETURN_COUNT_FOR_DML: false
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_OUT_OF_BAND_TELEMETRY_ENABLED: false
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: SNOWPARK_USE_SCOPED_TEMP_OBJECTS
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter SNOWPARK_USE_SCOPED_TEMP_OBJECTS: false
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_TELEMETRY_ENABLED: true
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1399 - Unknown Common Parameter: CLIENT_USE_V1_QUERY_API
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_USE_V1_QUERY_API: true
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_RESULT_COLUMN_CASE_INSENSITIVE: false
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_ENABLE_LOG_INFO_STATEMENT_PARAMETERS: false
2022-12-12 15:26:51.634 n.s.c.core.SessionUtil FINE getCommonParams:1402 - Parameter CLIENT_STAGE_ARRAY_BINDING_THRESHOLD: 65280
2022-12-12 15:26:51.635 n.s.c.jdbc.SnowflakeResultSetSerializableV1 FINE create:568 - Get column metadata: name=1,typeName=NUMBER,type=-5,nullable=false,length=0,precision=1,scale=0,fixed=false,database=,schema=,table=
2022-12-12 15:26:51.636 n.s.c.jdbc.SnowflakeResultSetSerializableV1 FINE create:594 - First chunk row count: 1
2022-12-12 15:26:51.636 n.s.c.jdbc.SnowflakeResultSetSerializableV1 FINE create:623 - result version=1
2022-12-12 15:26:51.640 n.s.c.core.ResultUtil FINE specializedFormatter:89 - sql timestamp_ntz format: YYYY-MM-DD HH24:MI:SS.FF3, java timestamp_ntz format: yyyy'-'MM'-'dd' 'HH':'mm':'ss
2022-12-12 15:26:51.640 n.s.c.core.ResultUtil FINE specializedFormatter:89 - sql timestamp_ltz format: YYYY-MM-DD HH24:MI:SS.FF3 TZHTZM, java timestamp_ltz format: yyyy'-'MM'-'dd' 'HH':'mm':'ss' 'XX
2022-12-12 15:26:51.640 n.s.c.core.ResultUtil FINE specializedFormatter:89 - sql timestamp_tz format: YYYY-MM-DD HH24:MI:SS.FF3 TZHTZM, java timestamp_tz format: yyyy'-'MM'-'dd' 'HH':'mm':'ss' 'XX
2022-12-12 15:26:51.640 n.s.c.jdbc.SnowflakeResultSetSerializableV1 FINE setupFieldsFromParameters:707 - sql date format: YYYY-MM-DD, java date format: yyyy'-'MM'-'dd
2022-12-12 15:26:51.641 n.s.c.jdbc.SnowflakeResultSetSerializableV1 FINE setupFieldsFromParameters:717 - sql time format: HH24:MI:SS, java time format: HH':'mm':'ss
2022-12-12 15:26:51.641 n.s.c.jdbc.SnowflakeResultSetSerializableV1 FINE setupFieldsFromParameters:730 - Honoring client TZ for timestamp_ntz? {}
2022-12-12 15:26:51.656 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter TIMESTAMP_OUTPUT_FORMAT
2022-12-12 15:26:51.656 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_PREFETCH_THREADS
2022-12-12 15:26:51.656 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter TIME_OUTPUT_FORMAT
2022-12-12 15:26:51.656 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_RESULT_CHUNK_SIZE
2022-12-12 15:26:51.656 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter TIMESTAMP_TZ_OUTPUT_FORMAT
2022-12-12 15:26:51.656 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_SESSION_KEEP_ALIVE
2022-12-12 15:26:51.656 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_RS_COLUMN_CASE_INSENSITIVE
2022-12-12 15:26:51.656 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter SNOWPARK_HIDE_INTERNAL_ALIAS
2022-12-12 15:26:51.656 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_CONSERVATIVE_MEMORY_ADJUST_STEP
2022-12-12 15:26:51.656 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter QUERY_CONTEXT_CACHE_SIZE
2022-12-12 15:26:51.656 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_METADATA_USE_SESSION_DATABASE
2022-12-12 15:26:51.656 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_ENABLE_COMBINED_DESCRIBE
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter ENABLE_STAGE_S3_PRIVATELINK_FOR_US_EAST_1
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_RESULT_PREFETCH_THREADS
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter TIMESTAMP_NTZ_OUTPUT_FORMAT
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_TREAT_DECIMAL_AS_INT
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_HONOR_CLIENT_TZ_FOR_TIMESTAMP_NTZ
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_MEMORY_LIMIT
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_EFFICIENT_CHUNK_STORAGE
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_TIMESTAMP_TYPE_MAPPING
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter TIMEZONE
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter SNOWPARK_REQUEST_TIMEOUT_IN_SECONDS
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_RESULT_PREFETCH_SLOTS
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_DISABLE_INCIDENTS
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_ENABLE_CONSERVATIVE_MEMORY_USAGE
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter BINARY_OUTPUT_FORMAT
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CSV_TIMESTAMP_FORMAT
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_TELEMETRY_SESSIONLESS_ENABLED
2022-12-12 15:26:51.657 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_FORMAT_DATE_WITH_TIMEZONE
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_FORCE_PROTECT_ID_TOKEN
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter DATE_OUTPUT_FORMAT
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_CONSENT_CACHE_ID_TOKEN
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter SNOWPARK_LAZY_ANALYSIS
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_USE_JSON_PARSER
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_SESSION_KEEP_ALIVE_HEARTBEAT_FREQUENCY
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter AUTOCOMMIT
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_SESSION_CLONE
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter TIMESTAMP_LTZ_OUTPUT_FORMAT
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_USE_SESSION_TIMEZONE
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_TREAT_TIMESTAMP_NTZ_AS_UTC
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter JDBC_EXECUTE_RETURN_COUNT_FOR_DML
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_OUT_OF_BAND_TELEMETRY_ENABLED
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter SNOWPARK_USE_SCOPED_TEMP_OBJECTS
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_TELEMETRY_ENABLED
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_USE_V1_QUERY_API
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_RESULT_COLUMN_CASE_INSENSITIVE
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_ENABLE_LOG_INFO_STATEMENT_PARAMETERS
2022-12-12 15:26:51.658 n.s.c.core.SessionUtil FINE updateSfDriverParamValues:1410 - processing parameter CLIENT_STAGE_ARRAY_BINDING_THRESHOLD
2022-12-12 15:26:51.659 n.s.c.core.SFStatement FINE executeQueryInternal:246 - Done creating result set
2022-12-12 15:26:51.660 n.s.c.jdbc.SnowflakeStatementV1 FINE getResultSetType:642 - getResultSetType()
2022-12-12 15:26:51.661 n.s.c.jdbc.SnowflakeStatementV1 FINE getResultSetConcurrency:628 - getResultSetConcurrency()
2022-12-12 15:26:51.661 n.s.c.jdbc.SnowflakeStatementV1 FINE getResultSetHoldability:635 - getResultSetHoldability()
2022-12-12 15:26:51.661 n.s.c.jdbc.SnowflakeStatementV1 FINE unwrap:796 - unwrap(Class iface)
2022-12-12 15:26:51.661 n.s.c.jdbc.SnowflakeStatementV1 FINE getResultSet:621 - getResultSet()
2022-12-12 15:26:51.663 n.s.c.core.SFJsonResultSet FINE getLong:314 - public long getLong(int columnIndex)
2022-12-12 15:26:51.663 n.s.c.core.SFResultSet FINE next:282 - end of result
2022-12-12 15:26:51.663 n.s.c.core.SFBaseResultSet FINE close:118 - public void close()
2022-12-12 15:26:51.663 n.s.c.jdbc.SnowflakeStatementV1 FINE isWrapperFor:788 - isWrapperFor(Class<?> iface) 2022-12-12 15:26:51.663 n.s.c.jdbc.SnowflakeStatementV1 FINE unwrap:796 - unwrap(Class iface) 2022-12-12 15:26:51.663 n.s.c.jdbc.SnowflakeStatementV1 FINE close:823 - close() 2022-12-12 15:26:51.663 n.s.c.core.SFBaseResultSet FINE close:118 - public void close() 2022-12-12 15:26:51.663 n.s.c.jdbc.SnowflakeStatementV1 FINE isWrapperFor:788 - isWrapperFor(Class<?> iface)
2022-12-12 15:26:51.663 n.s.c.jdbc.SnowflakeStatementV1 FINE unwrap:796 - unwrap(Class iface)
2022-12-12 15:26:51.663 n.s.c.core.SFStatement FINE close:774 - public void close()
2022-12-12 15:26:51.664 n.s.c.jdbc.SnowflakeConnectionV1 FINE close:198 - public void close()
2022-12-12 15:26:51.664 n.s.c.core.SFSession FINE close:642 - public void close()
2022-12-12 15:26:51.664 n.s.c.core.SFSession FINE stopHeartbeatForThisSession:729 - stop heartbeat
2022-12-12 15:26:51.664 n.s.c.core.SessionUtil FINE closeSession:981 - public void close() throws SFException
2022-12-12 15:26:51.664 n.s.c.core.HttpUtil FINE executeRequestInternal:728 - Pool: [leased: 0; pending: 0; available: 3; max: 300] Executing: POST https://myaccount.us-east-1.snowflakecomputing.com:443/session?delete=true&requestId=5812f041-69ed-4294-8849-6e589d3efb87 HTTP/1.1
2022-12-12 15:26:51.664 n.s.c.jdbc.RestRequest FINE execute:122 - Retry count: 0
2022-12-12 15:26:51.666 n.s.c.jdbc.telemetry.TelemetryClient FINE sendBatch:310 - Payload of telemetry is : {"logs":[{"timestamp":"1670858811659","message":{"type":"client_time_consume_first_result","query_id":"01a8ebde-0406-475f-0000-13f98b567e9e","value":33}},{"timestamp":"1670858811662","message":{"type":"client_time_consume_last_result","query_id":"01a8ebde-0406-475f-0000-13f98b567e9e","value":6}}]}
2022-12-12 15:26:51.666 n.s.c.core.HttpUtil FINE executeRequestInternal:728 - Pool: [leased: 1; pending: 0; available: 2; max: 300] Executing: POST https://myaccount.us-east-1.snowflakecomputing.com:443/telemetry/send HTTP/1.1
2022-12-12 15:26:51.666 n.s.c.jdbc.RestRequest FINE execute:122 - Retry count: 0
2022-12-12 15:26:51.689 n.s.c.jdbc.RestRequest FINE execute:213 - HTTP response code: 200
2022-12-12 15:26:51.689 n.s.c.core.HttpUtil FINE executeRequestInternal:780 - Pool: [leased: 1; pending: 0; available: 2; max: 300] Request returned for: POST https://myaccount.us-east-1.snowflakecomputing.com:443/telemetry/send HTTP/1.1
2022-12-12 15:26:51.728 n.s.c.jdbc.RestRequest FINE execute:213 - HTTP response code: 200
2022-12-12 15:26:51.728 n.s.c.core.HttpUtil FINE executeRequestInternal:780 - Pool: [leased: 0; pending: 0; available: 3; max: 300] Request returned for: POST https://myaccount.us-east-1.snowflakecomputing.com:443/session?delete=true&requestId=5812f041-69ed-4294-8849-6e589d3efb87 HTTP/1.1
2022-12-12 15:26:51.728 n.s.c.core.SessionUtil FINE closeSession:1029 - connection close response: {
"data" : null,
"code" : null,
"message" : null,
"success" : true
}

3

Hi @cabarria
Looks like you got some v45 code mixed into your v44 build.
Either work in the branch release-x.44.x or in master and then build accordingly.

4

Success!!! That was it!