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.
How to properly split a snowpark table based on a column value?
I’m just starting out with Snowpark Java API, trying some basic operations.
Automate process of accept requests to our native app in marketplace
At my company, we are developing a native app that we want to publish publicly on the marketplace. However, we want to restrict access to the app so that only customers who are part of our company can access it.
How to do find and replace within the Snowflake online editor on macOS?
In the editor we can use CMD–F to find text. What is the shortcut to do find and replace? I have tried a number of things: most of these are swallowed/used by chrome itself:
Syntax error: unexpected ‘DELETE’ trying to do a simple delete
I’m trying to test a small script in snowflake that performs housekeeping on a couple of tables, but the script is terminating with Syntax error: unexpected 'DELETE'
error.
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.
How to set up a constraint on a column for a value to be greater than a number?
Normally, we could use a syntax such as age Integer CHECK (age > 0) but Snowflake gives an Error.
What is the alternate for the “CHECK” constraint on a column value in Snowflake if possible?
Invalid OAuth access token — Snowflake
I generated the Public Key & assigned to the user USER1 it when I describe the user it shows the RSA_PUBLIC_KEY assigned to the user,
Syntax error: unexpected ‘SELECT’ in a simple query
I have a problem with a very simple piece of code, and I am hoping someone can tell me where I have gone wrong – the code is
Error declaring multi-line varchar variable in Snowflake procedure
I’m trying to declare a procedure in snowflake that uses dynamic sql to create a path for file output. My statement is: