python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - snowflake-cloud-data-platform

Snowflake DIV0 returns different result than regular division

Why are these results different, comparing Snowflake division vs DIV0? It appears DIV0 is rounding down instead of up. Is there any way to make the DIV0 return the same number as the other results? Sn...
test-img

inthe763

snowflake-cloud-data-platform

Votes: 0

Answers: 1

Latest Answer

Another way you can implement NVL based approach set num=75026; set den=0; select iff($den=0,0,$num/$den)
test-img

Radagast

Snowflake and Data Factory Error because of regions

Im getting an error when running Data Factory to load data into Snowflake: ErrorCode=SnowflakeUnsupportedCouldPlatformForImport,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Messa...
test-img

Ivonne Roche

snowflake-cloud-data-platform

azure-data-factory

blobstorage

Votes: 0

Answers: 1

Latest Answer

In my case going to the warehouse you have configured and enabling "Auto Resume" solved the issue for me. Hope this helps someone running into this same issue.
test-img

Ryan Goodman

How to merge table in snowflake using snowpark scala

I have a table named SOME_SNOWFLAKE_TABLE in snowflake I want to Merge SOME_SNOWFLAKE_TABLE with another table SOME_TARGET_TABLE in snowflake. Below is the approach provided in snowflake documentation...
test-img

Dineshvarma Guduru

scala

snowflake-cloud-data-platform

Votes: 0

Answers: 0

Declaring Dates and Nulls in function calls

When I call a function eg SELECT * FROM TABLE(FN_ABC(NULL::DATE , '2022-04-07'::DATE )) Snowflake forces me to bind the parameters Im passing to a datatype eg DATE and for all NULLs as above. Is the...
test-img

Leon

function

parameter-passing

snowflake-cloud-data-platform

Votes: 0

Answers: 1

Latest Answer

your sql is not two dates, it's an undefined type, and a string/text/varchar. select null as a ,'2022-04-07' as b ,system$typeof(a) as t_a ,system$typeof(b) as t_b ,a::date as d_a ...
test-img

Simeon Pilgrim

Posts

Questions

Blogs

Jobs