Relative Content

Tag Archive for snowflake-cloud-data-platform

Snowflake Cortex LLM functions throwing error

I’m trying to run a Streamlit app to make a chatbot using Snowflake Cortex LLM function. Apparently there is an access problem with the llm functions.
This is the error I’m getting.

Need to display 0 with Column value name if the column value in 0 or null in snowflake

ex – I have a column called column1 .It has multiple values like 15 or more values in it.I need to pick only 4 values(AAA,BBB,CCC,DDD alone) in that for my calculation .These 4 values may be null or 0 and due to that i get the sum of these as 0 or null .
I need to display all the 4 values in query output if the sum is 0 or more as independent row.If the sum is 0 then it should show 0 in count column.