I followed all the steps mentioned for ODI to connect to Snowflake and I am able to connect 'without agent' I also 'unset' the SSL/TLS parameter using code belo
I am trying to run a query in Snowflake to convert a GeoJSON object into Snowflake's baked-in geospatial data types: SELECT id, -- some other columns TRY
I am trying to run a query in Snowflake to convert a GeoJSON object into Snowflake's baked-in geospatial data types: SELECT id, -- some other columns TRY
var get_end_time = "select CURRENT_TIME()"; var time_sql = {sqlText: get_end_time}; var time_create = snowflake.createStatement(time_sql); var time_exec_end = t
I have Java code that extracts metadata from a JDBC connection. One of the calls is to extract the imported keys. The database has the RI created, but is disa
I have to write a JavaScript UDF function in Snowflake that receives a variant as the argument and do some value changes for a few keys. All is good but there's
I'm struggling with a SQL code performance issue, while trying to identify in advance circular references of a dataset with approximately 1.5 MO rows candidates
I'm currently using Powershell and snowsql to execute numerous SQL statements asynchronously and want snowsql to raise an error on exit, if one of those sql sta
I have a Key-value based records in the Snowflake table, where for a given product_id there are dozens of Key-value pairs records. See the example below: with
I want to create an external stage in snowflake, which will use S3 access point to access files stored in S3 bucket. I've started by creating a IAM Role, with a
I am getting the message "query produced no results" when I try to execute a refresh of my external table in Snowflake. Below are the steps I have taken leadin
I am looking at the queries performed against my warehouse and finding the credit calculation I'm using doesn't add up to what's being shown in snowflake. As I
Snowflake's federation authentication documentation does not explicitly mention Customer Identity Access Management (CIAM): https://docs.snowflake.com/en/user-g
I need information if cross cloud storage integration is allowed in Snowflake. Scenario :: My Snowflake account is hosted on AWS(Standard edition) & is oper
I am trying to read data from snowflake and load it to other storage location. I am using snowflake jdbc driver 3.12.9 to read the data and jackson library(2.10
I am trying to connect Snowflake to Matillion ETL using key-pair authentication. I'm facing the error 'Default Database must not be empty'. We have given a defa
I got my source data XML into snowflake stage tables. It's quite a complex XML document data for each record in the table. I got some of the elements using flat
I have a table like below, and want to create a new column that contains a list of values from another column subsequent rows like below, for copy paste: time
I'm trying to implement error handling in snowflake using Try Catch block. Enclosed SQL queries in javascript for applying error handling. When I execute the qu
So I have a column in a table as follows: TBL JFK 257: Gremlin vs Ronald 2 JFK 271: Walter vs Hamburglar JFK 272: Pizza vs Papa 1 JFK 272: Pizza vs Papa 2 JFK 2