Snowflake connector login failures #24552

mstowe-digi · 2024-12-20T21:21:03Z

mstowe-digi
Dec 20, 2024

Hello,

I have configured the snowflake connector per the instructions here. When attempting to query against the connector I receive 404 not found error messages from attempts from the internal snowflake JDBC driver when trying to connect.

connector.name=snowflake
connection-url=jdbc:snowflake://***.snowflakecomputing.com
connection-user=***
connection-password=***
snowflake.account=***
snowflake.database=***
snowflake.role=***
snowflake.warehouse=***
case-insensitive-name-matching=True

When I run trino the snowflake catalog shows up.

trino> show catalogs;
  Catalog  
-----------
 mysql     
 snowflake 
 system    
(3 rows)

Query 20241220_210840_00001_pxx63, FINISHED, 1 node
Splits: 19 total, 19 done (100.00%)
0.96 [0 rows, 0B] [0 rows/s, 0B/s]

trino> show schemas from snowflake;

Query 20241220_210850_00002_pxx63, FAILED, 1 node
Splits: 19 total, 0 done (0.00%)
1.76 [0 rows, 0B] [0 rows/s, 0B/s]

Query 20241220_210850_00002_pxx63 failed: Error listing schemas for catalog snowflake: JDBC driver encountered communication error. Message: HTTP status=404.

trino>

The trino logs show the following additional details.

