Skip to content Skip to sidebar Skip to footer
Showing posts with the label Snowflake Cloud Data Platform
How To Convert Long Verbal Datetime To Timestamp (yy-mm-dd Hh:mm:ss) In Snowflake?

How To Convert Long Verbal Datetime To Timestamp (yy-mm-dd Hh:mm:ss) In Snowflake?

Post a Comment
I'm using snowflake dates. I have date in weird pattern (output from database): Wed Apr 21 2021… Read more How To Convert Long Verbal Datetime To Timestamp (yy-mm-dd Hh:mm:ss) In Snowflake?
How To Use Sql User Defined Function In Snowflake?

How To Use Sql User Defined Function In Snowflake?

Post a Comment
I am just studying how to use SQL in snowflake. Here is a snapshot: And this is the code used in h… Read more How To Use Sql User Defined Function In Snowflake?
How To Add A Constant Value (1) In An Empty Column In Snowflake-matillion

How To Add A Constant Value (1) In An Empty Column In Snowflake-matillion

Post a Comment
my table looks like id total avg test_no 1 445 89 2 434 85 3 378 75 4 421 … Read more How To Add A Constant Value (1) In An Empty Column In Snowflake-matillion
Parsing Xml With Unknown Structure In Snowflake

Parsing Xml With Unknown Structure In Snowflake

Post a Comment
I have a bunch of XML files that define tree hierarchies (relations between ID:s) via nested tags. … Read more Parsing Xml With Unknown Structure In Snowflake
Snowflake Sql Regex ~ Extracting Multiple Vals

Snowflake Sql Regex ~ Extracting Multiple Vals

Post a Comment
I am trying to identify a value that is nested in a string using Snowflakes regexp_substr() The val… Read more Snowflake Sql Regex ~ Extracting Multiple Vals
January 1st = Week 1

January 1st = Week 1

Post a Comment
The below gives me week numbers where week 1 starts on 1/4/2021 date_trunc('week', transact… Read more January 1st = Week 1