Skip to main content

Filter

KafkaSnowflake

⚡ Fraud Detection in 3 Seconds with Snowpark + Kafka: the Story of a Bank that Didn’t Let a Single Cent Slip Through

02:17 a.m. — A €4 999 withdrawal request pops up at an ATM in a country the cardholder…
Jose LealJose LealMay 16, 2025
Data

🔍 Cost-Ops in Snowflake: 7 Practices That Slashed Our Bill by 30 %

While working on an internal project—Nimbus Intelligence Data Warehouse—I was mainly responsible for cost-optimization settings…
Jose LealJose LealApril 30, 2025
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 KholovFeruz 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 ScatassiMarco ScatassiMarch 15, 2024
Uncategorized

User Group: Women on Snowflake

Last week on March 11,  I participated in the first meeting of the Women on…
Aleksandra MolendaAleksandra MolendaMarch 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 KaymakanovaGergana 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 ScatassiMarco ScatassiMarch 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 PastoreMarco 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 MolendaAleksandra 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 KholovFeruz 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 TrilloOscar 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 MolendaAleksandra MolendaMarch 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 PastoreMarco PastoreMarch 1, 2024
Uncategorized

Fivetran and Airbyte: A Comparative Look

    In the landscape of data management, we are assisting at the shift from…
Marco ScatassiMarco ScatassiMarch 1, 2024
Uncategorized

Deployment in DBT

In this blog post you will learn everything you need to start deploying your projects…
Guillermo IzquierdoGuillermo IzquierdoFebruary 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 KholovFeruz 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 TrilloOscar TrilloFebruary 24, 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 ScatassiMarco ScatassiFebruary 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 MolendaAleksandra 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 KaymakanovaGergana 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 KholovFeruz KholovFebruary 18, 2024
Uncategorized

Data Streaming Management with the Snowflake Kafka Connector

    When talking about Big Data, we cannot escape from their very fundamental characterization…
Marco ScatassiMarco 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.…
Aleksandra MolendaAleksandra MolendaFebruary 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 KaymakanovaGergana 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 PastoreMarco 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 TrilloOscar TrilloFebruary 2, 2024
Uncategorized

When Uncertainty Meets Data

  Image by macrovector on Freepik   In our daily lives, we all experience how…
Marco ScatassiMarco ScatassiFebruary 2, 2024
Uncategorized

Why Do We Mask Data?

Data masking is a crucial aspect of data protection. WHY? Because many industries have to…
Aleksandra MolendaAleksandra MolendaFebruary 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 MolendaAleksandra MolendaFebruary 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 PastoreMarco 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 KholovFeruz KholovJanuary 27, 2024
Uncategorized

Smart City: What, How and… Snowflake

  Image by pikisuperstar on Freepik   Smart City is a largely used term and…
Marco ScatassiMarco ScatassiJanuary 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 TrilloOscar TrilloJanuary 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 MolendaAleksandra 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…
Aleksandra MolendaAleksandra MolendaJanuary 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 KholovFeruz 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 PastoreMarco 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 TrilloOscar 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 ScatassiMarco 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 MolendaAleksandra MolendaJanuary 19, 2024
dbt

dbt Analytics Engineering Certification

This blog post is my personal experience through achieving the dbt Analytics Engineering Certification, with…
Luca BalduzziLuca BalduzziDecember 30, 2023
Uncategorized

First Setup Streamlit App

At Nimbus Engineering, we are developing some of our applications for rapid data visualization using…
Gerard Perelló MartínezGerard 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 IzquierdoGuillermo 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 DraettaEdoardo DraettaDecember 1, 2023
dbtJinjaSQLUncategorized

Macros in dbt

Macros in dbt are reusable pieces of code that ensure that the code is ‘DRY’…
Luca BalduzziLuca BalduzziDecember 1, 2023
Uncategorized

Incremental Models in dbt

