SQL – Combining a GROUP BY with a COUNT DISTINCT PARTITION BY
Hey I am trying to figure out if this is possible to do in one query or if I need to use a CTE because windows functions are calculated after group bys.
How do I remove the line breaks in a text field?
How do I remove the line breaks in a text field?
Snowflake SQL repeat results
I would like to repeat results based on a field output.
Count Avg of last 36 months when months are in a wide format(cant change this format)
I have a weird snowflake table format which is causing issues when showing last 36 months of data only.
Use get_object_references to get all level dependencies of a object in snowflake
I have a view called cplx_vw1 in which there are again nested views and tables
my task is to break the level of cplx_wl1 till I found the refernced object type as table
For a RegEx_Substr, how do I extract words with a space or no space?
For a RegEx_Substr, how do I extract words with a space or no space? For example the words I’m trying to get out of the string: New Record and OrderRecord
In Snowflake, how do I parse log text data, with several delimiters, into multiple columns?
In Snowflake, how do I parse log text data, with several delimiters, into multiple columns?
In Snowflake, how do I parse the data in Log column to new columns?
In Snowflake, how do I parse the data in Log column to new columns?
In Snowflake, how do I get data before current month?
In Snowflake, how do I get data before current month?
how to derive ISO month from date in snowflake
it seems following function sql is not working to derive in snowflake .
TO_VARCHAR(DATE_TRUNC(”MONTH”, TO_DATE(YEAROFWEEKISO(DATE) || ”-01-01”, ”YYYY-MM-DD”) + (ISO_WEEK_NUMBER – 1) * 7), ”YYYY-MM”) AS ISO_MONTH