Connecting to Databricks SQL Warehouses using SQLAlchemy

I have been tasked recently to connect a Python Flask application to a Databricks SQL Warehouse using SQLAlchemy. As a good practice, I wrote a simple Threading wrapper around the query execution to time out the query if it takes too long to avoid wasting resources. Imagining that setting the timeout like this would be enough, I noticed that queries were left hanging in the cluster and not being killed....

March 28, 2025 · 2 min

Backing up your data using Restic and Airflow

In the past few weeks, I have been using restic to backup my data. Restic is a fast, secure, and efficient backup program that supports a variety of backends, including local storage, S3, and Google Cloud Storage. Since I am a home lab person and owner of a Synology NAS (unfortunately, but this is a story for another post), I got frustrated with the lack of a good backup solution (Hyper Backup, I’m looking at you)....

August 9, 2024 · 2 min

Project Session Added

To share more about what I have been working on, I have added a new section to my blog called “Projects”. This section will contain detailed information about the projects I am working on, including the technologies used. I’ll try to add as many details about them in separated posts, so you can follow along with my progress. Stay tuned for more updates!

August 1, 2024 · 1 min

Hello, World!

Hello, world! Welcome to the very first post on my blog. Who Am I? My name is Jelther Goncalves, and I’m passionate about technology, coding, and all things digital. What Can You Expect? On this page, you’ll find a variety of content that reflects my interests and projects: Tutorials and How-Tos Project Diaries Tips and Tricks Personal Reflections Why Am I Doing This? We have too much social media today and not enough personal websites....

June 22, 2024 · 1 min