All Questions
Tagged with snowflake-cloud-data-platform java
127
questions
0
votes
0
answers
42
views
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 ...
0
votes
0
answers
28
views
snowflake streaming key pair authentication fail with encrypted key
I am using the snowflake streaming API SDK to connect to snowflake using key pair authentication mechanism with encrypted keys.
Used following commands to generate encrypted keys:-
openssl genrsa 2048 ...
0
votes
0
answers
86
views
Using PreparedStatement with Snowflake/SnowQL RLIKE clause not working due to quotations " vs '
When inserting into a prepared statement using the setString() method it forces double quotes around the value. Snowflake/SnowQL requires single quotes when using RLIKE and other methods in its where ...
0
votes
0
answers
52
views
Accessing snowflake using snowpark java API: merge function giving error Object 'SNOWPARK_TEMP_TABLE_<somename>' does not exist or not authorized
I am trying to connect to snowflake using snowpark Java API with ACCOUNTADMIN access, I am getting below error when i try to merge. Is there something wrong i am doing.
public class MovieRatings {
...
0
votes
3
answers
107
views
Wrong time zone in Snowflake Java UDTF
In our Snowflake account, the time zone is set to America/New_York. There is a column in a table that is declared as DATE, so it does not store a time or time zone component. We pass values from that ...
1
vote
0
answers
37
views
Snowpark Java | Scala Signature package has wrong version
A while back, I created a Java project using sbt build tool.
Sample:
scalaVersion := "2.12.11"
crossPaths := false
javacOptions ++= Seq("-source", "11")
...
1
vote
0
answers
91
views
How to prevent SQL Injection when I need to run Snowflake's USE ROLE from the code?
I am using Snowflake. And I have Spring Boot app where I've configured JDBC connection.
I am using Spring's org.springframework.jdbc.core.JdbcTemplate to run the following query:
public void setRole(...
0
votes
0
answers
52
views
How can I implement this method to prevent from sql injection? Any help would be very much appreciated. Thank you all
I am trying to stage a file in snowflake using JdbcTemplate.execute() but I don't know how protect it against sql injection.
private void stageFile(String fpath){
template.execute("PUT file://...
0
votes
0
answers
66
views
Snowflake java UDF AES_256/GCM/NoPadding not available
I have external encrypt function written in Groovy and try to write the decrypt UDF in Snowflake using Java. I'm getting the error. java.security.NoSuchAlgorithmException: Cannot find any provider ...
0
votes
0
answers
64
views
Date difference function in snowflake is giving one more count for same query in DB2
We are migrating from DB2 to Snowflake. For the same query in DB2 and snowflake the datediff() of snowflake is giving count more then one for some of the values not for all campared to Days() of DB2....
0
votes
0
answers
31
views
Snowflake javascript procedure doesn't use the session on which it was called from java application
I have a procedure written in javascript. The procedure is called, multiple times, from java using snowflake jdbc implementation. We have observed that the procedures runs in different sessions that ...
0
votes
0
answers
149
views
Does SnowflakeIO Connector in Java support Flink?
As per the document on https://beam.apache.org/documentation/io/built-in/snowflake/#running-main-command-with-pipeline-options, I can only see DirectRunner and DataflowRunner, and I have tested the ...
0
votes
0
answers
42
views
Processing large dataset in Snowflake and Java Cron job
If I have the following tables in snowflake,
Users with 225,000 rows. Users has userid column
User Purchase History with 225,000,000 rows. User Purchase History has userid, list of upc for each ...
0
votes
0
answers
240
views
Trying to connect snowflake using flyway-migration
ERROR: Unable to determine the original schema for the connection
SQL State : XX000
Error Code : 200001
Message : JDBC driver internal error: exception creating result java.lang....
1
vote
0
answers
62
views
Snowflake Query Compilation issue
I am executing snowflake query in springboot. I am getting Sql compilation error.
Java String Query:
" select '1' as AgeGroup, '0-17' as ag_label from sysibm.sysdummy1 union " +
...