What's under the Snowflake(s)? - Week 23 - Basic Are you curious about SnowSQL? Then, let's dedicate this new post of What's under the Snowflake(s)? of it! We focus on…
S1. What's under the Snowflake(s)? Week 38 - Basic Let's start the first episode of What's under the Snowflake(s)? The challenge we focus here is Week 38 - Basic from…
Database, table, and virtual warehouse are basic Snowflake objects required for most Snowflake activities. Setting them will be the first step in all our exercises! Let's see how to do…
Have you ever wondered what is under the snow? What are the snowflakes hiding? Have you ever wanted to investigate a little more to understand better, to see more clearly?…
Last week I found myself wondering about wildcard searches in SQL and Python. And to my own surprise, I found myself wishing for a SQL functionality in Python! For a…
This blogpost marks the beginning of a long and very exciting journey in the world of Analytics Engineering at Nimbus Intelligence. That journey of course starts from the basics, and…
When we talk about Business Intelligence we immediately think of the strategies connected to the processes of combining data collection, analysis and archiving to highlight useful information. Typically, this involves…
Three ways to delete your data. We compare three commands on different characteristics such as: the family of commands they belong to, their usage, the syntax of the command, the…
It is fair to state that, nowadays, we often happen to hear that data is the new gold. If it is true that potentially the real treasure possessed by companies…
During my formation on Snowflake at Nimbus Intelligence our professor showed us a query that appeared to be nesting Group By and Partitioning in order to calculate a percentage. Morever,…