You can translate the question and the replies:

Creating A Base View On Snowflake Stored Proc/ Multiple Statements

Hi, 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 SELECT * FROM table(result_scan(last_query_id(-2))); Any help will be much appreciated. Kindest regards Prateek
user
21-07-2020 17:04:41 -0400

1 Answer

Hello, Virtual DataPort provides the capability of creating base views graphically over the stored procedures for most of the JDBC data sources as mentioned [here](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#importing-graphically-stored-procedures-from-a-database). And for other databases and also in case of Snowflake, you can do it by using the option “creating a base view from a query”.I would recommend you to look into the [Create base view from SQL queries](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries) section of Virtual DataPort Administration Guide which explains the topic in detail. Hope this helps!
Denodo Team
22-07-2020 18:04:16 -0400
You must sign in to add an answer. If you do not have an account, you can register here