Data Engineering

Integrating Azure Blob Storage with Snowflake: A Guide to Storage Integration and Staging Data

This article offers a comprehensive, step-by-step guide for integrating Azure Blob Storage with a Snowflake account hosted on AWS using…

2 weeks ago

Getting Started with SnowSQL: Connecting to Your Snowflake Account

In this quick guide, we’ll walk through the essential steps to connect to Snowflake using SnowSQL, Snowflake’s powerful command-line interface.…

3 months ago

Data Modeling and its relevance in the Cloud Era

Since 2005, I've immersed myself in the dynamic world of data and its modeling. It's been fascinating to witness how…

9 months ago

Looking back to Kimball’s approach to Data Warehousing

Over time, it's fascinating to witness how certain concepts, approaches, or visions age. Time, in its inexorable flow, often brings…

1 year ago

Playing with some Pandas functions and Airflow operators

Recently, I was dealing with a task where I had to import raw information into a staging PostgreSQL Database as…

2 years ago

Getting the last modified directory with Python

Working with os paths is a prevalent task, especially when working on a console application in Python. Recently, I had…

2 years ago

First steps for configuring SQL Server with Docker

Sometimes, our working habits could experiment some interesting changes, maybe forced by real needs or even simply for the valid…

3 years ago

An introduction to pathlib module of Python

First at all, I would like to clarify something that maybe sounds evident, but sometimes we forget, the path is…

4 years ago

Python Lambda and Regex – A good team for replacing a string using dictionaries

The aim of this post is to show you a specific and useful tip in Python for replacing strings with…

4 years ago

Python for Data Engineering and other stories

If you are involved in the IT world it is more than sure that you have heard about Python and…

4 years ago