ImportError: Error loading shared library libsybdb.so.5: No such file or directory (needed by /usr/lib/python3.6/site-packages/pymssql.cpython-36m-x86_64-linux-gnu.so)

Error

If you’re making use of the SQL Server hook with Airflow, you might see the following error:

ImportError: Error loading shared library libsybdb.so.5: No such file or directory (needed by /usr/lib/python3.6/site-packages/pymssql.cpython-36m-x86_64-linux-gnu.so)

Fix

This error indicates a missing dependency. To fix it, add the freetds Linux package to your packages.txt file on Astronomer.

FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases.