IT

In today's installment of, let's macro the heck out of this SaaS system, things didn't go entirely as I had planned.

Holy macros is right. dbt macros that is.

Okay, okay, that's not what dbt stands for. Data Build Tool, or dbt for short, is all the rage in the ELT world right now

Getting towards the end of our CRM Data Lake integration, we are down to the nitty gritty. The nitty gritty is actually quite a bit of grit

It's been a hot minute since my last entry about AWS Glue and our project is moving along, almost fully in our production environment!

Today Whit dabbles in AWS Glue. If you recall from our last blog, my team is working on creating a data lake

If you recall from previous posts, I am a Data Engineer in the Healthcare SaaS (software as a service) space. One of the tasks I have been

Navigating your way through the IT world can be confusing, especially when you don't have the formal degree with a specialty that you have worked towards. There are any number of ways to go (software, databases, support, QA, etc.), and under each of those umbrellas there are any number of roles. Not to mention, those roles change as tech changes or as ideas on value change. For me, a classically trained Geologist ("I happen to hold a bachelor of science degree in geology..

I am the queen of "under promise, over deliver." What does that mean? That means I have panicked about your deadline and am trying to figure out how I can deliver what you need in the timeframe you specified. The root of all of this: anxiety over perfection and the need for validation. I am a newer DBA. Lucky for me I was given the opportunity to spend about a year proving myself before I was graciously offered the position of Cloud Database Administrator at my company.

One of the things I do at my day job (Cloud Database Administrator) is troubleshoot issues with a Business Intelligence tool that is a GUI based, drag-and-drop interface. This type of tool is fabulous for business users without a ton of experience in direct SQL, but at the same time, can really get them into a pinch when they build a report that doesn't translate into a performant, well architected query. The same can be said for even the most seasoned Business Intelligenc