024-12-20 16:08:41 2024-12-20T21:08:41.948Z    INFO    dispatcher-query-3      io.trino.event.QueryMonitor     TIMELINE: Query 20241220_210840_00001_pxx63 :: FINISHED :: elapsed 961ms :: planning 377ms :: waiting 75ms :: scheduling 387ms :: running 74ms :: finishing 123ms :: begin 2024-12-20T21:08:40.981Z :: end 2024-12-20T21:08:41.942Z
2024-12-20 16:08:50 2024-12-20T21:08:50.222Z    INFO    SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.jdbc.SnowflakeConnectionV1 Initializing new connection
2024-12-20 16:08:50 2024-12-20T21:08:50.232Z    INFO    SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.SFSession    Opening session with server: https://****.snowflakecomputing.com:443/, account: ***, user: ***, password is provided, role: ***, database: ***, schema: null, warehouse: ***, validate default parameters: null, authenticator: null, ocsp mode: FAIL_OPEN, passcode in password: null, passcode is not provided, private key is not provided, disable socks proxy: null, application: null, app id: JDBC, app version: 3.19.1, login timeout: null, retry timeout: null, network timeout: null, query timeout: null, connection timeout: null, socket timeout: null, tracing: null, private key file: null, private key pwd is not provided, enable_diagnostics: not provided, diagnostics_allowlist_path: null, session parameters: client store temporary credential: null, gzip disabled: null, browser response timeout: null
2024-12-20 16:08:50 2024-12-20T21:08:50.233Z    INFO    SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.SFBaseSessionDriver OCSP mode: FAIL_OPEN, gzip disabled: false and no proxy
2024-12-20 16:08:50 2024-12-20T21:08:50.235Z    INFO    SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.SFSession    Connecting to GLOBAL Snowflake domain
2024-12-20 16:08:50 2024-12-20T21:08:50.246Z    INFO    SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.FileUtil     Cache file creation: Accessing file: /home/trino/.cache/snowflake/ocsp_response_cache.json
2024-12-20 16:08:50 2024-12-20T21:08:50.306Z    INFO    SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.FileUtil     Read cache: Accessing file: /home/trino/.cache/snowflake/ocsp_response_cache.json
2024-12-20 16:08:51 2024-12-20T21:08:51.036Z    INFO    SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.FileUtil     Write to cache: Accessing file: /home/trino/.cache/snowflake/ocsp_response_cache.json
2024-12-20 16:08:51 2024-12-20T21:08:51.404Z    ERROR   SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.jdbc.RestRequest  [requestId=***] Error response: HTTP Response code: 404, request: POST https://***.snowflakecomputing.com:443/session/v1/login-request?databaseName=REPORTING_QA&warehouse=ENG_DEVS&roleName=REPORTING_QA&requestId=*** HTTP/1.1
2024-12-20 16:08:51 2024-12-20T21:08:51.404Z    ERROR   SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.HttpUtil     Error executing request: POST https://***.snowflakecomputing.com:443/session/v1/login-request?databaseName=***&warehouse=***&roleName=***&requestId=*** HTTP/1.1
2024-12-20 16:08:51 2024-12-20T21:08:51.404Z    ERROR   SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.HttpUtil     Response status line reason: Not Found
2024-12-20 16:08:51 2024-12-20T21:08:51.411Z    ERROR   SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.HttpUtil     Response content: <!DOCTYPE html>
2024-12-20 16:08:51 <html lang="en-US">
2024-12-20 16:08:51 <head>
2024-12-20 16:08:51 <title>File not Found</title>
2024-12-20 16:08:51 
2024-12-20 16:08:51 <style media="screen" type="text/css">
2024-12-20 16:08:51 .ErrorContainer {
2024-12-20 16:08:51     width: 650px;
2024-12-20 16:08:51     margin: 100px auto;
2024-12-20 16:08:51     background: #f5f5f5;
2024-12-20 16:08:51     padding: 44px;
2024-12-20 16:08:51     border-radius: 7px;
2024-12-20 16:08:51     -moz-box-shadow: 0 1px 15px rgba(0, 0, 0, 0.25);
2024-12-20 16:08:51     box-shadow: 0 1px 15px rgba(0, 0, 0, 0.25);
2024-12-20 16:08:51 }
2024-12-20 16:08:51 body{
2024-12-20 16:08:51     color: #565656;
2024-12-20 16:08:51     background:#00BBE6;
2024-12-20 16:08:51     margin: 0;
2024-12-20 16:08:51     font: 100%/1.8 "Helvetica Neue", Arial, Helvetica, Geneva, sans-serif;
2024-12-20 16:08:51 }
2024-12-20 16:08:51 
2024-12-20 16:08:51 
2024-12-20 16:08:51 div.BodyLogo{background:url("data:image/png;base64,iVBORw0...QmCC") no-repeat #00BBE6;
2024-12-20 16:08:51     width: 390px;
2024-12-20 16:08:51     height: 100px;
2024-12-20 16:08:51     margin-top: 32px;
2024-12-20 16:08:51     margin-left: 32px;
2024-12-20 16:08:51     font-size: 1em;
2024-12-20 16:08:51 }
2024-12-20 16:08:51 
2024-12-20 16:08:51 p.ErrorBody {
2024-12-20 16:08:51     font: 1.2em/1.6 "Helvetica Neue", Arial, Helvetica, Geneva, sans-serif;
2024-12-20 16:08:51 }
2024-12-20 16:08:51 
2024-12-20 16:08:51 h1 {
2024-12-20 16:08:51     font: bold 2.4em "Helvetica Neue", Arial, Helvetica, Geneva, sans-serif;
2024-12-20 16:08:51     margin: 0px;
2024-12-20 16:08:51 }
2024-12-20 16:08:51 
2024-12-20 16:08:51 a.ErrorLinks{
2024-12-20 16:08:51     color: #555655;
2024-12-20 16:08:51     font-size: 1em;
2024-12-20 16:08:51 }
2024-12-20 16:08:51 
2024-12-20 16:08:51 a:hover{
2024-12-20 16:08:51     text-decoration: underline;
2024-12-20 16:08:51 }
2024-12-20 16:08:51 
2024-12-20 16:08:51 /* Rectangle 478: */
2024-12-20 16:08:51 background: #00BBE6;
2024-12-20 16:08:51 /* Oops! Page not found: */
2024-12-20 16:08:51 font-family: Helvetica-Bold;
2024-12-20 16:08:51 font-size: 34px;
2024-12-20 16:08:51 color: #FFFFFF;
2024-12-20 16:08:51 line-height: 41px;
2024-12-20 16:08:51 /* bg: */
2024-12-20 16:08:51 background: #FFFFFF;
2024-12-20 16:08:51 box-shadow: 0px 1px 15px 0px rgba(0,0,0,0.10);
2024-12-20 16:08:51 border-radius: 8px;
2024-12-20 16:08:51 /* Oops! Page not found: */
2024-12-20 16:08:51 font-family: Helvetica-Bold;
2024-12-20 16:08:51 font-size: 34px;
2024-12-20 16:08:51 color: #4A4A4A;
2024-12-20 16:08:51 line-height: 41px;
2024-12-20 16:08:51 /* Go Home: */
2024-12-20 16:08:51 font-family: Helvetica;
2024-12-20 16:08:51 font-size: 14px;
2024-12-20 16:08:51 color: rgba(74,74,74,0.80);
2024-12-20 16:08:51 line-height: 17px;
2024-12-20 16:08:51 /* Wordmark - Blue@1x: */
2024-12-20 16:08:51 background: #FFFFFF;
2024-12-20 16:08:51 </style>
2024-12-20 16:08:51 </head>
2024-12-20 16:08:51 
2024-12-20 16:08:51 <body>
2024-12-20 16:08:51 <div class="BodyLogo">
2024-12-20 16:08:51 </div>
2024-12-20 16:08:51 <div class="ErrorContainer">
2024-12-20 16:08:51 
2024-12-20 16:08:51 <h1>Error 404 Not Found</h1>
2024-12-20 16:08:51 
2024-12-20 16:08:51 <p class="ErrorBody">Our apologies for the inconvenience. The requested URL was not found on this server.  We suggest you try the following:
2024-12-20 16:08:51  <ul>
2024-12-20 16:08:51  <li><b>Verify url and typos</b> - The web page you were attempting to view may not exist or may have moved - try <em>checking the web address for typos</em>.<//li>
2024-12-20 16:08:51    </ul>
2024-12-20 16:08:51 
2024-12-20 16:08:51 </div>
2024-12-20 16:08:51 
2024-12-20 16:08:51 </body>
2024-12-20 16:08:51 
2024-12-20 16:08:51 </html>
2024-12-20 16:08:51 
2024-12-20 16:08:51 2024-12-20T21:08:51.417Z    INFO    SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.jdbc.SnowflakeConnectionV1 Initializing new connection
2024-12-20 16:08:51 2024-12-20T21:08:51.419Z    INFO    SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.SFSession    Opening session with server: https://***.snowflakecomputing.com:443/, account: ***, user: ***, password is provided, role: ***, database: ***, schema: null, warehouse: ***, validate default parameters: null, authenticator: null, ocsp mode: FAIL_OPEN, passcode in password: null, passcode is not provided, private key is not provided, disable socks proxy: null, application: null, app id: JDBC, app version: 3.19.1, login timeout: null, retry timeout: null, network timeout: null, query timeout: null, connection timeout: null, socket timeout: null, tracing: null, private key file: null, private key pwd is not provided, enable_diagnostics: not provided, diagnostics_allowlist_path: null, session parameters: client store temporary credential: null, gzip disabled: null, browser response timeout: null
2024-12-20 16:08:51 2024-12-20T21:08:51.419Z    INFO    SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.SFBaseSessionDriver OCSP mode: FAIL_OPEN, gzip disabled: false and no proxy
2024-12-20 16:08:51 2024-12-20T21:08:51.419Z    INFO    SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.SFSession    Connecting to GLOBAL Snowflake domain
2024-12-20 16:08:51 2024-12-20T21:08:51.753Z    ERROR   SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.jdbc.RestRequest  [requestId=***] Error response: HTTP Response code: 404, request: POST https://***.snowflakecomputing.com:443/session/v1/login-request?databaseName=***&warehouse=***&roleName=***&requestId=*** HTTP/1.1
2024-12-20 16:08:51 2024-12-20T21:08:51.754Z    ERROR   SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.HttpUtil     Error executing request: POST https://***.snowflakecomputing.com:443/session/v1/login-request?databaseName=***&warehouse=***&roleName=***&requestId=*** HTTP/1.1
2024-12-20 16:08:51 2024-12-20T21:08:51.754Z    ERROR   SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.HttpUtil     Response status line reason: Not Found
2024-12-20 16:08:51 2024-12-20T21:08:51.759Z    ERROR   SplitRunner-20241220_210850_00002_pxx63.2.0.0-1-208     net.snowflake.client.core.HttpUtil     Response content: <!DOCTYPE html>
2024-12-20 16:08:51 <html lang="en-US">
2024-12-20 16:08:51 <head>
2024-12-20 16:08:51 <title>File not Found</title>
2024-12-20 16:08:51 
2024-12-20 16:08:51 <style media="screen" type="text/css">
2024-12-20 16:08:51 .ErrorContainer {
2024-12-20 16:08:51     width: 650px;
2024-12-20 16:08:51     margin: 100px auto;
2024-12-20 16:08:51     background: #f5f5f5;
2024-12-20 16:08:51     padding: 44px;
2024-12-20 16:08:51     border-radius: 7px;
2024-12-20 16:08:51     -moz-box-shadow: 0 1px 15px rgba(0, 0, 0, 0.25);
2024-12-20 16:08:51     box-shadow: 0 1px 15px rgba(0, 0, 0, 0.25);
2024-12-20 16:08:51 }
2024-12-20 16:08:51 body{
2024-12-20 16:08:51     color: #565656;
2024-12-20 16:08:51     background:#00BBE6;
2024-12-20 16:08:51     margin: 0;
2024-12-20 16:08:51     font: 100%/1.8 "Helvetica Neue", Arial, Helvetica, Geneva, sans-serif;
2024-12-20 16:08:51 }
2024-12-20 16:08:51 
2024-12-20 16:08:51 
2024-12-20 16:08:51 div.BodyLogo{background:url("data:image/png;base64,iVBO....CC") no-repeat #00BBE6;
2024-12-20 16:08:51     width: 390px;
2024-12-20 16:08:51     height: 100px;
2024-12-20 16:08:51     margin-top: 32px;
2024-12-20 16:08:51     margin-left: 32px;
2024-12-20 16:08:51     font-size: 1em;
2024-12-20 16:08:51 }
2024-12-20 16:08:51 
2024-12-20 16:08:51 p.ErrorBody {
2024-12-20 16:08:51     font: 1.2em/1.6 "Helvetica Neue", Arial, Helvetica, Geneva, sans-serif;
2024-12-20 16:08:51 }
2024-12-20 16:08:51 
2024-12-20 16:08:51 h1 {
2024-12-20 16:08:51     font: bold 2.4em "Helvetica Neue", Arial, Helvetica, Geneva, sans-serif;
2024-12-20 16:08:51     margin: 0px;
2024-12-20 16:08:51 }
2024-12-20 16:08:51 
2024-12-20 16:08:51 a.ErrorLinks{
2024-12-20 16:08:51     color: #555655;
2024-12-20 16:08:51     font-size: 1em;
2024-12-20 16:08:51 }
2024-12-20 16:08:51 
2024-12-20 16:08:51 a:hover{
2024-12-20 16:08:51     text-decoration: underline;
2024-12-20 16:08:51 }
2024-12-20 16:08:51 
2024-12-20 16:08:51 /* Rectangle 478: */
2024-12-20 16:08:51 background: #00BBE6;
2024-12-20 16:08:51 /* Oops! Page not found: */
2024-12-20 16:08:51 font-family: Helvetica-Bold;
2024-12-20 16:08:51 font-size: 34px;
2024-12-20 16:08:51 color: #FFFFFF;
2024-12-20 16:08:51 line-height: 41px;
2024-12-20 16:08:51 /* bg: */
2024-12-20 16:08:51 background: #FFFFFF;
2024-12-20 16:08:51 box-shadow: 0px 1px 15px 0px rgba(0,0,0,0.10);
2024-12-20 16:08:51 border-radius: 8px;
2024-12-20 16:08:51 /* Oops! Page not found: */
2024-12-20 16:08:51 font-family: Helvetica-Bold;
2024-12-20 16:08:51 font-size: 34px;
2024-12-20 16:08:51 color: #4A4A4A;
2024-12-20 16:08:51 line-height: 41px;
2024-12-20 16:08:51 /* Go Home: */
2024-12-20 16:08:51 font-family: Helvetica;
2024-12-20 16:08:51 font-size: 14px;
2024-12-20 16:08:51 color: rgba(74,74,74,0.80);
2024-12-20 16:08:51 line-height: 17px;
2024-12-20 16:08:51 /* Wordmark - Blue@1x: */
2024-12-20 16:08:51 background: #FFFFFF;
2024-12-20 16:08:51 </style>
2024-12-20 16:08:51 </head>
2024-12-20 16:08:51 
2024-12-20 16:08:51 <body>
2024-12-20 16:08:51 <div class="BodyLogo">
2024-12-20 16:08:51 </div>
2024-12-20 16:08:51 <div class="ErrorContainer">
2024-12-20 16:08:51 
2024-12-20 16:08:51 <h1>Error 404 Not Found</h1>
2024-12-20 16:08:51 
2024-12-20 16:08:51 <p class="ErrorBody">Our apologies for the inconvenience. The requested URL was not found on this server.  We suggest you try the following:
2024-12-20 16:08:51  <ul>
2024-12-20 16:08:51  <li><b>Verify url and typos</b> - The web page you were attempting to view may not exist or may have moved - try <em>checking the web address for typos</em>.<//li>
2024-12-20 16:08:51    </ul>
2024-12-20 16:08:51 
2024-12-20 16:08:51 </div>
2024-12-20 16:08:51 
2024-12-20 16:08:51 </body>
2024-12-20 16:08:51 
2024-12-20 16:08:51 </html>
2024-12-20 16:08:51 
2024-12-20 16:08:51 2024-12-20T21:08:51.828Z    INFO    dispatcher-query-2      io.trino.event.QueryMonitor     TIMELINE: Query 20241220_210850_00002_pxx63 :: FAILED (JDBC_ERROR) :: elapsed 1757ms :: planning 47ms :: waiting 31ms :: scheduling 82ms :: running 1607ms :: finishing 21ms :: begin 2024-12-20T21:08:50.029Z :: end 2024-12-20T21:08:51.786Z

Answered by mstowe-digi

Dec 30, 2024

I resolved this via the snowflake docs here.

Should have been using:

jdbc:snowflake://orgname-accountname.snowflakecomputing.com

but was using:

jdbc:snowflake://accountname.snowflakecomputing.com

View full answer

mstowe-digi · 2024-12-30T18:47:51Z

mstowe-digi
Dec 30, 2024
Author

I resolved this via the snowflake docs here.

Should have been using:

jdbc:snowflake://orgname-accountname.snowflakecomputing.com

but was using:

jdbc:snowflake://accountname.snowflakecomputing.com

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Snowflake connector login failures #24552

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 1 comment

{{title}}

Select a reply

Snowflake connector login failures #24552

mstowe-digi Dec 20, 2024

Replies: 1 comment

mstowe-digi Dec 30, 2024 Author

mstowe-digi
Dec 20, 2024

mstowe-digi
Dec 30, 2024
Author