As your organization grows, so will your tables. A full rebuild of your models might…
Edoardo DraettaEdoardo DraettaNovember 24, 2023
Jinja

Jinja Basics II

This blog is the continuation of my previous one that you can find here. As…
Luca BalduzziLuca BalduzziNovember 24, 2023
Jinja

Jinja Basics I

Jinja is more than just a city in Uganda or a Japanese temple: it’s a…
Luca BalduzziLuca BalduzziNovember 20, 2023
Uncategorized

ABC of DBT tests

What is a test in DBT? Tests are assertions that you make about your models…
Guillermo IzquierdoGuillermo 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ínezGerard 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 DraettaEdoardo DraettaNovember 17, 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ínezGerard 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 IzquierdoGuillermo 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 DraettaEdoardo DraettaNovember 10, 2023
DatabaseSnowdaySnowflake

Snowflake Hybrid Tables

Hybrid Tables in Snowflake are a new type of table that can support transactional workloads.…
Luca BalduzziLuca BalduzziNovember 10, 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 DraettaEdoardo 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ínezGerard 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 BalduzziLuca BalduzziNovember 3, 2023
Uncategorized

DBT models

In this blog post I will explain what DBT models are and how to use…
Guillermo IzquierdoGuillermo IzquierdoOctober 31, 2023
Uncategorized

Network Policies in Snowflake

In Snowflake, network policies enable the restriction of Snowflake account access by specifying blocked and…
Edoardo DraettaEdoardo 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 IzquierdoGuillermo 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 BalduzziLuca BalduzziOctober 26, 2023
Uncategorized

Snowflake Architecture

In this post I will introduce you to the main components of the Snowflake Architecture.…
Guillermo IzquierdoGuillermo 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ínezGerard 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 DraettaEdoardo DraettaOctober 20, 2023
CacheSnowflake

Snowflake Caching

Snowflake is a cloud data platform that provides fast and scalable data warehousing, data sharing,…
Luca BalduzziLuca BalduzziOctober 20, 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 DraettaEdoardo DraettaOctober 13, 2023
GitgithubPython

Python Best Practices

Python is a popular and versatile programming language that can be used for various applications.…
Luca BalduzziLuca 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ínezGerard 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 IzquierdoGuillermo 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 DraettaEdoardo DraettaOctober 6, 2023
Git

Git Basic Commands

In this blog post, I will continue to explain some of Git basic commands, which…
Luca BalduzziLuca BalduzziOctober 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 IzquierdoGuillermo 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ínezGerard Perelló MartínezSeptember 29, 2023
Git

Git Introduction

This short Git tutorial will explain the main ideas of this amazing software that helps…
Luca BalduzziLuca BalduzziSeptember 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 DraettaEdoardo 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 IzquierdoGuillermo IzquierdoSeptember 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 DraettaEdoardo DraettaSeptember 22, 2023
DatabaseDatabase Creation

Entity Relation Diagram

Entity Relation Diagram is part of the data modelling process ant it's the representation of…
Luca BalduzziLuca 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ínezGerard 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 IzquierdoGuillermo 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 DraettaEdoardo DraettaSeptember 15, 2023
Snowflake

Snowflake Resource Monitor

The Snowflake Resource Monitor can be used to control warehouse credit usage, avoiding unexpected behaviors.…
Luca BalduzziLuca 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ínezGerard Perelló MartínezSeptember 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 PieriniSofia PieriniJune 13, 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 PieriniSofia 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 CaliseMario CaliseMay 22, 2023
Uncategorized

System Functions in Snowflake

System Functions in Snowflake gives you the option to check your Snowflake instance and have…
Can HobekCan 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 HobekCan HobekMay 21, 2023
AcademyDataDatabaseSnowflakeSQLUncategorized

Conversion Functions- Part1

Conversion functions allow a data item of one datatype supported by Snowflake to be transformed…
Niccolo RacioppiNiccolo RacioppiMay 18, 2023
DataDatabaseSnowflakeSQLUncategorized

