RE: How to load Newline data from Snowflake source to Snowflake Target?

How to load Newline data from Snowflake source to Snowflake Target?

TommyM Beginner Asked on July 16, 2019 in Diyotta Studio.
Add Comment
2 Answers

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”.

RE: How to load Newline data from Snowflake source to Snowflake Target?

Script Generation:

Here, for new line column the query will be generated with Replace function for all char, nchar, text, Varchar Datatype as show below:

RE: How to load Newline data from Snowflake source to Snowflake Target?

 

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:

RE: How to load Newline data from Snowflake source to Snowflake Target?

Execution:

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.

Expert Answered on July 16, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.