How to load Newline data from Snowflake source to Snowflake Target?
To load New line data from source to target in snowflake, we can use ‘LF in STRING’ property
Select the Snowflake source go to Extract Properties and make LF in String option as “ON”.
Here, for new line column the query will be generated with Replace function for all char, nchar, text, Varchar Datatype as show below:
If Extract type is Bulk Export, using GET command it pull the data from the snowflake Database
If Load type is Bulk Import, using PUT command it loads the data to the snowflake Database
while copying the data into target when LF in String option is enable for the new line data,s the script will be generated with Replace function by interchanging the previous char(lengths) as below:
Execute/Run the Data flow for the above design and view the target data. Here, we can observe data is loaded as expected for the newline.