Home » blogs new

Filter

AllAcademyAirbyteCacheCoalesceDataData GenerationData LoadData VisualizationDatabaseDatabase CreationdbtFivetranFrosty fridayGitgithubGoogle ColabJinjaJSONMock DataPipesPythonQuizSecuritySnowdaySnowflakeSnowPro core certificationSnowsightSQLTechnology and ToolsUncategorizedUncategorizedUnstructured Data

Uncategorized

Why the Coalesce x CastorDoc Acquisition is a Game-Changer for Modern Data Teams

As a proud Coalesce partner specializing in end-to-end modern data stack implementations—covering everything from initial…

Martijn VerstrepenApril 29, 2025

Uncategorized

Business Case: From Excel to an automated Modern Data Warehouse

A few months ago, we were tasked with migrating the data workflow of a property…

Eloi SanchezApril 2, 2025

Uncategorized

Solving the “it works on my machine” issue using Docker

Docker has revolutionized the way applications are developed, tested, and deployed. It addresses several common…

Darko Monzio CompagnoniDecember 12, 2024

Uncategorized

Apache Airflow vs Dagster for Data Orchestration

In my last blog, I briefly described Dagster. In data engineering, effective orchestration tools are…

Darko Monzio CompagnoniNovember 19, 2024

dbtUncategorized

Using Dagster as a data orchestration tool: some examples

Dagster is an innovative open-source data orchestrator which offers a robust solution for designing, testing,…

Darko Monzio CompagnoniNovember 4, 2024

CoalesceSnowflakeUncategorized

How to read files from a Snowflake Internal Stage in Coalesce.io

When working with Snowflake and Coalesce.io to build a modern data pipeline, one of the…

Darko Monzio CompagnoniOctober 22, 2024

Snowflake

5 ways to optimize Snowflake performance and reduce credit usage

Learning to optimize Snowflake performance and reduce credit usage is important to do more within…

Darko Monzio CompagnoniOctober 14, 2024

SnowflakeUncategorized

Cutting costs with the new QUERY_ATTRIBUTION_HISTORY view in Snowflake.

I follow the Snowflake Data Superheroes on LinkedIn to get useful insights and updates about…

Darko Monzio CompagnoniSeptember 12, 2024

Uncategorized

About dbt’s Column-level lineage feature

Recently, dbt (data build tool) released Column-Level Lineage (CLL) within dbt Explorer, offering granular insights…

Darko Monzio CompagnoniAugust 29, 2024

DataSecurityTechnology and ToolsUncategorized

The balance between privacy and personalization when collecting behavioral data.

    “Most of the world will make decisions by either guessing or using their…

Darko Monzio CompagnoniJuly 19, 2024

dbtSnowflakeTechnology and ToolsUncategorized

Here’s what you need to build a Customer 360

First of all, what is a Customer 360? Hint: it's not a trick one can…

Darko Monzio CompagnoniJuly 5, 2024

SecuritySnowflakeUncategorized

Snowflake’s involvement in the Ticketmaster data breach. What happened and how to prevent it.

Header photo by Kaffeebart on Unsplash   On May 31, 2024, Ticketmaster confirmed a data…

Darko Monzio CompagnoniJune 6, 2024

SnowflakeUncategorized

Road to Snowflake Data Engineer: Storage and Data Protection

Road to Snowflake Data Engineer: Storage and Data Protection Third blog of the Road to…

Darko Monzio CompagnoniMay 3, 2024

Uncategorized

Road to Snowflake Data Engineer: Performance Optimization

Second blog of the Road to Snowflake Data Engineer series. If you've already read the…

Darko Monzio CompagnoniApril 26, 2024

Frosty fridaySnowflakeUncategorized

Road to Snowflake Data Engineer: Data Movement

Mastering data moving is the first step to becoming a Snowflake certified Data Engineer. DALL-E…

Darko Monzio CompagnoniApril 19, 2024

githubSnowflakeUncategorized

AI Copilots in Analytics Engineering

Last night, I attended the 10th Analytics Engineering Meetup in Amsterdam. It was my first…

Darko Monzio CompagnoniApril 11, 2024

Uncategorized

Exploring Snowflake’s VARIANT data type

In the realm of cloud-based data warehousing, managing both structured and semi-structured data can be…

Feruz KholovMarch 17, 2024

Uncategorized

Automating Your Workflow with GitHub Action: Enabling CI/CD

  Image by freepik   The latest practice in code development is strongly driven by…

Marco ScatassiMarch 15, 2024

Uncategorized

Understanding the Differences Between Several Data Roles

Almost all businesses are relying more and more on data-driven decision-making to stay competitive and…

Jordi KiesewetterMarch 15, 2024

Uncategorized

User Group: Women on Snowflake

Last week on March 11,  I participated in the first meeting of the Women on…

Aleksandra MolendaMarch 15, 2024

Uncategorized

Data Scaling Capabilities with Snowflake

Nowadays organizations deal with increasing amount of data volumes and data complexity. Fortunately, platforms such…

Jeroen SmitsMarch 15, 2024

Uncategorized

Mastering the Art of Negotiation: Essential Tools for Consultants

In the world of consulting, negotiation skills are indispensable. Whether you're discussing project terms with…

Gergana KaymakanovaMarch 15, 2024

Uncategorized

dbt_external_tables: integrate external data in your dbt project

    dbt is a transformation workflow tool that has revolutionized the way data teams work.…

Marco ScatassiMarch 8, 2024

Uncategorized

The Data Evolution: Embracing ELT for Agile Data Warehousing

1 ELT has been making its way into the data world these past years and…

Jordi KiesewetterMarch 8, 2024

