我们有一个存储过程,它会改变会话并将查询标签参数设置为某个值。当该存储过程直接通过调用语句调用时,查询标签被设置,但是当通过任务调用该存储过程时,查询标签没有被设置。请提供建议。
CREATE OR REPLACE TASK mytask
WAREHOUSE = COMPUTE_WH
SCHEDULE = '1 minute'
AS CALL dummy();
create or replace procedure dummy()
RETURNS VARCHAR(50)
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
as $$
snowflake.execute( {sqlText: "ALTER SESSION SET QUERY_TAG = 'execute_dummy_proc'" } );
var sql_command = "INSERT INTO mytable(ts) VALUES(CURRENT_TIMESTAMP())";
snowflake.execute ({sqlText: sql_command});
$$;