We noticed that HVR is trimming trailing whitespaces by default when we move data between our Source (SQL Server) and Target (Snowflake) systems.
We have a few columns in the source data where leading and trailing whitespaces do have a business value. During testing, we found that although we have no specific channel actions to remove whitespaces, by default the trailing whitespaces are getting removed.
How do we preserve leading and trailing white spaces when ingesting data by HVR?