This one simple trick lets you stream with dbt and Databricks
Are you using Databricks and want to use dbt, but you're not sure how to do it with all of your big data? Like, dbt can't »
Automating tedium with the ServiceNow API
I should have named this blog Enterprise . But big companies are going to use ServiceNow whether or not HR likes handling onboarding tickets in the side-project »
Eternities of Gitlab CI pipeline trial + error...only run with changes
I've spent many mind-numbing hours trying to get this Gitlab CI pipeline to work the way I want it to work. I'm not sure if I'm »
Jest - mock a single function in a module
Though the requireActual route looked promising, it only worked when I called the mocked function directly in my test, and not when used like in real »
MLOps, CI, and development flows using Databricks
I wrote this about a year or two ago while I was still working a lot with Databricks. It was right around the time where "MLOps" »
In Soviet Russia, ad finds you
This is a post I wrote for work to explain the basics and foundations of ad tracking. It was meant for a fairly nontechnical audience, so »
ODBC and DB2 - problem saving a large chunk of text - CWBNL0107
I'm using PyODBC to connect to DB2 and was seeing some problems saving certain rows of data. The column the error message mentioned was a CLOB »
Connect to DB2 from python with SQLAlchemy
This is kind of a sister post to my Databricks-specific post from the other day. It's amazing how much time you can spend searching through docs, »
Access DB2 From Databricks
This took me a good few hours to figure out. So hopefully it will help you and my future self. install com.ibm.db2.jcc:db2jcc: »
7x performance improvement for my dead slow SQL Server + Django pyodbc queries
In one of my Django projects, I'm connecting to a SQL server database, and I'm doing this with django-pyodbc-azure. I noticed that my query performance was »
Django in Azure Web Apps - too many redirects
I've been testing out Azure Web App services lately so I can avoid all of the reverse proxy/server management mumbo jumbo. When I was deploying »
Working with SQL Server in Django pt. II
This is a follow-up and brutal takedown of a post I wrote about two years ago. Go here for part I. I'm starting to use Django »
Calculate grouped YTD totals for previous years in Pandas
I want to calculate the YTD total for the last couple years for every customer + product combination that has been sold. I'm new to Pandas and »
Import a directory into Databricks using the Workspace API in Python
Another fairly easy thing that I couldn't find in the docs. I wanted to be able to upload a directory into my Databricks Workspace from my »
Read from SQL Server with Python/Pyspark in Databricks
This is actually really easy, but not something spelled out explicitly in the Databricks docs, though it is mentioned in the Spark docs. Alas, SQL server »
Parse XML with PySpark in Databricks
It's kind of a trick title, but here's the answer: don't. Just don't do it. Python is no good here - you might as well drop »
Logging with Sentry on Databricks
I couldn't find anything that laid this out really plainly, so I'm going to do so here. I'll update as I learn more and dig deeper, »
Application is not supported over the /common or /consumers endpoints. Please use the /organizations or tenant-specific endpoint.
I was getting this error message when trying to sign into Azure Active Directory in a .Net Core 2.x app. It was written by someone »
The Trials and Tribulations of a Database Context in .NET Core (pt. 1)
When I started using .NET Core this time around, I was pleasantly surprised. But over the past couple of days, I have been unpleasantly surprised. There »
Dependency injection in .NET Core 2.0
Say I have a controller and I want it to pull something from Amazon. Say that I also have unit tests and I don't want to »