'SnowSQL (Snowflake) query result with newline
I've got the results of a Snowflake query which produces a newline '\r\n' (Char(10),Char(13)). When this runs in the web GUI the results look like a Yaml file. (With newlines). When run in the SnowSQL CLI and output to a file "test.yml" it returns all lines in 1 with the '\r\n' instead of a newline. Has anyone encountered similar?
Thanks, Dan
Solution 1:[1]
replacing "\r\n" with "\n" works in CLI.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Dan |