snowflake-cli
snowflake-cli copied to clipboard
SNOW-2149992: `--format json` cannot represent some result column types
SnowCLI version
Snowflake CLI version: 3.9.1
Python version
Python 3.13.4
Platform
macOS-15.5-arm64-arm-64bit-Mach-O
What happened
Some column types cause JSON output to be truncated.
Specifically, if the result-set includes columns of types FLOAT, TIME, or BINARY, the JSON output is truncated, and therefore invalid.
Console output
[
{
"FLOAT_COL":
How to reproduce
snow sql --format json -q "SELECT 3.14159 as float_col"