SQL Archieven - Nimbus Intelligence

Mar 01

Elevate Your Business with Analytics Engineering

By Jordi Kiesewetter Uncategorized No Comments

In the world of information overload, analytics engineering emerges as a guiding force, paving the way for insights and advancements. As a trainee in analytics engineering at Nimbus Intelligence, I've…

Jan 19

Love0

How to write cleaner SQL queries

By Dominique Uncategorized No Comments

In the world of database management, crafting efficient and readable SQL queries is an essential skill for developers and data professionals alike. Writing clean and optimized SQL queries enhances your…

Jan 19

Love0

What makes Snowflake SQL outstanding from other DBMS

By Feruz Kholov Uncategorized No Comments

SQL, or Structured Query Language, is a cornerstone of data management, widely used for interacting with relational databases. While the core syntax of SQL remains consistent across various database management…

Dec 01

Love0

Macros in dbt

By Luca Balduzzi dbt, Jinja, SQL, Uncategorized No Comments

Macros in dbt are reusable pieces of code that ensure that the code is ‘DRY’ (don’t repeat yourself), making it easier to understand and quicker to write. If you’re interested…

Nov 17

Love0

Killing JSON: Using Flatten to Load JSON Data

By Edoardo Draetta Data Load, JSON, Snowflake, SQL, Unstructured Data No Comments

Welcome back to Killing JSON, the series in which I channel my frustration with loading data into teaching you something. Last week, we covered the ins and outs of the…

Nov 10

Love0

Killing JSON: The Flatten Function

By Edoardo Draetta JSON, Snowflake, Unstructured Data 2 Comments

Welcome to Killing JSON, a series in which I channel my frustration with loading data into teaching you something. Today, we're talking about the FLATTEN function in Snowflake. Flattening JSON,…

Nov 10

Love0

Understanding modularity

By Darko Monzio Compagnoni Uncategorized No Comments

Last week we talked about DBT models. It's time to dive deeper in understanding modularity. What is Modularity? According to the Cambridge Dictionary: "modularity is the quality of consisting of separate parts that, when combined, form a complete whole. A system lacks modularity…

Nov 10

Love0

Snowflake Hybrid Tables

By Luca Balduzzi Database, Snowday, Snowflake No Comments

Hybrid Tables in Snowflake are a new type of table that can support transactional workloads. They store data in a row-oriented format, and allow fast single-row operations as well as…

Sep 15

Love0

Can a Marketer become an Analytics Engineer?

By Darko Monzio Compagnoni Uncategorized No Comments

Switching careers is never easy. It involves stepping out of one's comfort zone, confronting uncertainties, and dedicating countless hours to acquiring new skills and knowledge. We know that a philosopher…

May 30

Love0

Modern Data Stack in One Day

By Kris Winnubst Academy, dbt, Fivetran, Snowflake, SQL

At Nimbus Intelligence Academy we are trained to build a modern data stack including data warehousing, ELT processes and scheduled refreshing of data. Each trainee has set up a modern…