Are you a PostgreSQL enthusiast using DBeaver on a Windows Platform? If you find yourself knee-deep in SQL queries and long for a cleaner, more organized code, then configuring pgFormatter might be the solution you’re looking for. In this post, we’ll dive into the intricacies of setting up pgFormatter within DBeaver on Windows, offering you…
Author: geohernandez
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 justice to ideas and individuals alike. Such a reflection is pertinent when considering the enduring impact of Ralph Kimball’s groundbreaking book on dimensional modeling for data warehousing and business intelligence.
List Comprehension and Walrus operator in Python
When we are working with lists, dictionaries, and sets in Python, we have a special syntax, called comprehensions. This feature helps us to improve the readability of our code, providing compact syntax for deriving a new list from another iterable.
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 part of a task in the Airflow DAG pipeline. I would like to share the approach used and exposes the valuable Pandas.json_normalize function and how it helps to prepare the data before importing. Reading the…