Delimiter issue – Copying Data from Azure SQL to Snowflake

I am trying to load data from Azure SQL to Snowflake. I am under the constraint to use the copy activity only.
I am using a lookup table to reference a metadata table with the source schema, source tables, target schema, and target tables.
I am then using a For Each Activity to iterate through the metadata table.
I’m using two copy activities inside of that – one to move the data from SQL to Blob and the other to move the data from Blob to Snowflake. I am getting an error « « Found character C instead of delimiter ‘,’ «. I have tried using different delimiters but my data consists of those characters.
Is there a way to resolve this, in a way to use a specific file format on the snowflake end before the copy activity takes place( cannot write a script as the storage account is in West US2 and Snowflake account is in East US2).

Any help is greatly appreciated!!!!

Thank you.

Tried using different delimiters.