snowflake Archives

Convert query for count and updated date

By adminPosted on March 2, 2023

Question : I currently run the below query in Snowflake for some of my reconciliations and have never worked in […]

By adminPosted on January 2, 2023

Question : Is there a work around to use window functions in update statement You can populate sample/original table using […]

By adminPosted on April 22, 2022

Question : I am having a schema where I wanted to grant permissions in the following manner. What is the […]

By adminPosted on January 27, 2022

Question : I am working on a problem that requires a very large join. The JOIN itself is pretty straightforward […]

By adminPosted on October 13, 2020

Question : I’ve an Employee table with StartDate and EndDate as columns. How can I get a progressive sum of […]

By adminPosted on April 16, 2020

Question : I have some data that looks something like this: key B 1 true 1 false 2 false 2 […]