Subject: Compatibility Issues with

pipelinewise-tap-postgres

and

pipelinewise-target-snowflake

Hi everyone, We're using PipelineWise taps and targets, specifically: -

pipelinewise-tap-postgres==2.1.0

-

pipelinewise-target-snowflake==2.2.0

Since Snowflake is phasing out support for Python connector versions

< 3.0.0

, I upgraded

pipelinewise-target-snowflake

to version

2.3.0

, as the older version (

2.2.0

) uses Python connector

2.7.0

in the backend. However, I'm now facing compatibility issues. My problem seems identical to this open issue: 🔗 [PipelineWise tap-postgres Issue #228](https://github.com/transferwise/pipelinewise-tap-postgres/issues/228) Since pipelinewise-tap-postgres has been archived and the issue is still unresolved: 1. Has anyone else encountered this problem? 2. Are there any known solutions or workarounds for this? Any guidance would be greatly appreciated! Thanks in advance!

you could try turning off validation for the target-snowflake? Best suggestion I have is to try the meltanolabs variants https://hub.meltano.com/loaders/target-snowflake or the other variants here https://hub.meltano.com/extractors/tap-postgres