Pass argument to the Snowflake procedure
In this video , I have discussed about how to pass argument to a stored procedures in snowflake data warehouse database.
Code used :
create or replace procedure read_result_set1(department Varchar)
returns float not null
language javascript
as
$$
var my_sql_command = "select sum(salary) from DEMO_DB.PUBLIC.EMPLOYEE where department ='"+DEPARTMENT+"'";
var statement1 = snowflake.createStatement( {sqlText: my_sql_command} );
var result_set1 = statement1.execute();
result_set1.next()
return result_set1.getColumnValue(1); // Replace with something more useful.
$$
;
Prerequisite:
• How to create a stored procedure | Snowfla...
Check this playlist for more AWS Projects in Big Data domain:
• Demystifying Data Engineering with Cloud C...