Hi everyone I have tried Airbyte from MySQL to Snowflake transformation. Data successfully synced to destination even Full Sync and CDC. But VARCHAR that has collation UTF8_bin columns transform to base64 string. I know that is correct work. I want to transform VARCHAR(collation UTF8_bin) to String or VARCHAR. But can i change the mapping type or another way? My English is really bad. sry :(

Hi! No worries about English - I understood everything 🙂 The best way to do this is probably with dbt transformations, have you looked into that? Here's a doc: https://docs.airbyte.com/operator-guides/transformation-and-normalization/transformations-with-dbt/

Thank you, Nataly. I have seen that doc! I just passed it because i don't have any experience in dbt. now I try dbt. Thanks again

No problem!