snowflake db stored procedure

Question

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.