01-07-2022 10:15 AM - edited 01-10-2022 08:52 AM
Receive the following error upon running a workflow when trying to update Snowflake using Bulk Connection:
Output Data (9) The COPY failed with error: End of record reached while expected to parse column '""nt_00521203e""["Field2":2]'¶ File 'nt_00521203e_d70f642206794be38ffbf7c70e258809/nt_00521203e_49bf6e1bf5ad4b9597ba235f099b531d.gz', line 2, character 2¶ Row 2, column ""nt_00521203e""["Field2":2]¶ If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client.
Defect GCSE-328 is target for resolution in future release.
Add the Data Cleansing tool to remove the leading/trailing whitespace and tabs/line breaks/duplicate whitespace.