Skip to content

Snowflake Guide

Eric's another Big Data Blog

Primary Menu
  • Home
  • About Me
  • |
  • SQL
  • Security
  • JDBC

Tag: Decimal

Decimal Values are Converted to Integer Values

Posted on 25 January 202124 May 2021 by Eric Lin

Today, I have learnt that Snowflake will convert decimal values to integer values if all trailings are zeros. Please see below examples: It returns: The same applies to PARSE_JSON: It returns: Instead of: After researching with our team, it turned out that it was expected behaviour. In fact, Snowflake has been behaving this way for […]

Continue Reading
Eric Lin
Principal Cloud Support Engineer
@ Snowflake
Blogger | Runner | Ex-Cloudera
3 x SnowPro
Snowflake | Monash University
View Profile

Friendly Links

  • Cloudera Troubleshooting
  • RAYNIX 筆記

Recent Posts

  • How to Merge Variant columns in Snowflake
  • SQLCODE returns 0 in the catch block even the query failed due to invalid identifier
  • String object in Javascript UDF does not have the replaceAll() function
  • Create View Automatically From VARIANT Columns
  • Find Child Queries of a Stored Procedure
All rights reserved!
Copyright All rights reserved | Theme: Advance Blog by WPinterface.