[source-snowflake] Issue with Data Type Mismatch for [source-snowflake] to [destination-postgres] connection

[Subhash-123]

Connector Name

source-snowflake

Connector Version

0.3.4

What step the error happened?

Other

Relevant information

I recently set up a connection from Snowflake (using airbyte/source-snowflake-0.3.4) to Postgres (using airbyte/destination-postgres-2.4.0) and ran a sync. However, I've encountered an issue where the data types in the destination table columns do not match the data types in the source.
I've attached screenshots and the sync log for your reference. Could you please assist us in resolving this issue?

Relevant log output

Actual datatype in source snowflake and datatype in destination are given below.
Tags Array -> Tags Varchar
Metadata Object -> Metadata Varchar
profile Variant -> Profile Varchar
I believe these values should be jsonb in postgres

Contribute

• Yes, I want to contribute