View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005756 | SymmetricDS Pro | Bug | public | 2023-03-23 18:52 | 2023-05-05 13:12 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.6 | ||||
| Target Version | 3.14.7 | Fixed in Version | 3.14.7 | ||
| Summary | 0005756: Snowflake Bulk Loader fails to load values with special characters | ||||
| Description | When loading Snowflake using the COPY INTO mechanism, when a value has special characters like double quotes (optional value wrapper), pipe symbols (field delimiter), or carriage return/newlines (row terminator), it messes up the reading of the bulk loader file into Snowflake. We need to deal with those special characters by escaping them in some way, and we also need to process null values and empty values correctly. | ||||
| Additional Information | Wrap values with double quotes, escape double quotes with double double quotes, and provide a "\\N" value to represent null values, and tell the file format that empty value is an empty string not a null value. | ||||
| Tags | dialect: snowflake | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-03-23 18:52 | pmarzullo | New Issue | |
| 2023-03-23 18:52 | pmarzullo | Status | new => assigned |
| 2023-03-23 18:52 | pmarzullo | Assigned To | => pmarzullo |
| 2023-03-23 18:52 | pmarzullo | Tag Attached: dialect: snowflake | |
| 2023-03-23 20:54 | pmarzullo | Status | assigned => resolved |
| 2023-03-23 20:54 | pmarzullo | Resolution | open => fixed |
| 2023-03-23 20:54 | pmarzullo | Fixed in Version | => 3.14.7 |
| 2023-05-05 13:12 | emiller | Note Added: 0002317 | |
| 2023-05-12 19:49 | admin | Status | resolved => closed |