SNOW-506725: Add support for NUMBER

[Bohdan-Bulavkov-Imprivata]

No enum constant net.snowflake.client.jdbc.SnowflakeType.NUMBER java.lang.IllegalArgumentException: No enum constant net.snowflake.client.jdbc.SnowflakeType.NUMBER at java.base/java.lang.Enum.valueOf(Enum.java:273) at net.snowflake.client.jdbc.SnowflakeType.valueOf(SnowflakeType.java:18)

[sfc-gh-mknister]

Hi @Bohdan-Bulavkov-Imprivata , what is the context behind this? Why is support for NUMBER needed? Can you give an example?

[Bohdan-Bulavkov-Imprivata]

Hi @sfc-gh-mknister I have a view where I use function array_size(event_data:steps) AS number_of_factors. The type of this field is NUMBER(9,0) which I can see from UI. When I try to execute SnowflakeType.valueOf() I get the error above. I would expect SnowflakeType to have each field that Snowflake supports.

[wesleyhillyext]

I suspect that nowflakeType.FIXED is meant to represent the NUMBER type. (As in fixed-point arithmetic).

[sfc-gh-dszmolka]

closing this issue per above comment, but please do comment if there are still open concerns and can reopen