is it possible to call the javascript procedure API within a UDF?

1
votes

I suppose the answer is "No".... but it would be quite handy if I could call the "Stored Procedure API" from within a UDF...

Is it possible?

If I put code like 

  var my_statement = snowflake.createStatement( {sqlText: my_sql} );

I get an error "JavaScript execution error: Uncaught ReferenceError: snowflake is not defined in..."

1
snowflake-cloud-data-platform

1 Answers

1
votes

You are correct that it is not supported. You are welcome to post on the Snowflake Ideas forum as a feature request: https://community.snowflake.net/s/ideas