snowflake-cli icon indicating copy to clipboard operation
snowflake-cli copied to clipboard

SNOW-2149992: `--format json` cannot represent some result column types

Open mdub opened this issue 10 months ago • 0 comments

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"

mdub avatar Jun 12 '25 09:06 mdub