Data Engineering Archieven - Nimbus Intelligence

Jan 19

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…

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…

Oct 13

Love0

Visualizing API Data on Streamlit: Football Fan Tokens & Team Performance

By Darko Monzio Compagnoni Uncategorized No Comments

Background photo by Vienna Reyes on Unsplash Fan tokens have opened up exciting opportunities for fans to actively engage with their favorite sports teams and artists. These digital tokens, often…

Sep 22

Love0

Data Engineer vs Analytics Engineer: What’s the difference?

By Darko Monzio Compagnoni Uncategorized One Comment

Since I started my Analytics Engineer traineeship at Nimbus Intelligence, I noticed that this emerging role is often confused with the Data Engineer role. Photo source: Analytics Engineer: Job Description,…

May 22

Love0

Column Level Security

By Mario Calise Data, Data Load, Data Visualization, Snowflake, SQL

Snowflake, as a modern cloud database, has the functionality to mask sensitive data for unauthorized users through Data Governance Features. In this blog, we are thus going to present Dynamic…

May 17

Love0

Snowflake’s INFER SCHEMA

By Mario Calise Data, Data Load, Database, Pipes, Snowflake, SQL

In this blog, we are going to discuss how Snowflake allows to easily interpret semi-structured data through its Schema Detection feature. This feature helps gaining time when setting up the tables…

May 14

Love0

Create Named Stages using Snowsight

By Dimitris Lampriadis Snowflake

''With this release, we are pleased to announce the preview of creating and editing named stages using Snowsight without writing SQL. To create or edit named stages, you can enter…

May 14

Love0

Snowflake’s SPLIT_TO_TABLE function

By Dimitris Lampriadis Snowflake

In the following article, we will explore how to use Snowflake's SPLIT_TO_TABLE table function to split a string into a table and provide an example to demonstrate its capabilities. In…

Apr 26

Love0

How to connect VS Code to Snowflake

By Eloi Sanchez Snowflake, Uncategorized

During the last years, I have been using Visual Studio Code for everything. Therefore, now that I started using Snowflake I have had a hard time to adapt to its…

Apr 20

Love0

Optimizing SQL Queries in Snowflake

By Sebastian Wiesner Data, Snowflake, SQL

In this blog, we'll discuss practical tips and tricks to optimize SQL queries in Snowflake for better performance. Best practices for query design, data structure optimization, utilizing Snowflake's features, and…

Data Engineering

What makes Snowflake SQL outstanding from other DBMS

Killing JSON: Using Flatten to Load JSON Data

Visualizing API Data on Streamlit: Football Fan Tokens & Team Performance

Data Engineer vs Analytics Engineer: What’s the difference?

Column Level Security

Snowflake’s INFER SCHEMA

Create Named Stages using Snowsight

Snowflake’s SPLIT_TO_TABLE function

How to connect VS Code to Snowflake

Recent Posts

Milan office

Madrid office

Amsterdam office