雪花存储过程是用javascript编写的，它可以通过调用javascript api来执行sql语句。此api类似于雪花连接器和驱动程序（node.js、jdbc、python等）中的api，但不完全相同。
细节：https://docs.snowflake.com/en/sql-reference/stored-procedures-usage.html#implementation-及空气污染指数
您可以找到几个代码示例：https://docs.snowflake.com/en/sql-reference/stored-procedures-usage.html#examples

请看一下文档中使用存储过程的步骤。
这是一个应该编译的粗略存根。我无法测试代码，因为我没有用于验证表或数据的ddl，但这应该给您一个好的开始。
顺致敬意，

CREATE OR REPLACE PROCEDURE SAMPLE_PROC()
returns VARCHAR not null
language javascript
as 
$$

var businessUnitKey , loadDate, dataLoadLogKey, sql,  statement, rs, message ;

message= "FAILED";

// get business unit key
sql = `SELECT BusinessUnitKey FROM BusinessUnit WHERE BusinessUnitName='ABC'`;
statement = snowflake.createStatement({sqlText: sql});
result_set = statement.execute();

while (result_set.next())  {
    businessUnitKey = result_set.getColumnValue(1);
}
// get load date 
sql = `SELECT Cast(SYSDATE() as Date)`;
statement = snowflake.createStatement({sqlText: sql});
result_set = statement.execute();
while (result_set.next())  {
loadDate = result_set.getColumnValue(1);
}

//return loadDate
sql = `SELECT MAX(DataLoadLogKey)  
   FROM DataLoadLog  
   WHERE BusinessUnitKey = ` + businessUnitKey + `;` 
statement = snowflake.createStatement({sqlText: sql});
result_set = statement.execute();
while (result_set.next())  {
dataLoadLogKey = result_set.getColumnValue(1);
}

var TableName       = 'ProductType'  
  ,StoredProcName   = 'SAMPLE_PROC()'
  ,StarDateTime     = LoadDate  
  ,EndDateTime      = NULL  
  ,Status           = 'In Progress'  
  ,LoadDescription  = 'Loading Data'  ;

sql = `CALL dbo.usp_procedure(:1,:2,:3,:4,:5,:6,:7); `
statement = snowflake.createStatement({
        sqlText: sql,
        binds: [dataLoadLogKey,TableName,StoredProcName,StarDateTime,EndDateTime,Status,LoadDescription]
    });

message= "SUCCESSFUL";
return message;

$$;

call SAMPLE_PROC();