Hi all, for the MySQL source connector, why JSON is emitted as a String and got committed in my Snowflake destination as VARCHAR(). If this is how it works, how can I convert it to JSON? and I think there is also a limit of characters for VARCHAR in case of a long JSON, right?

Hi Anurag, please read through our code of conduct. We use threads for discussion, this means one question per thread: Rule 8: Use threads for discussion. The simplest way to keep conversations on track in Slack is to use threads. The Airbyte Slack community relies heavily on threads, and if you break from this convention, rest assured one of our community members will respectfully inform you quickly! Yes, JSON is serialized as strings. Check out this discussion: https://discuss.airbyte.io/t/issue-with-long-json-field-and-mysql-source/1566/3?u=natalyjazzviolin

So how to resolve this and store it as json in snowflake?

Unfortunately that's not how our connector works at the moment. I suggest you look into dbt to transform the data as you see fit!

dbt is something new for me

Please make sure to read the documentation. Here is one doc, but there are more on this topic: https://docs.airbyte.com/operator-guides/transformation-and-normalization/transformations-with-dbt/

Hey @Anurag Jain, Any luck ? I am also stuck with same issue, let me know if you find something