Sadowitz

Sadowitz was a slack bot that I built together with Olmo Martinez to help account managers at ABInBev. It was built using the Slack API and Python. It was a simple bot that would listen to messages in a channel and respond to certain commands. Those commands were linked either to SQL queries, JupyterNotebooks or specific analysis questions. Even there was the option to launch REST API calls to lambda functions to get and format the data. The data was returned as an excel or image.

JeffreyBot was as an evolution of Sadowitz where anyone can link regular expression based commands with Jupyter notebooks. Each time a command was launched, a new Jupyter notebook was executed in a isolated docker container. A set of iddle running containers where keept running to speed up the response time.

It was a fun project to work on and I learned a lot about building bots.

You can find the code in Github for JeffreyBot and KernelRunner