Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Hi Team,

I am trying to copy mssql data to snowflake database using airbyte. My connection is fine, after the sync is done my source data has not copied as it is to the snowflake destination.

Following describes my settings.
*Transformation*: Raw data (JSON)

Source MSSQL data has a column called *ContentHash* and it contains data like below
0x47326255F46785C89D1F7DA
0x916D001C7A7B06F50B9DAA

After I sync data from airbyte connection I can see following data in my snowflake tables related to the ContentHash table
G2bU�g�ȝ}��L�)�X�W{
G2bU�g�ȝ}��L�)�X�W{

I believe, this is because of the default encoding of the COPY INTO command in airbyte snowflake connector.
<https://github.com/airbytehq/airbyte/blob/v0.44.4/airbyte-integrations/connectors/destination-snowflake/src/main/java/io/airbyte/integrations/destination/snowflake/SnowflakeInternalStagingSqlOperations.java#L30|https://github.com/airbytehq/airbyte/blob/v0.44.4/airbyte-integrations/connectors/[…]estination/snowflake/SnowflakeInternalStagingSqlOperations.java>

Is there a way to fix this?

Hmm, I don't know enough to give you a confident answer yet. However, you might find some helpful information in the [Airbyte documentation](<https://docs.airbyte.com>) or the [Airbyte tutorials](<https://airbyte.io/tutorials>).