Creating A Base View On Snowflake Stored Proc/ Multiple Statements

188 Views Asked by At

I was wondering if you could tell me if there was a way to create a base view on snowflake stored procs.

What I am trying to do is:

Run the stored proc Capture the result of the proc The Snowflake statments are like these:

—–CALLING THE PROC
CALL DB_NAME.SCHEMA_NAME.PROC_NAME(‘Param1’, ‘Param2’, ‘Param3’, ‘Param4’);

—-CAPTURING THE RESULT
SELECT *
FROM table(result_scan(last_query_id(-2)));

Any help will be much appreciated.

Thank you in advance.

0

There are 0 best solutions below