This week, I needed to update an older python script and in attempting to run the script, I ran into the error shown below. This… Read More »Work Around for Pandas Error “datetime64 type does not support sum operations”
What are tags? Tags in dbt are metadata annotations that can be applied to various resources such as models, tests, sources, snapshots, seeds, and metrics. They serve… Read More »Tagging Models in dbt
When writing Python code, it’s good to know where your working directory (or current working directory) lives. When you perform file operations without specifying a… Read More »Understanding Your Working Directory When Working With Python
Exporting to Excel is a very common task in Python, especially when developing. You might need to see an entire data set and be able… Read More »Exporting to Excel with Python Using df.to_excel & pd.ExcelWriter
First, this post is not a tutorial on how to use window functions in Denodo. I’ll come back and do that later. Rather, this post… Read More »Troubleshooting Window Functions in Denodo
What is Parquet & Why First, let’s start with what the Parquet format and why is it used. Parquet is an Apache open-source storage format… Read More »How to Convert .parquet Files to Excel With Python
When you grab a file path from the file explorer, you get a path with backward slashes (in Windows). However, you can’t just copy and… Read More »Handling File Paths in Python
I’m writing this blog post because I ran into an error today that I will surely run into again and not remember how to solve. So, this post explains how to fix the error – “Could not connect to your data gateway”. Now, the next time I have this problem, I’ll Google it, and Google will show me my own writing. It’s kinda fun when that happens. Read on to learn more.
Read More »How to Fix Data Gateway Error in Power Automate
When I first started working with Power Automate, I misunderstood a few key concepts. If I got the wrong idea, then I am willing to bet other people are working under the same misconceptions. That’s why I wrote this post on four things I misunderstood about Power Automate. Read on to learn more about these common misconceptions.
Read More »4 Things I Misunderstood About Power AutomateAs you build larger and more complex cloud flows, you might want to keep certain parts of the flow going, even when other parts fail. Not only is this possible, but it’s very easy to set up. Read on to learn how to keep Power Automate running after a failure.
Read More »Resilient Cloud Flows: How to Keep Power Automate Running After Failure