INFORMATION SCHEMA

The Information Schema is a tool full of potential that allows us to keep track…
Niccolo RacioppiNiccolo 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 PieriniSofia 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 PieriniSofia 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 PieriniSofia 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 CaliseMario CaliseMay 17, 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 PieriniSofia PieriniMay 14, 2023
Uncategorized

The New Tab Feature on Snowflake

The latest Snowflake release enables the use of more than one worksheet in separate tabs.…
Can HobekCan 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 HobekCan HobekMay 1, 2023
DataData LoadDatabasePipesSnowflakeSQL

Snowflake Snowpipe

In the previous chapters of this series, we have seen how to load through staging…
Mario CaliseMario CaliseApril 25, 2023
Snowflake

Automate external stage loading

This week I set-up automate external stage loading. I did this for our first mock…
Can HobekCan HobekApril 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 RacioppiNiccolo RacioppiApril 7, 2023
AcademyDataDatabaseSnowflake

How to become a SnowPro

I took the SnowPro Core Certification exam. SnowPro Core certification badge I will make some…
Niccolo RacioppiNiccolo RacioppiApril 7, 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 CaliseMario CaliseApril 2, 2023
QuizSnowflake

Snowflake Numbers Quiz

Last Friday was our first attempt at the SnowPro Core certification exam, and I passed!…
Can HobekCan HobekApril 2, 2023
Uncategorized

Snowflake Dashboards

As we know on Snowflake our warehouses can execute one operation per time per user.…
Can HobekCan 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 PieriniSofia 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 RacioppiNiccolo RacioppiMarch 23, 2023
Data LoadDatabaseSnowflakeSQL

Snowflake File Formats

In the previous chapters of this series, we have seen how to load through staging…
Mario CaliseMario 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 PieriniSofia PieriniMarch 23, 2023
Uncategorized

Stored Procedures

Stored Procedures allow us to write functions inside our SQL code. In Snowflake you can…
Can HobekCan 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 RacioppiNiccolo 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 PieriniSofia PieriniMarch 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 CaliseMario CaliseMarch 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 PieriniSofia PieriniMarch 22, 2023
DatabaseSnowflake

Interactive results in Snowsight

When we run a query we would like to have a quick overview of the…
Niccolo RacioppiNiccolo RacioppiMarch 22, 2023
Uncategorized

User-Defined Functions

User-Defined Functions allow us to write functions inside our SQL code. In Snowflake you can…
Can HobekCan 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 CaliseMario CaliseMarch 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 CaliseMario CaliseMarch 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 PieriniSofia PieriniMarch 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 PieriniSofia 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 RacioppiNiccolo RacioppiMarch 20, 2023
Uncategorized

Snowflake Pricing Control Features

Snowflake with his advanced storage features, has the ability to store your data in the…
Can HobekCan HobekMarch 20, 2023
PythonSQL

Wildcard searches in SQL and Python

Last week I found myself wondering about wildcard searches in SQL and Python. And to…
Can HobekCan HobekMarch 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 PieriniSofia 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 CaliseMario 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 CaliseMario 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 CaliseMario 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 HobekCan HobekMarch 17, 2023
Snowflake

Grant privileges in Snowflake

Why can't we grant privileges to a Snowflake object AND its children? In the first…
Can HobekCan HobekMarch 17, 2023
SnowflakeSQLUncategorized

DROP,TRUNCATE and DELETE

Three ways to delete your data. We compare three commands on different characteristics such as:…
Niccolo RacioppiNiccolo 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 RacioppiNiccolo RacioppiMarch 17, 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 CaliseMario CaliseMarch 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 HobekCan HobekMarch 1, 2023
Snowflake

Snowflake MAX_BY function

Ever wonder how to easily look-up a corresponding column of a maximum value in Snowflake?…
Can HobekCan HobekMarch 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 PieriniSofia PieriniMarch 1, 2023