Q: New line character I'm trying to load the data into snowflake. My source is Oracle DB. I'm creating CSV files into multiple chunks and uploading it into azure BLOB. From Azure Blob to snowflake. In DB it has the data of text for CLOB data type columns. I'm using '\n' as a row separator in BDM, and I'm replacing '\n' with empty quotes. So, I can able to load the data into CSV files. The challenge here I'm facing is, I'm getting the data into a single row of a particular column. But I need the data looks like in multiple row as it is in the DB.