Uncategorized

Unleashing the Power of JSON Manipulation in Snowflake: A Comprehensive Guide

In the realm of modern data management, Snowflake has risen to prominence as a cloud-based…

Marco PastoreMarch 8, 2024

Uncategorized

Revolutionizing Marketing Insights: Snowflake and Data Analysis

In the dynamic landscape of marketing, the ability to make informed decisions and stay ahead…

Aleksandra MolendaMarch 8, 2024

Uncategorized

“AI Giants Clash: Google’s Gemini vs. OpenAI’s Sora and the Future of Video Content Creation”

  The intensifying rivalry between OpenAI and Google, particularly focusing on Google's strategic rebranding of…

Feruz KholovMarch 4, 2024

Uncategorized

dbt : Pioneering the Analytics Engineering Role

Introduction In the rapidly evolving landscape of data analytics, the emergence of dbt (Data Build…

Oscar TrilloMarch 3, 2024

Uncategorized

Mastering the Art of Multitasking

In today's fast world, the ability to multitask is often seen as a valuable skill.…

Aleksandra MolendaMarch 1, 2024

Uncategorized

Elevate Your Business with Analytics Engineering

In the world of information overload, analytics engineering emerges as a guiding force, paving the…

Jordi KiesewetterMarch 1, 2024

Uncategorized

Empowering Analytics engineering with dbt

In the fast changing landscape of data analytics, the role of an analytics engineer has…

Jeroen SmitsMarch 1, 2024

Uncategorized

Bridging Blockchain and Cloud Data Warehousing: A Technical Deep Dive into Snowflake and Dune Integration

Image by freepik The groundbreaking partnership between Dune Analytics and Snowflake to launch Dune Datashare…

Marco PastoreMarch 1, 2024

Uncategorized

Fivetran and Airbyte: A Comparative Look

    In the landscape of data management, we are assisting at the shift from…

Marco ScatassiMarch 1, 2024

Uncategorized

Elevating Data-Driven Marketing: HubSpot Meets Snowflake

Navigating the complex landscape of data management in marketing can be daunting. Misleading data can…

Darko Monzio CompagnoniFebruary 29, 2024

Uncategorized

Deployment in DBT

In this blog post you will learn everything you need to start deploying your projects…

Guillermo IzquierdoFebruary 29, 2024

Uncategorized

Understanding GitHub Actions

GitHub Actions have revolutionized the way developers automate and streamline their workflow processes. This powerful…

Gerard Perelló MartínezFebruary 29, 2024

Uncategorized

Embracing Challenges: My Journey Through The First Project as an Intern

As a data engineer intern stepping into the realm of real-world projects, I embarked on…

Feruz KholovFebruary 26, 2024

Uncategorized

Snowflake Document AI: A Technical Overview

In the evolving landscape of data management and analysis, Snowflake has consistently set benchmarks with…

Oscar TrilloFebruary 24, 2024

Uncategorized

Strategies to deal with “incoming Missiles”

If you work on a project you can face unexpected challenges. These unexpected challenges always…

Jeroen SmitsFebruary 23, 2024

Uncategorized

git-filter-repo: Remove Sensitive Information from Git History with

    In modern software development, it's crucial to maintain data privacy and security. However,…

Marco ScatassiFebruary 23, 2024

Uncategorized

Deciphering Data Vaulting: Your Ultimate Guide

Following up on my post about Inmon and Kimball. This time we are talking about…

Jordi KiesewetterFebruary 23, 2024

Uncategorized

Simplifying Data Interaction: the Snowflake Connector in Python

In the era of data-driven decision-making, having seamless access to your data warehouse is crucial.…

Aleksandra MolendaFebruary 23, 2024

DataData LoaddbtFivetranGitgithubSnowflakeUncategorized

Leveraging Snowflake, dbt, and GitHub for Streamlined Data Operations

Given the importance of data nowdays, the ability to efficiently manage and process it can…

Gergana KaymakanovaFebruary 23, 2024

Uncategorized

Implementing Cloud Data Platforms in various Sectors in Economy

In the ever-evolving landscape of technology, the implementation of cloud data platforms has emerged as…

Feruz KholovFebruary 18, 2024

Uncategorized

Environment variables to Enhance Data Security in Python

In the dynamic world of software development, managing sensitive information such as API keys and…

Jeroen SmitsFebruary 16, 2024

Uncategorized

Let’s Dive into Data Analysis with Python and Streamlit: A Beginner’s Guide

In today's world, where data is king, being able to understand and interpret data is…

Jordi KiesewetterFebruary 16, 2024

Uncategorized

Data Streaming Management with the Snowflake Kafka Connector

    When talking about Big Data, we cannot escape from their very fundamental characterization…

Marco ScatassiFebruary 16, 2024

Uncategorized

Fast Fashion, Global Warming, and Can the Snowflake Be a Help?

In the modern world, we are starting to worry more and more about our planet.…

DominiqueFebruary 16, 2024

Uncategorized

Fivetran and HVR: Enhancing Data Integration and Analytics with Snowflake

In today's data-driven world, the importance of efficient data integration and analytics cannot be overstated.…

Gergana KaymakanovaFebruary 16, 2024

Uncategorized

Why Snowflake is so freaking cool

Image By vecstock If you're immersed in the field of data technology and haven't come…

Marco PastoreFebruary 2, 2024

Uncategorized

Unleashing AI Capabilities in Snowflake with Snowpark Container Services

As Snowflake ventures beyond its traditional BI and data warehousing roots to embrace the burgeoning…

Oscar TrilloFebruary 2, 2024

Uncategorized

When Uncertainty Meets Data

  Image by macrovector on Freepik   In our daily lives, we all experience how…

Marco ScatassiFebruary 2, 2024

Uncategorized

Why Do We Mask Data?

Data masking is a crucial aspect of data protection. WHY? Because many industries have to…

DominiqueFebruary 2, 2024

Uncategorized

Why to Use Clone in Snowflake?

In the wide world of data management, Snowflake's Clone feature appears as a powerful tool,…

Aleksandra MolendaFebruary 2, 2024

Uncategorized

The benefits of using a cloud database like Snowflake in healthcare

In this article, we will be discussing the benefits of using cloud databases in the…

Jordi KiesewetterFebruary 2, 2024

Uncategorized

Time Travel Made Easy with Snowflake

Image by vecstock on Freepik Snowflake's Time Travel feature is an incredibly useful tool that…

Marco PastoreJanuary 28, 2024

Uncategorized

Handling common errors of network policy in Snowflake account

In the ever-evolving landscape of cloud data platforms, Snowflake stands out as a powerful solution…

Feruz KholovJanuary 27, 2024

Uncategorized

Smart City: What, How and… Snowflake

  Image by pikisuperstar on Freepik   Smart City is a largely used term and…

Marco ScatassiJanuary 26, 2024

Uncategorized

The crucial role of data documentation

Have you ever looked at a part of your code or dataset and wondered what…

Jeroen SmitsJanuary 26, 2024

Uncategorized

Dive into Snowflake Cortex: A bridge to ML

As I promised in the last article, I would dedicate this article to dissect the…

Oscar TrilloJanuary 26, 2024

Uncategorized

Unpacking Data Warehousing Philosophies: Kimball vs. Inmon

When it comes to handling data, two big methods stand out: Kimball and Inmon. They…

Jordi KiesewetterJanuary 26, 2024

Uncategorized

New Features of Snowflake: Dynamic Tables and Why to Use Them

Snowflake stores data in database tables that are logically structured with rows and columns. We…

Aleksandra MolendaJanuary 25, 2024

Uncategorized

How to write cleaner SQL queries

In the world of database management, crafting efficient and readable SQL queries is an essential…

DominiqueJanuary 19, 2024

Uncategorized

What makes Snowflake SQL outstanding from other DBMS

SQL, or Structured Query Language, is a cornerstone of data management, widely used for interacting…

Feruz KholovJanuary 19, 2024

Uncategorized

Data Mesh: what is it and why you cannot ignore it

Image by rawpixel.com on Freepik I am 100% sure that at least one time in…

Marco PastoreJanuary 19, 2024

Uncategorized

Beyond Warehousing: Snowflake’s Leap into AI and LLMs

For the last few years, Snowflake has position itself in the data world with its…

Oscar TrilloJanuary 19, 2024

Uncategorized

Breaking Down Data Silos Embracing Snowflake

Image by rawpixel.com on Freepik Breaking down data silos means removing the invisible barriers that…

Marco ScatassiJanuary 19, 2024

Uncategorized

Data in Particle Physics and How It Leads to Analytics Engineer

Curiosity has always been the characteristic of humans. Through the years, people have discovered smaller…

Aleksandra MolendaJanuary 19, 2024

Uncategorized

A Jump in the deep end: becoming an analytical engineer

It is exciting to choose a different career path and often accompanied by a lot…

Jeroen SmitsJanuary 19, 2024

dbt

dbt Analytics Engineering Certification

This blog post is my personal experience through achieving the dbt Analytics Engineering Certification, with…

Luca BalduzziDecember 30, 2023

Uncategorized

Transforming Digital Marketing: The Power of WordPress and Snowflake Integration

In the dynamic world of digital marketing, the integration of robust content management with advanced…

Darko Monzio CompagnoniDecember 8, 2023

Uncategorized

First Setup Streamlit App

At Nimbus Engineering, we are developing some of our applications for rapid data visualization using…

Gerard Perelló MartínezDecember 3, 2023

Uncategorized

How To Demo Snowflake

Here, at Nimbus Intelligence, we use Snowflake everyday — whether it be on its own…

Guillermo IzquierdoDecember 1, 2023

Uncategorized

Virtual Environments for your Python Projects

All experienced programmers recommend creating a virtual environments for every Python project. Let's see if…

Edoardo DraettaDecember 1, 2023

Uncategorized

Revolutionizing Email Marketing: Mailchimp Meets Snowflake

Welcome back to the exciting world where marketing meets data wizardry! Last week we talked…

Darko Monzio CompagnoniDecember 1, 2023

dbtJinjaSQLUncategorized

Macros in dbt

Macros in dbt are reusable pieces of code that ensure that the code is ‘DRY’…

Luca BalduzziDecember 1, 2023

dbtUncategorized

Documentation in dbt

Documenting a database structure is as vital as it is often overlooked. Many times the…

Chris VerweijNovember 24, 2023

Uncategorized

Incremental Models in dbt

As your organization grows, so will your tables. A full rebuild of your models might…

Edoardo DraettaNovember 24, 2023

Jinja

Jinja Basics II

This blog is the continuation of my previous one that you can find here. As…

Luca BalduzziNovember 24, 2023

Jinja

Jinja Basics I

Jinja is more than just a city in Uganda or a Japanese temple: it’s a…

Luca BalduzziNovember 20, 2023

Uncategorized

ABC of DBT tests

What is a test in DBT? Tests are assertions that you make about your models…

Guillermo IzquierdoNovember 19, 2023

Uncategorized

Snowflake VSCode Integration

In Nimbus we are very familiar with Snowflake; in fact, we consider it to be…

Gerard Perelló MartínezNovember 17, 2023

Data LoadJSONSnowflakeSQLUnstructured Data

Killing JSON: Using Flatten to Load JSON Data

Welcome back to Killing JSON, the series in which I channel my frustration with loading…

Edoardo DraettaNovember 17, 2023

Uncategorized

Beyond dbt fundamentals: The analytics engineering mock project

Having all completed the dbt fundamentals course, the next goal in the Nimbus Academy is…

Chris VerweijNovember 16, 2023

Uncategorized

Data-Driven Healthcare Transformation: How dbt helps

Photo by Piron Guillaume on Unsplash Today, data is changing how healthcare works. It's more…

Darko Monzio CompagnoniNovember 16, 2023

Uncategorized

Environments in DBT with Snowflake

When you are developing a DBT project, it's usual to create, at least, two critical…

Gerard Perelló MartínezNovember 10, 2023

Uncategorized

Snowday Security Highlights

Snowday was full of surprises. I was ready to see loads of exciting new features.…

Guillermo IzquierdoNovember 10, 2023

JSONSnowflakeUnstructured Data

Killing JSON: The Flatten Function

Welcome to Killing JSON, a series in which I channel my frustration with loading data…

Edoardo DraettaNovember 10, 2023

Uncategorized

Understanding modularity

Last week we talked about DBT models. It's time to dive deeper in understanding modularity.…

Darko Monzio CompagnoniNovember 10, 2023

DatabaseSnowdaySnowflake

Snowflake Hybrid Tables

Hybrid Tables in Snowflake are a new type of table that can support transactional workloads.…

Luca BalduzziNovember 10, 2023

dbt

Extending the data workflow with dbt

Having passed our SnowPro Core exam last week, we have now started on extending and…

Chris VerweijNovember 3, 2023

SnowdaySnowflake

My First Snowday: Notebooks, ML, and AI

Snowflake hopes to ride the AI wave AI is booming, and Snowflake doesn’t want to…

Edoardo DraettaNovember 3, 2023

Uncategorized

Automating Data Ingestion: A Guide to Snowpipe in Snowflake

Snowpipe is a serverless service offered by Snowflake that facilitates the seamless and real-time ingestion…

Gerard Perelló MartínezNovember 3, 2023

DataSecuritySnowflake

Snowflake Data Sensitivity & Access Visibility

Snowflake’s features and capabilities enable you to manage, protect, and share your data securely and…

Luca BalduzziNovember 3, 2023

Uncategorized

The role of Analytics Engineers in Modern Data Teams

In the dynamic world of data management and analytics, the landscape is constantly evolving. Traditional…

Darko Monzio CompagnoniNovember 3, 2023

Uncategorized

DBT models

In this blog post I will explain what DBT models are and how to use…

Guillermo IzquierdoOctober 31, 2023

Uncategorized

Network Policies in Snowflake

In Snowflake, network policies enable the restriction of Snowflake account access by specifying blocked and…

Edoardo DraettaOctober 30, 2023

Uncategorized

Data Encryption and Authentication

This is part one of a two part series overviewing Snowflake's security measures and tools.…

Guillermo IzquierdoOctober 27, 2023

SecuritySnowflake

Snowflake Data Access Policies

Snowflake’s features and capabilities enable you to manage, protect, and share your data securely and…

Luca BalduzziOctober 26, 2023

Uncategorized

Understanding Snowflake Sessions

Snowflake, a cloud-based data warehousing platform, facilitates handling and analyzing large datasets with ease. One…

Darko Monzio CompagnoniOctober 25, 2023

Uncategorized

Snowflake Architecture

In this post I will introduce you to the main components of the Snowflake Architecture.…

Guillermo IzquierdoOctober 20, 2023

Uncategorized

Snowflake Internal Stages: Unlocking Efficient Data Management

Navigating through the realm of data management in Snowflake unveils a key feature known as…

Gerard Perelló MartínezOctober 20, 2023

Uncategorized

Data Clustering in Snowflake

Data clustering in Snowflake, a process of organizing related rows within micropartitions, is pivotal for…

Edoardo DraettaOctober 20, 2023

CacheSnowflake

Snowflake Caching

Snowflake is a cloud data platform that provides fast and scalable data warehousing, data sharing,…

Luca BalduzziOctober 20, 2023

Uncategorized

Using a Snowflake Reader Account for Easy Data Sharing

In today's digital world, sharing and accessing data easily is crucial for business success. Snowflake…

Darko Monzio CompagnoniOctober 20, 2023

Uncategorized

Time travel in Snowflake

Every database administrator has at some point in their life had the dreaded call: Something…

Chris VerweijOctober 19, 2023

DataData LoadSnowflakeSQL

Semi-structured data in Snowflake

The easiest form of data to load into a SQL database is fully structured. Comma…

Chris VerweijOctober 13, 2023

Uncategorized

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

Background photo by Vienna Reyes on Unsplash Fan tokens have opened up exciting opportunities for…

Darko Monzio CompagnoniOctober 13, 2023

Uncategorized

Streamlit Applications: A Guide to Reactivity and Statefulness

In the latest project at Nimbus Academy, trainees explored the dynamic realm of Streamlit—a versatile…

Edoardo DraettaOctober 13, 2023

GitgithubPython

Python Best Practices

Python is a popular and versatile programming language that can be used for various applications.…

Luca BalduzziOctober 13, 2023

Uncategorized

Git Basic Commands II – Connection with GitHub

Previously, we navigated through some basic Git commands which you can revisit here. This time,…

Gerard Perelló MartínezOctober 7, 2023

Uncategorized

Handle categorical data for EDA (II)

In the last post we looked at some useful methods for getting an overview of…

Guillermo IzquierdoOctober 6, 2023

Uncategorized

Understanding Boolean Indexing in Pandas

Pandas, the popular Python library for data manipulation and analysis, offers a plethora of techniques…

Edoardo DraettaOctober 6, 2023

Git

Git Basic Commands

In this blog post, I will continue to explain some of Git basic commands, which…

Luca BalduzziOctober 6, 2023

Uncategorized

Collaboration in practice

After our first month of getting up to speed in Snowflake and SQL, the first…

Chris VerweijOctober 6, 2023

Uncategorized

Prevent your data lake from becoming a data swamp

Imagine a serene, expansive lake, its waters clear and full of diverse life. The kind…

Darko Monzio CompagnoniOctober 6, 2023

Uncategorized

EDA with pandas: very first steps

This brief introduction will guide you through the very first steps of using pandas for…

Guillermo IzquierdoSeptember 29, 2023

Uncategorized

Understanding Data Denormalization

Welcome to the continuation of our exploration of database optimization techniques. If you haven't already,…

Gerard Perelló MartínezSeptember 29, 2023

Uncategorized

Understanding data normalization: the Burger Bliss restaurant

Photo by Mike on Unsplash To begin with, what is data normalization? Simply put, it's…

Darko Monzio CompagnoniSeptember 29, 2023

Git

Git Introduction

This short Git tutorial will explain the main ideas of this amazing software that helps…

Luca BalduzziSeptember 29, 2023

Uncategorized

The Nimbus traineeship: One month in

It’s been four weeks since we kicked off our Nimbus traineeship as the second cohort.…

Chris VerweijSeptember 29, 2023

Uncategorized

Why use a Non-Relational Database?

Non-relational databases are databases that don't store data in a tabular schema. When data structure…

Edoardo DraettaSeptember 29, 2023

Uncategorized

Build your data pipeline in Snowflake using dynamic tables

Create an effective data pipeline by following this quick and easy introduction to Dynamic Tables.…

Guillermo IzquierdoSeptember 22, 2023

Uncategorized

Warehouse elasticity – Scaling up and scaling out

As my colleague Gerard mentioned in his blog on features of Snowflake, warehouse elasticity is…

Chris VerweijSeptember 22, 2023

Uncategorized

Query Boost: Query Acceleration Service in Snowflake

Query too slow? Snowflake can help. Snowflake comes with a set of in-built tools to…

Edoardo DraettaSeptember 22, 2023

Uncategorized

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

Since I started my Analytics Engineer traineeship at Nimbus Intelligence, I noticed that this emerging…

Darko Monzio CompagnoniSeptember 22, 2023

DatabaseDatabase Creation

Entity Relation Diagram

Entity Relation Diagram is part of the data modelling process ant it's the representation of…

Luca BalduzziSeptember 22, 2023

Uncategorized

Differences and Features of OLTP and OLAP in Database Processing

Welcome to our exploration of database processing techniques. In this post, we delve into the…

Gerard Perelló MartínezSeptember 22, 2023

Uncategorized

How tasks make your life easier

Looking to automate your workflow? Let me introduce you to the beautiful world of tasks.…

Guillermo IzquierdoSeptember 15, 2023

AcademySnowflake

Basic Access Control Privileges in Snowflake

""Why can't I see this table...?"" — Frustrated Snowflake User A key feature of the…

Edoardo DraettaSeptember 15, 2023

Snowflake

Snowflake Resource Monitor

The Snowflake Resource Monitor can be used to control warehouse credit usage, avoiding unexpected behaviors.…

Luca BalduzziSeptember 15, 2023

Uncategorized

Features of Snowflake compared to other platforms.

Data is one of the most powerful tools available right now. But is your company…

Gerard Perelló MartínezSeptember 15, 2023

Uncategorized

Can a Marketer become an Analytics Engineer?

Switching careers is never easy. It involves stepping out of one's comfort zone, confronting uncertainties,…

Darko Monzio CompagnoniSeptember 15, 2023

Uncategorized

Van laboratoriumanalist naar analytics engineer

Tot vorige maand werkte ik in als laboratoriumanalist moleculaire biologie. Hier hield ik mij bezig…

Chris VerweijSeptember 15, 2023

SnowflakeSnowPro core certification

SnowPro Core Certification: it’s time to go old-school.

In this blog, I will give you my own experience and my studying plan in…

Sofia PieriniJune 13, 2023

Python

GoL 3: Finishing the Game of Life

Finally, this is the blog series ending. By the end of this blog, we will…

Eloi SanchezJune 2, 2023

AcademydbtFivetranSnowflakeSQL

Modern Data Stack in One Day

At Nimbus Intelligence Academy we are trained to build a modern data stack including data…

Kris WinnubstMay 30, 2023

Data LoaddbtgithubSnowflake

Unleashing YouTube Insights: Powering HypeHouse’s Market Analysis

In the fast-paced world of public relations, staying ahead of the curve is crucial. For…

Sofia PieriniMay 26, 2023

DataData LoadData VisualizationSnowflakeSQL

Column Level Security

Snowflake, as a modern cloud database, has the functionality to mask sensitive data for unauthorized…

Mario CaliseMay 22, 2023

Python

GoL 2: Creating a Game of Life Colony in Python

In the previous blog we created the Cell object that can basically be able to…

Eloi SanchezMay 22, 2023

Uncategorized

System Functions in Snowflake

System Functions in Snowflake gives you the option to check your Snowflake instance and have…

Can HobekMay 21, 2023

Uncategorized

How/When to Create Listings

Snowflake has a lot of special features that make itself unique. In this blog I…

Can HobekMay 21, 2023

AirbyteSnowflake

Snowflake setup in Airbyte

Fivetran and Airbyte are two tools that extract, load and possibly transform (the ELT process)…

Kris WinnubstMay 19, 2023

FivetranSnowflake

Snowflake setup in Fivetran

Fivetran and Airbyte are two tools that extract, load and possibly transform (the ELT process)…

Kris WinnubstMay 19, 2023

DatabaseSnowflake

Vector Databases from 1000 Meters

In the ever-expanding realm of data, a significant portion remains unstructured, posing challenges for traditional…

Sebastian WiesnerMay 19, 2023

AcademyDataDatabaseSnowflakeSQLUncategorized

Conversion Functions- Part1

Conversion functions allow a data item of one datatype supported by Snowflake to be transformed…

Niccolo RacioppiMay 18, 2023

DataDatabaseSnowflakeSQLUncategorized

INFORMATION SCHEMA

The Information Schema is a tool full of potential that allows us to keep track…

Niccolo RacioppiMay 18, 2023

DataFrosty fridaySnowflakeSQL

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

Do you want to keep secure your data? Then, let's dedicate this new post of…

Sofia PieriniMay 18, 2023

DataFrosty fridaySnowflakeSQL

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

Do you want to keep secure your data? Then, let's dedicate this new post of…

Sofia PieriniMay 18, 2023

Data LoadFrosty fridaySnowflake

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

Let us add something new in What's under the Snowflake(s)? In this post, we focus…

Sofia PieriniMay 18, 2023

DataData LoadDatabasePipesSnowflakeSQL

Snowflake’s INFER SCHEMA

In this blog, we are going to discuss how Snowflake allows to easily interpret semi-structured data…

Mario CaliseMay 17, 2023

Python

GoL 1: Understanding Pygame

As I explained at the beginning of the previous blog, I am now creating a…

Eloi SanchezMay 16, 2023

Snowflake

Create Named Stages using Snowsight

''With this release, we are pleased to announce the preview of creating and editing named…

Dimitris LampriadisMay 14, 2023

Snowflake

Snowflake’s SPLIT_TO_TABLE function

In the following article, we will explore how to use Snowflake's SPLIT_TO_TABLE table function to…

Dimitris LampriadisMay 14, 2023

Frosty fridayPythonSnowsightUncategorized

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

Let us add something new in What's under the Snowflake(s)? In this post, we focus…

Sofia PieriniMay 14, 2023

DataDatabase

The Hype About GPT as a Helper Tool in Software

GPT, or Generative Pre-trained Transformer, is a deep learning model that can generate natural language…

Sebastian WiesnerMay 12, 2023

Data LoadDatabase

Data Integration Battle: Fivetran vs. Airbyte

Data integration platforms like Fivetran and Airbyte are critical for businesses that rely on data…

Sebastian WiesnerMay 12, 2023

Python

GoL 0: Poetry for environment management in Python

This will be both a continuation and a starting post. It will be the beginning…

Eloi SanchezMay 9, 2023

PythonUncategorized

Challenge: The Game of Life in Python

Hey there! I am back this week with another Python challenge. This was actually a…

Eloi SanchezMay 5, 2023

dbt

Custom generic test in dbt

Writing a custom generic test in dbt allows you to test your data on your…

Kris WinnubstMay 5, 2023

Uncategorized

The New Tab Feature on Snowflake

The latest Snowflake release enables the use of more than one worksheet in separate tabs.…

Can HobekMay 1, 2023

Uncategorized

First Step to Certifications: Snowflake SnowPro Core

Last week we had a chance to try ourselves on Snwoflake’s first exam that is…

Can HobekMay 1, 2023

dbt

Starting with dbt Cloud

Data Build Tool is a tool for managing and transforming your data, creating scheduled jobs,…

Dimitris LampriadisApril 28, 2023

Snowflake

REGEX in Snowflake

It is possible to match strings with regular expression (also called REGEX) in Snowflake. I…

Kris WinnubstApril 28, 2023

dbt

dbt and Machine Learning: A Dynamic Duo for Data-Driven Insights

In today's data-driven world, businesses are increasingly turning to machine learning models to gain insights…

Sebastian WiesnerApril 28, 2023

SnowflakeUncategorized

How to connect VS Code to Snowflake

During the last years, I have been using Visual Studio Code for everything. Therefore, now…

Eloi SanchezApril 26, 2023

DataData LoadDatabasePipesSnowflakeSQL

Snowflake Snowpipe

In the previous chapters of this series, we have seen how to load through staging…

Mario CaliseApril 25, 2023

DataData Visualization

Visualizing Data

Effective data visualization is a critical skill for any Data Analyst and Analytics Engineer. Data…

Dimitris LampriadisApril 21, 2023

Data LoadSnowflake

Data validation in Snowflake

As a follow up of my previous blog on SQL injection into Snowflake, I made…

Kris WinnubstApril 21, 2023

DataPython

What are Moving Averages?

If you have been in the data environment for some time you will have probably…

Eloi SanchezApril 21, 2023

DataSnowflakeSQL

Optimizing SQL Queries in Snowflake

In this blog, we'll discuss practical tips and tricks to optimize SQL queries in Snowflake…

Sebastian WiesnerApril 20, 2023

SQL

Snowflake SQL Injection

SQL Injection has the potential to ruin your database. If you have heard of the…

Kris WinnubstApril 17, 2023

Data LoadSnowflake

From JSON to XML: A Deep Dive into Snowflakes File Types

Snowflake is a cloud-based data warehousing solution that has become increasingly popular in recent years…

Sebastian WiesnerApril 14, 2023

SQL

Challenge: Integrals in SQL?

Last week I brought you a challenge on how to make derivatives in SQL. Evidently,…

Eloi SanchezApril 14, 2023

SQL

SQL Case Statements

We have already seen how nesting aggregated functions and SQL join types work in the…

Dimitris LampriadisApril 8, 2023

Snowflake

Automate external stage loading

This week I set-up automate external stage loading. I did this for our first mock…

Kris WinnubstApril 7, 2023

DataData LoadDatabaseSnowflakeSQLUncategorized

Two ways to populate a table with stage data

MATCH_BY_COLUMN_NAME vs Variant data type I found myself having to insert files from my device…

Niccolo RacioppiApril 7, 2023

AcademySnowflake

Snowflake SnowPro: How to probably Ace it

As an Analytics Engineer trainee, I recently took the Snowflake Snowpro Core Certification exam. Before…

Sebastian WiesnerApril 7, 2023

AcademyDataDatabaseSnowflake

How to become a SnowPro

I took the SnowPro Core Certification exam. SnowPro Core certification badge I will make some…

Niccolo RacioppiApril 7, 2023

SQL

Challenge: Derivatives in SQL?

Today I bring you a challenge! Just a fun little exercise to train your SQL…

Eloi SanchezApril 7, 2023

DataDatabaseSnowflake

Snowflake’s Security Measures against Cyber Threats

The Barrier Between Your Data and Cyber Threats Snowflake's data platform has gained popularity for…

Sebastian WiesnerApril 7, 2023

AcademySnowflake

Tips for the SnowPro Core Certification Exam

If you are currently in the data field, or you are considering going into it,…

Eloi SanchezApril 7, 2023

AcademySnowflake

SnowPro Core Certification: My First Attempt

Yesterday was the big day. My first attempt to become a certified SnowPro Core Expert…

Dimitris LampriadisApril 3, 2023

AcademySnowflake

SnowPro Core: how to smash it in 3 days

Intense week at the Nimbus Academy.Last Monday we were notified that by Friday we would…

Mario CaliseApril 2, 2023

QuizSnowflake

Snowflake Numbers Quiz

Last Friday was our first attempt at the SnowPro Core certification exam, and I passed!…

Kris WinnubstApril 2, 2023

SQL

Intro to SQL Joins: Understanding Join Types

SQL Joins are a fundamental concept in SQL programming, used to combine data from two…

Dimitris LampriadisMarch 23, 2023

Uncategorized

Snowflake Dashboards

As we know on Snowflake our warehouses can execute one operation per time per user.…

Can HobekMarch 23, 2023

Frosty fridayPythonSnowflake

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

S4. What's under the Snowflake(s)? Week 5 - Basic Are you ready for a new…

Sofia PieriniMarch 23, 2023

DataData GenerationData LoadMock DataSQL

Mockaroo: fake realistic data

In writing previous blogs, I found myself having to search for old tables in which…

Niccolo RacioppiMarch 23, 2023

DatabaseSnowflake

Keeping Your Data Safe: Blockchain vs. Snowflake

Businesses today are highly concerned with safeguarding their data. While Snowflake has established itself as…

Sebastian WiesnerMarch 23, 2023

Python

Better plots with Streamlit

We have already seen how to get Snowflake to work with Python and how to…

Eloi SanchezMarch 23, 2023

Data LoadDatabaseSnowflakeSQL

Snowflake File Formats

In the previous chapters of this series, we have seen how to load through staging…

Mario CaliseMarch 23, 2023

Frosty fridaySnowflakeSQL

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

What's under the Snowflake(s)? - Week 23 - Basic Are you curious about SnowSQL? Then,…

Sofia PieriniMarch 23, 2023

Snowflake

Data Lake or Data Warehouse? When to Use Which

Βusinesses that are working with data must determine how to store, manage, and analyze them…

Dimitris LampriadisMarch 22, 2023

Uncategorized

Stored Procedures

Stored Procedures allow us to write functions inside our SQL code. In Snowflake you can…

Can HobekMarch 22, 2023

DatabaseSnowflakeSnowsight

Chart Visualizations in Snowsight

Along with the interactive results, Snowsight also offers a Chart Visualization service.The section dedicated to…

Niccolo RacioppiMarch 22, 2023

Uncategorized

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

S2. What's under the Snowflake(s)? Week 31 - Basic Let us add something new in…

Sofia PieriniMarch 22, 2023

Snowflake

Streamline Workflows with Snowflake-ServiceNow Integration

In today's data-driven world, businesses are constantly seeking new approaches to access and analyze data.…

Sebastian WiesnerMarch 22, 2023

DataData GenerationDatabaseSnowflake

Unload data from your Snowflake account

We have previously seen how to load data from foreign sources to your Snowflake account…

Mario CaliseMarch 22, 2023

Python

Python Ids and the difference between == and is

As we all know, in Python, there are usually multiple ways of getting to the…

Eloi SanchezMarch 22, 2023

Frosty fridaySnowflakeSQL

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

S1. What's under the Snowflake(s)? Week 38 - Basic Let's start the first episode of…

Sofia PieriniMarch 22, 2023

DatabaseSnowflake

Interactive results in Snowsight

When we run a query we would like to have a quick overview of the…

Niccolo RacioppiMarch 22, 2023

Uncategorized

User-Defined Functions

User-Defined Functions allow us to write functions inside our SQL code. In Snowflake you can…

Can HobekMarch 21, 2023

AcademyData LoadDatabaseSnowflake

Load data on your Snowflake account

In the previous chapter we have talked about Snowflake stages. It is now clear that…

Mario CaliseMarch 21, 2023

Snowflake

Snowflake’s Data Marketplace: A Game Changer for Data Monetization

As we have discussed in previous posts, Snowflake is a data-cloud platform that provides professionals…

Dimitris LampriadisMarch 21, 2023

Data LoadDatabaseSnowflake

Snowflake Stages: a brief explanation

Data storage is a critical component of any database system. When dealing with large amounts…

Mario CaliseMarch 21, 2023

Snowflake

Blockchain vs. Snowflake: Disrupting the Cloud?

As a centralised cloud data platform, Snowflake has gained valuable market share in recent years.…

Sebastian WiesnerMarch 21, 2023

DatabasePythonSnowflakeSQL

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

Database, table, and virtual warehouse are basic Snowflake objects required for most Snowflake activities. Setting…

Sofia PieriniMarch 21, 2023

Python

Mutable and Immutable objects in Python

We have all heard about mutable and immutable objects when learning about Python, but what…

Eloi SanchezMarch 21, 2023

Frosty fridayPythonSnowflakeSQL

What’s under the Snowflake(s)?

Have you ever wondered what is under the snow? What are the snowflakes hiding? Have…

Sofia PieriniMarch 21, 2023

AcademyDatabaseSnowflake

Saving time: shortcuts in Snowflake!

Often we are faced with time constraints or impending deliveries, it would be handy to…

Niccolo RacioppiMarch 20, 2023

Uncategorized

Snowflake Pricing Control Features

Snowflake with his advanced storage features, has the ability to store your data in the…

Can HobekMarch 20, 2023

Snowflake

SnowSQL: What is it? How to use it.

Snowflake is one of the best cloud-based data warehousing platforms. It optimizes almost the entire…

Dimitris LampriadisMarch 20, 2023

PythonSQL

Wildcard searches in SQL and Python

Last week I found myself wondering about wildcard searches in SQL and Python. And to…

Kris WinnubstMarch 20, 2023

DatabaseSnowflake

Snowflake: Melting our Environment?

In the digital age, we generate vast amounts of data that need to be stored…

Sebastian WiesnerMarch 20, 2023

PythonSnowflake

Using Snowflake Data with Pandas

Today we are going to see how to use our Snowflake Data with Pandas in…

Eloi SanchezMarch 20, 2023

SQL

Nesting Aggregated functions

This blogpost marks the beginning of a long and very exciting journey in the world…

Dimitris LampriadisMarch 20, 2023

Snowflake

Revolutionize Data Science with Snowpark

In today's era, the field of data science has gained immense significance, with the widespread…

Sebastian WiesnerMarch 20, 2023

DatabaseGoogle ColabPythonSnowflakeUncategorized

Python-Snowflake-API: first Nimbus class’s project!

Snowflake, Python and APIs: working to create your database! Let's wrap this week up! The…

Sofia PieriniMarch 18, 2023

AcademyDatabaseSnowflakeSQL

Zero-Copy Cloning: Snowflake’s unique feature

When we talk about Business Intelligence we immediately think of the strategies connected to the…

Mario CaliseMarch 17, 2023

DatabaseSnowflake

OLAP and OLTP systems: advantages and features

  If we examine how data analysis methods have evolved over the years, we note…

Mario CaliseMarch 17, 2023

Google ColabPython

How to import Python scripts in a Google Colab notebook

Google Colab is probably one of the easiest tools to start working with python codes:…

Mario CaliseMarch 17, 2023

Uncategorized

How To Check Your Usage History in Snowflake

One of the biggest difference of Snowflake from the other types of cloud-based data warehousing…

Can HobekMarch 17, 2023

PythonSnowflake

5 best practices for documenting your Python-Snowflake project

In every profession, people tend to focus most of their energy and resources on the…

Dimitris LampriadisMarch 17, 2023

Snowflake

Grant privileges in Snowflake

Why can't we grant privileges to a Snowflake object AND its children? In the first…

Kris WinnubstMarch 17, 2023

SnowflakeSQLUncategorized

DROP,TRUNCATE and DELETE

Three ways to delete your data. We compare three commands on different characteristics such as:…

Niccolo RacioppiMarch 17, 2023

AcademyDatabaseSnowflake

Micro-partitions and Clustering:

Let's talk about partitions! The desire to partition large amounts of data organized in large…

Niccolo RacioppiMarch 17, 2023

PythonSnowflake

Using Snowflake Data in Python

Let's say that we have a database stored in Snowflake with some data that we…

Eloi SanchezMarch 10, 2023

DatabaseSQL

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

It is fair to state that, nowadays, we often happen to hear that data is…

Mario CaliseMarch 1, 2023

SQL

Nesting Group By and Partitioning

During my formation on Snowflake at Nimbus Intelligence our professor showed us a query that…

Eloi SanchezMarch 1, 2023

Uncategorized

Snowflake’s Table and View Types

Can Höbek26-02-2023Snowflake's type of tables and views In Snowflake there are several options of table…

Can HobekMarch 1, 2023

Snowflake

Snowflake MAX_BY function

Ever wonder how to easily look-up a corresponding column of a maximum value in Snowflake?…

Kris WinnubstMarch 1, 2023

AcademySnowflakeUncategorized

Can a Philosopher become an Analytics Engineer?

Analytics Engineers are cloud-based data specialists, new members in data team, whilst philosophers often have…

Sofia PieriniMarch 1, 2023

Snowflake

Semi-Structured Data with Snowflake’s Variant Data Type

Snowflake makes handling Semi-Structured Data simple. Handling both structured and semi-structured data in a modern…

Sebastian WiesnerMarch 1, 2023