Relative Content

Tag Archive for javajdbcsnowflake-cloud-data-platform

SnowFlake JDBC Driver errror

We are using Java 17 temurin and Snowflake
While retriving the resultset below exception is fired.
flake.client.jdbc.SnowflakeSQLLoggedException: JDBC driver internal error: Fail to retrieve row count for first arrow chunk: null.
at net.snowflake.client.jdbc.SnowflakeResultSetSerializableV1.setFirstChunkRowCountForArrow(SnowflakeResultSetSerializableV1.java:1079)
at net.snowflake.client.jdbc.SnowflakeResultSetSerializableV1.create(SnowflakeResultSetSerializableV1.java:562)

Snowflake GET command unable to find an internal stage due to name expanding

Right now I am attempting to download staged files from Snowflake that are in an Internal Stage of a specific table, specifically <Database>.<Schema>.<My_table>. The logic would follow and according to the documentation, my GET command should look like GET @%My_table My_Download_Location. The problem is, for some reason the Java JDBC driver see this and when it tries to execute the query via a JDBCTemplate, it gets transformed into '<Database>.<Schema>."%<My_table>"' and then the query fails due to this location not actually existing since that name is invalid