Can you try to reinstall the plugin?

meltano install loader target-snowflake --clean

I don’t see that import in the latest

snowflake-connector-python

supported by target-snowflake (file here), so I think you’ve got the wrong version of that library for some reason.