SQL Archieven - Pagina 3 di 3 - Nimbus Intelligence

Mar 23

S3. What’s under the Snowflake(s)?

By Sofia Pierini Frosty friday, Snowflake, SQL

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…

Mar 22

Love0

S1. What’s under the Snowflake(s)?

By Sofia Pierini Frosty friday, Snowflake, SQL

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…

Mar 21

Love0

S0. What’s under the Snowflake(s)?

By Sofia Pierini Database, Python, Snowflake, SQL

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…

Mar 21

Love0

What’s under the Snowflake(s)?

By Sofia Pierini Frosty friday, Python, Snowflake, SQL

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?…

Mar 20

Love0

Wildcard searches in SQL and Python

By Kris Winnubst Python, SQL No Comments

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…

Mar 20

Love0

Nesting Aggregated functions

By Dimitris Lampriadis SQL

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…

Mar 17

Love0

Zero-Copy Cloning: Snowflake’s unique feature

By Mario Calise Academy, Database, Snowflake, SQL

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…

Mar 17

Love0

DROP,TRUNCATE and DELETE

By Niccolo Racioppi Snowflake, SQL, Uncategorized

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…

Mar 01

Love0

Data Normalization and Table Joins: a short guide to keep your database clean and your tables rich!

By Mario Calise Database, SQL

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…