Skip to main content
Hit enter to search or ESC to close
Close Search
Menu
Wie we zijn
Het bedrijf
Team
Analytics Engineer Opleiding
Detachering
Technologie
Snowflake
Fivetran
DBT
Andere technologieën
Connectors
Industrieën
Financiele sector & verzekeringen
Farmaceutisch & gezondheidszorg
Mode en Luxe
Productie sector
Retail & GDO
Inzichten
Succesverhalen
Bibliotheek
Blogs
Events
Contact
Nederlands
English
Home
»
Blogs nieuw
Filter
All
Academy
Airbyte
Cache
Data
Data Generation
Data Load
Data Visualization
Database
Database Creation
dbt
Fivetran
Frosty friday
Git
github
Google Colab
Jinja
JSON
Mock Data
Nimbus Use Case
Pipes
Python
Quiz
Security
Snowday
Snowflake
SnowPro core certification
Snowsight
SQL
Uncategorized
Uncategorized
Unstructured Data
Data
Data Engineer: The Numbers Expert Essential in Finance
The AFC (Administration, Finance, and Control) function is one of the areas that can benefit…
Nimbus
november 7, 2024
Data
Analytics Engineer: The Pillar of Digital Transformation in Business
The arrival of the Analytics Engineer has transformed how organisations interpret data and its role…
Nimbus
oktober 24, 2024
Data
Big Data Expert: How And Why To Leverage Them For Business Growth
A big data expert within a company is almost essential nowadays. When strategies need to…
Nimbus
oktober 10, 2024
Data
Data Lake Architecture: Nimbus’ 7 Tips for setting it up effectively
Implementing a well-designed data lake architecture is essential for effectively managing the growing need to…
Nimbus
september 5, 2024
Data
Data transformation: how and why to do it in the cloud
In today's business environment, data transformation is a key priority. Data-driven strategies are becoming essential…
Nimbus
juli 18, 2024
Nimbus Use Case
Cloud consulting: which is the right formula for your business?
Cloud consulting goes beyond merely providing guidance on the best strategy for your business; it…
Nimbus
juni 27, 2024
Data
Data integration: how to do it between tools and processes
Data integration has emerged as a critical component for companies seeking to maximise the value…
Nimbus
juni 13, 2024
Data
Data Pipeline: What It Is and Why You Should Implement It
Many companies are on the verge of becoming data-driven, a business model that bases its…
Nimbus
juni 6, 2024
Data
Data Load
Data ingestion: definition at a glance
Today, companies face challenges not only related to the sheer volume of data but also,…
Nimbus
mei 30, 2024
Data
Cloud data warehouse: how to choose the right one
A cloud data warehouse guarantees relevant scalability, performance and overall data management benefits. Therefore, choosing…
Nimbus
mei 23, 2024
Data
Data warehouse: the 3 reasons to have one in the cloud
Equipping your organisation with a cloud-based data warehouse provides you with the foundation to accelerate…
Nimbus
april 18, 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 Kholov
maart 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 Scatassi
maart 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 Kiesewetter
maart 15, 2024
Uncategorized
User Group: Women on Snowflake
Last week on March 11, I participated in the first meeting of the Women on…
Aleksandra Molenda
maart 15, 2024
Uncategorized
Data Scaling Capabilities with Snowflake
Nowadays organizations deal with increasing amount of data volumes and data complexity. Fortunately, platforms such…
Jeroen Smits
maart 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 Kaymakanova
maart 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 Scatassi
maart 8, 2024
Uncategorized
The Data Evolution: Embracing ELT for Agile Data Warehousing
ELT has been making its way into the data world these past years and making…
Jordi Kiesewetter
maart 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 Pastore
maart 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 Molenda
maart 8, 2024
Uncategorized
SnowPro Core Certification: it’s time to go old-school.
Topics and percentages Winning strategy: old school studying
Sofia Pierini
maart 5, 2024
Uncategorized
S7. What’s under the Snowflake(s)?
week dbt friendly
Sofia Pierini
maart 5, 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 Kholov
maart 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 Trillo
maart 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 Molenda
maart 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 Kiesewetter
maart 1, 2024
Uncategorized
Empowering Analytics engineering with dbt
In the fast changing landscape of data analytics, the role of an analytics engineer has…
Jeroen Smits
maart 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 Pastore
maart 1, 2024
Uncategorized
Fivetran and Airbyte: A Comparative Look
In the landscape of data management, we are assisting at the shift from…
Marco Scatassi
maart 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 Compagnoni
februari 29, 2024
Uncategorized
Deployment in DBT
In this blog post you will learn everything you need to start deploying your projects…
Guillermo Izquierdo
februari 29, 2024
Uncategorized
Understanding GitHub Actions
GitHub Actions have revolutionized the way developers automate and streamline their workflow processes. This powerful…
Gerard Perelló Martínez
februari 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 Kholov
februari 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 Trillo
februari 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 Smits
februari 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 Scatassi
februari 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 Kiesewetter
februari 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 Molenda
februari 23, 2024
Data
Data Load
dbt
Fivetran
Git
github
Snowflake
Uncategorized
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 Kaymakanova
februari 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 Kholov
februari 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 Smits
februari 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 Kiesewetter
februari 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 Scatassi
februari 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.…
Dominique
februari 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 Kaymakanova
februari 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 Pastore
februari 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 Trillo
februari 2, 2024
Uncategorized
When Uncertainty Meets Data
Image by macrovector on Freepik In our daily lives, we all experience how…
Marco Scatassi
februari 2, 2024
Uncategorized
Why Do We Mask Data?
Data masking is a crucial aspect of data protection. WHY? Because many industries have to…
Dominique
februari 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 Molenda
februari 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 Kiesewetter
februari 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 Pastore
januari 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 Kholov
januari 27, 2024
Uncategorized
Smart City: What, How and… Snowflake
Image by pikisuperstar on Freepik Smart City is a largely used term and…
Marco Scatassi
januari 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 Smits
januari 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 Trillo
januari 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 Kiesewetter
januari 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 Molenda
januari 25, 2024
Uncategorized
How to write cleaner SQL queries
In the world of database management, crafting efficient and readable SQL queries is an essential…
Dominique
januari 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 Kholov
januari 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 Pastore
januari 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 Trillo
januari 19, 2024
Uncategorized
Breaking Down Data Silos Embracing Snowflake
Image by rawpixel.com on Freepik Breaking down data silos means removing the invisible…
Marco Scatassi
januari 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 Molenda
januari 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 Smits
januari 19, 2024
dbt
dbt Analytics Engineering Certification
This blog post is my personal experience through achieving the dbt Analytics Engineering Certification, with…
Luca Balduzzi
december 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 Compagnoni
december 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ínez
december 3, 2023
Uncategorized
How To Demo Snowflake
Here, at Nimbus Intelligence, we use Snowflake everyday — whether it be on its own…
Guillermo Izquierdo
december 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 Draetta
december 1, 2023
dbt
Jinja
SQL
Uncategorized
Macros in dbt
Macros in dbt are reusable pieces of code that ensure that the code is ‘DRY’…
Luca Balduzzi
december 1, 2023
dbt
Uncategorized
Documentation in dbt
Documenting a database structure is as vital as it is often overlooked. Many times the…
Chris Verweij
november 24, 2023
Uncategorized
Incremental Models in dbt
As your organization grows, so will your tables. A full rebuild of your models might…
Edoardo Draetta
november 24, 2023
Jinja
Jinja Basics II
This blog is the continuation of my previous one that you can find here. As…
Luca Balduzzi
november 24, 2023
Jinja
Jinja Basics I
Jinja is more than just a city in Uganda or a Japanese temple: it’s a…
Luca Balduzzi
november 20, 2023
Uncategorized
ABC of DBT tests
What is a test in DBT? Tests are assertions that you make about your models…
Guillermo Izquierdo
november 19, 2023
Uncategorized
Snowflake VSCode Integration
In Nimbus we are very familiar with Snowflake; in fact, we consider it to be…
Gerard Perelló Martínez
november 17, 2023
Data Load
JSON
Snowflake
SQL
Unstructured 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 Draetta
november 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 Verweij
november 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 Compagnoni
november 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ínez
november 10, 2023
Uncategorized
Snowday Security Highlights
Snowday was full of surprises. I was ready to see loads of exciting new features.…
Guillermo Izquierdo
november 10, 2023
JSON
Snowflake
Unstructured Data
Killing JSON: The Flatten Function
Welcome to Killing JSON, a series in which I channel my frustration with loading data…
Edoardo Draetta
november 10, 2023
Uncategorized
Understanding modularity
Last week we talked about DBT models. It's time to dive deeper in understanding modularity.…
Darko Monzio Compagnoni
november 10, 2023
Database
Snowday
Snowflake
Snowflake Hybrid Tables
Hybrid Tables in Snowflake are a new type of table that can support transactional workloads.…
Luca Balduzzi
november 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 Verweij
november 3, 2023
Snowday
Snowflake
My First Snowday: Notebooks, ML, and AI
Snowflake hopes to ride the AI wave AI is booming, and Snowflake doesn’t want to…
Edoardo Draetta
november 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ínez
november 3, 2023
Data
Security
Snowflake
Snowflake Data Sensitivity & Access Visibility
Snowflake’s features and capabilities enable you to manage, protect, and share your data securely and…
Luca Balduzzi
november 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 Compagnoni
november 3, 2023
Uncategorized
DBT models
In this blog post I will explain what DBT models are and how to use…
Guillermo Izquierdo
oktober 31, 2023
Uncategorized
Network Policies in Snowflake
In Snowflake, network policies enable the restriction of Snowflake account access by specifying blocked and…
Edoardo Draetta
oktober 30, 2023
Uncategorized
Data Encryption and Authentication
This is part one of a two part series overviewing Snowflake's security measures and tools.…
Guillermo Izquierdo
oktober 27, 2023
Security
Snowflake
Snowflake Data Access Policies
Snowflake’s features and capabilities enable you to manage, protect, and share your data securely and…
Luca Balduzzi
oktober 26, 2023
Uncategorized
Understanding Snowflake Sessions
Snowflake, a cloud-based data warehousing platform, facilitates handling and analyzing large datasets with ease. One…
Darko Monzio Compagnoni
oktober 25, 2023
Uncategorized
Snowflake Architecture
In this post I will introduce you to the main components of the Snowflake Architecture.…
Guillermo Izquierdo
oktober 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ínez
oktober 20, 2023
Uncategorized
Data Clustering in Snowflake
Data clustering in Snowflake, a process of organizing related rows within micropartitions, is pivotal for…
Edoardo Draetta
oktober 20, 2023
Cache
Snowflake
Snowflake Caching
Snowflake is a cloud data platform that provides fast and scalable data warehousing, data sharing,…
Luca Balduzzi
oktober 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 Compagnoni
oktober 20, 2023
Uncategorized
Time travel in Snowflake
Every database administrator has at some point in their life had the dreaded call: Something…
Chris Verweij
oktober 19, 2023
Data
Data Load
Snowflake
SQL
Semi-structured data in Snowflake
The easiest form of data to load into a SQL database is fully structured. Comma…
Chris Verweij
oktober 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 Compagnoni
oktober 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 Draetta
oktober 13, 2023
Git
github
Python
Python Best Practices
Python is a popular and versatile programming language that can be used for various applications.…
Luca Balduzzi
oktober 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ínez
oktober 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 Izquierdo
oktober 6, 2023
Uncategorized
Understanding Boolean Indexing in Pandas
Pandas, the popular Python library for data manipulation and analysis, offers a plethora of techniques…
Edoardo Draetta
oktober 6, 2023
Git
Git Basic Commands
In this blog post, I will continue to explain some of Git basic commands, which…
Luca Balduzzi
oktober 6, 2023
Uncategorized
Collaboration in practice
After our first month of getting up to speed in Snowflake and SQL, the first…
Chris Verweij
oktober 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 Compagnoni
oktober 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 Izquierdo
september 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ínez
september 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 Compagnoni
september 29, 2023
Git
Git Introduction
This short Git tutorial will explain the main ideas of this amazing software that helps…
Luca Balduzzi
september 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 Verweij
september 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 Draetta
september 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 Izquierdo
september 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 Verweij
september 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 Draetta
september 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 Compagnoni
september 22, 2023
Database
Database Creation
Entity Relation Diagram
Entity Relation Diagram is part of the data modelling process ant it's the representation of…
Luca Balduzzi
september 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ínez
september 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 Izquierdo
september 15, 2023
Academy
Snowflake
Basic Access Control Privileges in Snowflake
""Why can't I see this table...?"" — Frustrated Snowflake User A key feature of the…
Edoardo Draetta
september 15, 2023
Snowflake
Snowflake Resource Monitor
The Snowflake Resource Monitor can be used to control warehouse credit usage, avoiding unexpected behaviors.…
Luca Balduzzi
september 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ínez
september 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 Compagnoni
september 15, 2023
Uncategorized
Van laboratoriumanalist naar analytics engineer
Tot vorige maand werkte ik in als laboratoriumanalist moleculaire biologie. Hier hield ik mij bezig…
Chris Verweij
september 15, 2023
Snowflake
SnowPro 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 Pierini
juni 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 Sanchez
juni 2, 2023
Academy
dbt
Fivetran
Snowflake
SQL
Modern Data Stack in One Day
At Nimbus Intelligence Academy we are trained to build a modern data stack including data…
Kris Winnubst
mei 30, 2023
Data Load
dbt
github
Snowflake
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 Pierini
mei 26, 2023
Data
Data Load
Data Visualization
Snowflake
SQL
Column Level Security
Snowflake, as a modern cloud database, has the functionality to mask sensitive data for unauthorized…
Mario Calise
mei 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 Sanchez
mei 22, 2023
Uncategorized
System Functions in Snowflake
System Functions in Snowflake gives you the option to check your Snowflake instance and have…
Can Hobek
mei 21, 2023
Uncategorized
How/When to Create Listings
Snowflake has a lot of special features that make itself unique. In this blog I…
Can Hobek
mei 21, 2023
Airbyte
Snowflake
Snowflake setup in Airbyte
Fivetran and Airbyte are two tools that extract, load and possibly transform (the ELT process)…
Kris Winnubst
mei 19, 2023
Fivetran
Snowflake
Snowflake setup in Fivetran
Fivetran and Airbyte are two tools that extract, load and possibly transform (the ELT process)…
Kris Winnubst
mei 19, 2023
Database
Snowflake
Vector Databases from 1000 Meters
In the ever-expanding realm of data, a significant portion remains unstructured, posing challenges for traditional…
Sebastian Wiesner
mei 19, 2023
Academy
Data
Database
Snowflake
SQL
Uncategorized
Conversion Functions- Part1
Conversion functions allow a data item of one datatype supported by Snowflake to be transformed…
Niccolo Racioppi
mei 18, 2023
Data
Database
Snowflake
SQL
Uncategorized
INFORMATION SCHEMA
The Information Schema is a tool full of potential that allows us to keep track…
Niccolo Racioppi
mei 18, 2023
Data
Frosty friday
Snowflake
SQL
S7. What’s under the Snowflake(s)?
Do you want to keep secure your data? Then, let's dedicate this new post of…
Sofia Pierini
mei 18, 2023
Data
Frosty friday
Snowflake
SQL
S10. What’s under the Snowflake(s)?
Do you want to keep secure your data? Then, let's dedicate this new post of…
Sofia Pierini
mei 18, 2023
Data Load
Frosty friday
Snowflake
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 Pierini
mei 18, 2023
Data
Data Load
Database
Pipes
Snowflake
SQL
Snowflake’s INFER SCHEMA
In this blog, we are going to discuss how Snowflake allows to easily interpret semi-structured data…
Mario Calise
mei 17, 2023
Python
GoL 1: Understanding Pygame
As I explained at the beginning of the previous blog, I am now creating a…
Eloi Sanchez
mei 16, 2023
Snowflake
Create Named Stages using Snowsight
''With this release, we are pleased to announce the preview of creating and editing named…
Dimitris Lampriadis
mei 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 Lampriadis
mei 14, 2023
Frosty friday
Python
Snowsight
Uncategorized
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 Pierini
mei 14, 2023
Data
Database
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 Wiesner
mei 12, 2023
Data Load
Database
Data Integration Battle: Fivetran vs. Airbyte
Data integration platforms like Fivetran and Airbyte are critical for businesses that rely on data…
Sebastian Wiesner
mei 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 Sanchez
mei 9, 2023
Python
Uncategorized
Challenge: The Game of Life in Python
Hey there! I am back this week with another Python challenge. This was actually a…
Eloi Sanchez
mei 5, 2023
dbt
Custom generic test in dbt
Writing a custom generic test in dbt allows you to test your data on your…
Kris Winnubst
mei 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 Hobek
mei 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 Hobek
mei 1, 2023
dbt
Starting with dbt Cloud
Data Build Tool is a tool for managing and transforming your data, creating scheduled jobs,…
Dimitris Lampriadis
april 28, 2023
Snowflake
REGEX in Snowflake
It is possible to match strings with regular expression (also called REGEX) in Snowflake. I…
Kris Winnubst
april 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 Wiesner
april 28, 2023
Snowflake
Uncategorized
How to connect VS Code to Snowflake
During the last years, I have been using Visual Studio Code for everything. Therefore, now…
Eloi Sanchez
april 26, 2023
Data
Data Load
Database
Pipes
Snowflake
SQL
Snowflake Snowpipe
In the previous chapters of this series, we have seen how to load through staging…
Mario Calise
april 25, 2023
Data
Data Visualization
Visualizing Data
Effective data visualization is a critical skill for any Data Analyst and Analytics Engineer. Data…
Dimitris Lampriadis
april 21, 2023
Data Load
Snowflake
Data validation in Snowflake
As a follow up of my previous blog on SQL injection into Snowflake, I made…
Kris Winnubst
april 21, 2023
Data
Python
What are Moving Averages?
If you have been in the data environment for some time you will have probably…
Eloi Sanchez
april 21, 2023
Data
Snowflake
SQL
Optimizing SQL Queries in Snowflake
In this blog, we'll discuss practical tips and tricks to optimize SQL queries in Snowflake…
Sebastian Wiesner
april 20, 2023
SQL
Snowflake SQL Injection
SQL Injection has the potential to ruin your database. If you have heard of the…
Kris Winnubst
april 17, 2023
Data Load
Snowflake
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 Wiesner
april 14, 2023
SQL
Challenge: Integrals in SQL?
Last week I brought you a challenge on how to make derivatives in SQL. Evidently,…
Eloi Sanchez
april 14, 2023
SQL
SQL Case Statements
We have already seen how nesting aggregated functions and SQL join types work in the…
Dimitris Lampriadis
april 8, 2023
Snowflake
Automate external stage loading
This week I set-up automate external stage loading. I did this for our first mock…
Kris Winnubst
april 7, 2023
Data
Data Load
Database
Snowflake
SQL
Uncategorized
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 Racioppi
april 7, 2023
Academy
Snowflake
Snowflake SnowPro: How to probably Ace it
As an Analytics Engineer trainee, I recently took the Snowflake Snowpro Core Certification exam. Before…
Sebastian Wiesner
april 7, 2023
Academy
Data
Database
Snowflake
How to become a SnowPro
I took the SnowPro Core Certification exam. SnowPro Core certification badge I will make some…
Niccolo Racioppi
april 7, 2023
SQL
Challenge: Derivatives in SQL?
Today I bring you a challenge! Just a fun little exercise to train your SQL…
Eloi Sanchez
april 7, 2023
Data
Database
Snowflake
Snowflake’s Security Measures against Cyber Threats
The Barrier Between Your Data and Cyber Threats Snowflake's data platform has gained popularity for…
Sebastian Wiesner
april 7, 2023
Academy
Snowflake
Tips for the SnowPro Core Certification Exam
If you are currently in the data field, or you are considering going into it,…
Eloi Sanchez
april 7, 2023
Academy
Snowflake
SnowPro Core Certification: My First Attempt
Yesterday was the big day. My first attempt to become a certified SnowPro Core Expert…
Dimitris Lampriadis
april 3, 2023
Academy
Snowflake
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 Calise
april 2, 2023
Quiz
Snowflake
Snowflake Numbers Quiz
Last Friday was our first attempt at the SnowPro Core certification exam, and I passed!…
Kris Winnubst
april 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 Lampriadis
maart 23, 2023
Uncategorized
Snowflake Dashboards
As we know on Snowflake our warehouses can execute one operation per time per user.…
Can Hobek
maart 23, 2023
Frosty friday
Python
Snowflake
S4. What’s under the Snowflake(s)?
S4. What's under the Snowflake(s)? Week 5 - Basic Are you ready for a new…
Sofia Pierini
maart 23, 2023
Data
Data Generation
Data Load
Mock Data
SQL
Mockaroo: fake realistic data
In writing previous blogs, I found myself having to search for old tables in which…
Niccolo Racioppi
maart 23, 2023
Database
Snowflake
Keeping Your Data Safe: Blockchain vs. Snowflake
Businesses today are highly concerned with safeguarding their data. While Snowflake has established itself as…
Sebastian Wiesner
maart 23, 2023
Python
Better plots with Streamlit
We have already seen how to get Snowflake to work with Python and how to…
Eloi Sanchez
maart 23, 2023
Data Load
Database
Snowflake
SQL
Snowflake File Formats
In the previous chapters of this series, we have seen how to load through staging…
Mario Calise
maart 23, 2023
Frosty friday
Snowflake
SQL
S3. What’s under the Snowflake(s)?
What's under the Snowflake(s)? - Week 23 - Basic Are you curious about SnowSQL? Then,…
Sofia Pierini
maart 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 Lampriadis
maart 22, 2023
Uncategorized
Stored Procedures
Stored Procedures allow us to write functions inside our SQL code. In Snowflake you can…
Can Hobek
maart 22, 2023
Database
Snowflake
Snowsight
Chart Visualizations in Snowsight
Along with the interactive results, Snowsight also offers a Chart Visualization service.The section dedicated to…
Niccolo Racioppi
maart 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 Pierini
maart 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 Wiesner
maart 22, 2023
Data
Data Generation
Database
Snowflake
Unload data from your Snowflake account
We have previously seen how to load data from foreign sources to your Snowflake account…
Mario Calise
maart 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 Sanchez
maart 22, 2023
Frosty friday
Snowflake
SQL
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 Pierini
maart 22, 2023
Database
Snowflake
Interactive results in Snowsight
When we run a query we would like to have a quick overview of the…
Niccolo Racioppi
maart 22, 2023
Uncategorized
User-Defined Functions
User-Defined Functions allow us to write functions inside our SQL code. In Snowflake you can…
Can Hobek
maart 21, 2023
Academy
Data Load
Database
Snowflake
Load data on your Snowflake account
In the previous chapter we have talked about Snowflake stages. It is now clear that…
Mario Calise
maart 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 Lampriadis
maart 21, 2023
Data Load
Database
Snowflake
Snowflake Stages: a brief explanation
Data storage is a critical component of any database system. When dealing with large amounts…
Mario Calise
maart 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 Wiesner
maart 21, 2023
Database
Python
Snowflake
SQL
S0. What’s under the Snowflake(s)?
Database, table, and virtual warehouse are basic Snowflake objects required for most Snowflake activities. Setting…
Sofia Pierini
maart 21, 2023
Frosty friday
Python
Snowflake
SQL
What’s under the Snowflake(s)?
Have you ever wondered what is under the snow? What are the snowflakes hiding? Have…
Sofia Pierini
maart 21, 2023
Academy
Database
Snowflake
Saving time: shortcuts in Snowflake!
Often we are faced with time constraints or impending deliveries, it would be handy to…
Niccolo Racioppi
maart 20, 2023
Uncategorized
Snowflake Pricing Control Features
Snowflake with his advanced storage features, has the ability to store your data in the…
Can Hobek
maart 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 Lampriadis
maart 20, 2023
Python
SQL
Wildcard searches in SQL and Python
Last week I found myself wondering about wildcard searches in SQL and Python. And to…
Kris Winnubst
maart 20, 2023
Database
Snowflake
Snowflake: Melting our Environment?
In the digital age, we generate vast amounts of data that need to be stored…
Sebastian Wiesner
maart 20, 2023
Python
Snowflake
Using Snowflake Data with Pandas
Today we are going to see how to use our Snowflake Data with Pandas in…
Eloi Sanchez
maart 20, 2023
SQL
Nesting Aggregated functions
This blogpost marks the beginning of a long and very exciting journey in the world…
Dimitris Lampriadis
maart 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 Wiesner
maart 20, 2023
Database
Google Colab
Python
Snowflake
Uncategorized
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 Pierini
maart 18, 2023
Academy
Database
Snowflake
SQL
Zero-Copy Cloning: Snowflake’s unique feature
When we talk about Business Intelligence we immediately think of the strategies connected to the…
Mario Calise
maart 17, 2023
Database
Snowflake
OLAP and OLTP systems: advantages and features
If we examine how data analysis methods have evolved over the years, we note…
Mario Calise
maart 17, 2023
Google Colab
Python
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 Calise
maart 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 Hobek
maart 17, 2023
Python
Snowflake
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 Lampriadis
maart 17, 2023
Snowflake
Grant privileges in Snowflake
Why can't we grant privileges to a Snowflake object AND its children? In the first…
Kris Winnubst
maart 17, 2023
Snowflake
SQL
Uncategorized
DROP,TRUNCATE and DELETE
Three ways to delete your data. We compare three commands on different characteristics such as:…
Niccolo Racioppi
maart 17, 2023
Academy
Database
Snowflake
Micro-partitions and Clustering:
Let's talk about partitions! The desire to partition large amounts of data organized in large…
Niccolo Racioppi
maart 17, 2023
Python
Snowflake
Using Snowflake Data in Python
Let's say that we have a database stored in Snowflake with some data that we…
Eloi Sanchez
maart 10, 2023
Database
SQL
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 Calise
maart 1, 2023
SQL
Nesting Group By and Partitioning
During my formation on Snowflake at Nimbus Intelligence our professor showed us a query that…
Eloi Sanchez
maart 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 Hobek
maart 1, 2023
Snowflake
Snowflake MAX_BY function
Ever wonder how to easily look-up a corresponding column of a maximum value in Snowflake?…
Kris Winnubst
maart 1, 2023
Academy
Snowflake
Uncategorized
Can a Philosopher become an Analytics Engineer?
Analytics Engineers are cloud-based data specialists, new members in data team, whilst philosophers often have…
Sofia Pierini
maart 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 Wiesner
maart 1, 2023
Close Menu
Wie we zijn
Het bedrijf
Team
Analytics Engineer Opleiding
Detachering
Technologie
Snowflake
Fivetran
DBT
Andere technologieën
Connectors
Industrieën
Financiele sector & verzekeringen
Farmaceutisch & gezondheidszorg
Mode en Luxe
Productie sector
Retail & GDO
Inzichten
Succesverhalen
Bibliotheek
Blogs
Events
Contact
Nederlands
English
