I have a source data which contains the following type of a JSON array: [ [ "source 1", 250 ], [ "other source", 58 ], [ "more stuff", 42 ], ... ] There can be 1..N pairs of string...

Can we pass list or array as parameter to javascript procedure in snowflake? I am working on procedure which would run weekly and delete a week old data from certain tables. Instead of creating tas...

After upgrading to macOS Big Sur my snowsql scripts all fail with "The Library Security could not be found" $ snowsql -q "select 1 x" User: me Password: XXX The library Security...

Is it possible to stop a running query in the SnowSQL command line tool? Let's say I made a mistake and I tried to run a heavy query. Control-C, Esc, Q... nothing seems to stop it. The only way see...

HI I have downloaded and installed SNowSQL onto my Windows Machine 64 bit machine After entering command snowsql -a zx12334 -u someone ; i am getting following error Failed to initialize log. No lo...

Given two dates, I would like to create an array that holds all of the days between those dates and then filter it to contain only the days that fall at the end of a month. For example, with start...

I have a date column and a time column and I'd like to make a datetime/timestamp. I've tried Date+Time but I get: SQL compilation error: error line 4 at position 14 Invalid argument types f...