In last week’s post we talked about our pure, unrelenting hatred for PIVOTED data (you know, when months JAN, FEB, MAR, etc. each have their own column). As I am trying to hit my quota of hypocrite points this week, I’d like to talk about how to turn UNPIVOTED data into PIVOTED data. A…
Ever received data where the months were column headers, like below? Ever felt the need to do something unspeakable to your keyboard, right after? You are not alone. However! Fear not, because there is salvation. Thou needst only use the UNPIVOT function in Snowflake, and rest, peace and Eden will return to your data landscape.…
Sometimes you just want to test something real quick in Snowflake and you need a table with some simple values. The “VALUES” function can help. The SQL below speaks for itself.
Sometimes you are stuck with a slow view in Snowflake. Imagine this scenario: You’re trying to create an object with a slowpoke view as the source and development is as slow as taking the highway at 8 AM to work. You cannot edit and improve the view because it is a secure, shared object. The…
Are you looking for a certain column in a table? Using INFORMATION_SCHEMA is one way to do this. Below is another method you can use.
Ever wondered how to do a Multi-Column-JOIN in Power Query M? It is so simple to join TABLE_A to TABLE_B in SQL using multiple conditions on multiple columns: But how do we replicate this in Power Query M? Turns out we can add a column using the Power Query M function Table.SelectRows. Take a look…
Ever wondered what COMMIT and ROLLBACK do in Snowflake SQL? I know I have. Let me try to explain it using Snowflake SQL.
Just finished an excellent dbt (Data Build Tool) course on Udemy by Zoltan C. Toth. #dbt is a tool that can be used to develop data models. dbt applies many software engineering best practises to the workflow of transforming your data. What I really liked about dbt: – Version control is easily added to a…
Privilege inheritance in Snowflake’s role hierarchy is a powerful feature that simplifies access management and reduces administrative overhead. In Snowflake, roles can be granted to other roles, creating a hierarchical structure. Privileges associated with a role are inherited by any roles above it in the hierarchy. This means that when you grant a privilege to…
Is there someone you trust, but really don’t trust? Meaning, you would like to give him access to e.g. an S3 Bucket, but you don’t want to share authentication data with him? Storage Integrations are a great way of giving untrustworthy individuals access in such a manner! Kidding aside, Storage Integrations are a great way…