Error: Numpy Dtype Size Changed, May Indicate Binary Incompatibility

Issue

Sync fails with the following error:

ValueError: numpy.dtype size changed, may indicate binary incompatibility. Expected 96 from C header, got 88 from PyObject

Environment

Fivetran Connector SDK

Resolution

Certain versions of numpy and pandas may not work well together. If you want to use the latest compatible versions of both packages, add the package names to requirements.txt, and pip installs will install the latest compatible versions. To do so, update requirements.txt as follows:

requirements.txt

numpy
pandas

If you need a specific working version of numpy and pandas, check their compatibility and update the requirements.txt file as follows:

requirements.txt

numpy==<version>
pandas==<version>

Cause

This issue occurs due to incompatibility between certain versions of numpy and pandas packages.