Loading

snowflake db stored procedure

swapna jamalpur

Hi,

CREATE OR REPLACE PROCEDURE simple_stored_procedure_example()

RETURNS VARIANT

language javascript

as

$$

var cmd = "select count(*) from TEMP.PUBLIC.TEMP_FCT_DAY_DRVR_TIMESHEET"

var sql = snowflake.createStatement({sqlText: cmd});

var result = sql.execute();

return result;

$$;

call simple_stored_procedure_example();

here, i want to return the row count but i am getting result as [object object]. i need integer value.

please help.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Varun Setia5y ago
You need to move the cursor using result.next() and get the column values store that in an array and return the array as new result variable.
Varun Setia5y ago
Hi, check the examples here, https://docs.snowflake.com/en/sql-reference/stored-procedures-usage.html#examples