'How to persist resultset in Snowflake Stored Procedure written in Javascript?
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 read of results
while (results.next())
{
script += results.getColumnValue(1);
}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
