Postgres to Snowflake connection disappearing and strange errors

Summary

The user is facing issues with a Postgres to Snowflake connection in Airbyte open source edition. The connection fails after running for a while, and the Postgres connection disappears from Airbyte. When trying to reconfigure, strange errors occur. The user has resorted to creating a new EC2 host in Amazon to start over, but the issue persists.


Question

Hi Community - I’m working with Airbyte open source edition. I’m able to create a Postgres to Snowflake connection for CDC. However, it fails after running for quite a while, and then my Postgres connection ‘disappears’ from Airbyte. When i try to go back in to reconfigure it, i get strange errors when trying to save / test the connection. So far, the only way I’ve been able to ‘start over’ has been to create a completely new EC2 host in Amazon. Even in doing that, once I get the connection up and running again it ultimately fails/disappears/can’t be re-created. Anybody else dealing with this?

{}```
```{
  "url": "<http://localhost:8000/workspaces/967a19f3-0095-4d19-9946-5c6547109ca8/source/new-source/decd338e-5647-4c0b-adf4-da0e75f5a750>",
  "airbyteVersion": "0.58.1",
  "errorType": "TypeError",
  "errorConstructor": "TypeError",
  "error": {},
  "stacktrace": "TypeError: Cannot read properties of undefined (reading 'toLowerCase')\n    at Kze (<http://localhost:8000/assets/WorkspaceAccessManagementSection-d0GDnGG6.js:109:79733>)\n    at renderFooter (<http://localhost:8000/assets/ConnectorCard-XMp7MsQ7.js:1:8249>)\n    at Hy (<http://localhost:8000/assets/ConnectorForm-2BVuUdXj.js:6:256302>)\n    at ec (<http://localhost:8000/assets/index-WZJAPYia.js:38:19519>)\n    at es (<http://localhost:8000/assets/index-WZJAPYia.js:40:3139>)\n    at nh (<http://localhost:8000/assets/index-WZJAPYia.js:40:44737>)\n    at Jv (<http://localhost:8000/assets/index-WZJAPYia.js:40:39727>)\n    at k_ (<http://localhost:8000/assets/index-WZJAPYia.js:40:39655>)\n    at Ya (<http://localhost:8000/assets/index-WZJAPYia.js:40:39508>)\n    at fs (<http://localhost:8000/assets/index-WZJAPYia.js:40:35875>)",
  "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36",
  "featureFlags": {}
}```


<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/p1715359078578399) if you want to access the original thread.

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

<sub>
["postgres", "snowflake", "cdc", "connection-issue", "error", "airbyte-open-source", "ec2", "amazon"]
</sub>