I have a stored procedure that runs a sql command then it is run multiple times to call it multiple times. Is there a way to persist the resultSet so as not to run the snowflake query multiple times?
Currently
var my_sql_query = ` select * from table`;
var results = snowflake.execute({sqlText: my_sql_query});
while (results.next())
{
script += results.getColumnValue(1);
}
... other script additions ...
// Second Run of the same script
var results = snowflake.execute({sqlText: my_sql_query});
while (results.next())
{
script += results.getColumnValue(1);
}
Desired Output (as best as I can describe)
var my_sql_query = ` select * from table`;
var results = snowflake.execute({sqlText: my_sql_query});
while (results.next())
{
script += results.getColumnValue(1);
}
// Second Run of the same script
while (results.next())
{
script += results.getColumnValue(1);
}