I'm writing a script to create 5 tables, but cannot seem to get the SQL DDL part of the statement to work. I get a syntax error " unexpected 'table' ", and I've tried the SQL statement with execute immediate…
I'm trying to migrate a Redshift SQL script to Snowflake and trying to emulate week number on Snowflake. Below is the sample Redshift code: select cast(to_char('2020-01-06'::date, 'WW') as int) as week, cast(to_char('2020-01-06'::date, 'IW') as int) as iso_week, '2020-01-06'::date; The closest…
I was trying to read from a table in snowflake and manipulate data and trying to write back ! I was able to connect to snow flake , read data as dataframe but cannot write back to the table code…
I'm using the snowflake node driver to connect to a DB. When running the connector from a local server I have no issues. However, when I try the same function running in lambda I can't seem to connect. There are…
I have a case statement to rectify one business logic in snowflake: INSERT INTO DB.table_b SELECT CASE WHEN UPPER(emp) <> LOWER(emp) THEN NULL WHEN emp IS NULL THEN nullif(emp, 'NULL') ELSE emp END AS emp_no FROM DB.table_a; The 'table_a' content…
I'm unable to connect to snowflake via a dockerized pyspark container. I do not find the snowflake documentation to be helpful nor the pyspark documentation at this point in time. I'm using the following configuration installed & can be seen…
We're running Matillion (v1.54) on an AWS EC2 instance (CentOS), based on Tomcat 8.5. We have developped a few ETL jobs by now, and their execution takes quite a lot of time (that is, up to hours). We'd like to…
This is my first time posting here, so please let me know if you need more info. I am using stitch and snowflake to query my Shopify data. I am trying to extract the price, sku, and product_id in LINE_ITEM…
I'm trying to parse out some JSON files in snowflake. In this case, I'd like to extract the "gift card" from the line that has "fulfillment_service": "gift_card". I've had success querying one dimensional JSON data, but this - with the…
It seems there is some issue with the latest snowflake connector. I am trying to install it on Ubuntu OS and trying to connect to snowflake, but it gives the error AttributeError: 'SSLSocket' object has no attribute 'connection' Here are…