Does anyone having issue with using Spice with Snowflake as datasource ?
For the same query “Direct Query” mode work just fine and dashboard can display properly.
But when i change to “Spice” mode I’m getting the following error
DBC driver internal error: Max retry reached for the download of #chunk0 (Total chunks: 256) retry=10, error=net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connect to [xxx] [/52.218.90.240] failed: connect timed out. at net.snowflake.client.jdbc.RestRequest.execute(RestRequest.java:328) at net.snowflake.client.jdbc.SnowflakeChunkDownloader$2.getResultChunk(SnowflakeChunkDownloader.java:1190) at net.snowflake.client.jdbc.SnowflakeChunkDownloader$2.getInputStream(SnowflakeChunkDownloader.java:847) at net.snowflake.client.jdbc.SnowflakeChunkDownloader$2.call(SnowflakeChunkDownloader.java:1051) at net.snowflake.client.jdbc.SnowflakeChunkDownloader$2.call(SnowflakeChunkDownloader.java:836) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Caused by: org.apache.http.conn.ConnectTimeoutException: Connect to [xxx]
failed: connect timed out at org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:151) at net.snowflake.client.core.SFHttpConnectionOperator.connect(SFHttpConnectionOperator.java:33) at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:376) at org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:401) at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:236) at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:186) at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.