Destination Snowflake version 0.4.24: KeyError: 'password' - Normalization failure

Connector Questions & Issues
,
1

Is this your first time deploying Airbyte : No
Deployment : Docker
Airbyte Version : 0.35.3-alpha
Source name/version : PostgreSQL / Redshift
Destination name/version : Snowflake
Step : Loading from temp tables
Description :
Hi all, I am experiencing this issue as I start to set up my connection to Snowflake via Airbyte. I was loading normally before using Redshift and PostgreSQL as my sources, but decided to make changes to the destination structure (rename database, etc.) and updated the connections in Airbyte accordingly. Now experiencing this issue with both sources, which seems to arise with the Snowflake connection after the staging tables load and while they are trying to load to production tables. Basic normalization is selected.

Testing the destination connection has no issues and Snowflake support saw no error show on their end. I had updated the source connectors late last week and wonder whether that has had an impact. Any advice would be a huge help - thank you!

logs-68-0.txt (527.8 KB)

2

@kev1021 can you upgrade Airbyte version to 0.35.60+?
There is a chance in Snowflake connector that impacts normalization.

3

Hi @marcosmarxm sure thing, thanks for the quick response. I will try this tomorrow and follow up

4

Kevin afetr upgrade the issue is solved?

5

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.