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:
1. Run the stored proc
2. Capture the result of the proc
The Snowflake statments are like these:
-----CALLING THE PROC
CALL DB_NAME.SCHEMA_NAME.PROC_NAME('Parm1', 'Parm2', 'Parm3', 'Parm4');
----CAPTURING THE RESULT
Any help will be much appreciated.