Python Snowflake UDF Quoting Issue

I recently did some tinkering with creating a Snowflake UDF in Python. It turns out that I discovered a Python Snowflake UDF Quoting issue on the return value from the function. I was not able to find any information on this issue online so I figured it was good to document it for anyone else that might run into the same problem. It turns out that this also impacted a Javascript UDF that I had also written....

February 16, 2023 · 3 min · Scott

Testing Python AWS calls with Moto

In my previous Writing Tests For Your Python Project, I started writing tests for my Python code but then ran out of options because I had completed all tests that didn’t involve calls to the AWS API. Now we’ll begin testing Python AWS calls with Moto. You can view some additional details about Moto in their documentation. You will want to also review the list of Implemented Services in the Moto documentation to make sure you the API endpoints and methods are supported....

January 27, 2023 · 9 min · Scott

Writing Tests For Your Python Project

I began this little trip with the post Exporting CloudWatch Logs to S3 that provided example code to get logs from Cloud Watch to S3. From there, the code got prettier with Adding pre-commit Hooks to Python Repo. The next logical step is to make sure the code functions exactly like we’d expect. This can be done by writing tests to make sure our code functions like we’d expect. I’ve highlighted a number of reasons why you should create tests in the article Top 5 Reasons to Build Tests for Your Code....

January 20, 2023 · 5 min · Scott

Top 5 Reasons to Build Tests for Your Code

As a Python developer, it’s important to make sure that your code is working correctly and efficiently. One way to do this is by building tests for your code. In this blog post, we’ll go over the top reasons why you should build tests for your Python code. Improved Quality One of the main benefits of building tests for your code is that it helps improve the quality of your code....

January 13, 2023 · 2 min · Scott

5 Common Reasons To Use Pre-commit Hooks in Your Python Project

Pre-commit hooks are scripts that run automatically before a commit is made. In my post Adding pre-commit Hooks to Python Repo, I explained how to configure pre-commit hooks in your repo and address the issues identified by them. After understanding how to setup these hooks, the next question is what hooks should I use and why? Here are five common reasons to use pre-commit hooks for Python and some example plugins that you can use for each reason....

January 6, 2023 · 5 min · Scott