SSL error when syncing MongoDB to Snowflake using Airbyte

Summary

When trying to sync MongoDB to Snowflake using Airbyte with Incremental loading, encountering SSL handshake error. Full refresh works without error. Also, seeking information on how to handle orphaned threads in Snowflake destination connector.


Question

Hello,
I’m trying to test MongoDB (self hosted replicaset) to Snowflake sync using Airbyte but getting SSL error mentioned below. This happens when I am using Incremental (Append + Deduped) but when I use Full Refresh (overwrite) I don’t get this error and sync goes through. I would like to know

  1. What I would need to do for working with Incremental loading
  2. Why this succeeds for full refresh
    Mongo DB Error:
    Exception sending message, caused by {javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target}, caused by {sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target}, caused by {sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target}}]
    Also I’m getting a warning for Snowflake destination connector about closing children threads. Is there any parameter which I can set so that all children threads are killed before main thread exists?

Snowflake Warning:

Ideally, this situation should not happen...
Please check with maintainers if the connector or library code should safely clean up its threads before quitting instead. ```
Any help/resources would be helpful here. Thank you.

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1715091356336519) if you want to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["mongodb", "snowflake", "airbyte", "ssl-error", "incremental-loading", "full-refresh", "ssl-handshake", "orphaned-threads"]
</sub>