Category
How To: Scroll through a query result set with several million rows
FAQ: Solution If you run a query and the result set comes back with more than a million rows, the UI will only retrieve the first 1 million rows.
Oracle - SQL*Plus
Reads a line of input and stores it in a given substitution variable..
Code Conversion - Redshift Issues
Set “configuration parameter” is not supported in Snowflake. Severity Medium Description The SET configuration parameter clause in Redshift procedures is not supported in Snowflake. Snowflake uses ALTER SESSION SET or session - level…
Oracle - SQL*Plus
Reads a line of input and stores it in a given substitution variable..
How to scan Result set in stored procedures
FAQ: Cursors can be useful in stored procedures to loop through the records from SELECT statements for several business needs in ETL batches or other flows.
Causally grounded Cortex Agent that refuses when the data cannot answer: code
Every file in the Causally grounded Cortex Agent that refuses when the data cannot answer recipe. To run the recipe, download agent - causal - grounding.zip, unzip it, and run the scripts from the agent - causal - grounding/ folder as the recipe…
Oracle - PL/SQL to Javascript
This is a translation reference to convert PL/SQL statements to snowflake JavaScript Collections & Records NoteSome parts in the output code are omitted for clarity reasons.