You can translate the question and the replies:

How to import snowflake stored procedures in Denodo

We can't able to import snowflake stored procedures into Denodo , can you please let us know if any work around .
user
21-06-2021 08:05:38 -0400
code

3 Answers

Hi, here is the knowledge base for Snowflake and you can find a way to create base views here. [How to connect to Snowflake from Denodo](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Snowflake%20from%20Denodo) If you are trying to import (SQL Based) stored procedures created in Snowflake into Denodo, then the document below might help. [Creating Base Views from SQL Queries](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries) After verifying, you can also check vdp.logs located in <DENODO_HOME>/logs/vdp/ to find exact errors. Hope this helps!
Denodo Team
23-06-2021 22:01:30 -0400
code
Creating Base Views from SQL Queries , when i go through the link its redirected to Importing Graphically Stored Procedures from a Database. and Creating Base Views from a Query to a Stored Procedure from the above question shared informaion related to • IBM DB2: see section Importing Stored Procedures from IBM DB2. • Microsoft SQL Server: see section Importing Stored Procedures from Microsoft SQL Server. • Oracle: see section Importing Stored Procedures from Oracle. Not Snowflake .. can you please do the needfull
user
23-06-2021 22:12:12 -0400
Hi, you can connect to Snowflake from Denodo and create base views with query option to use the command to invoke the stored procedure. Also, I went through the manual and understand that only DB2, Oracle and SQL Server are supported for stored procedure graphically. So if you need more help and have a valid support account, you can open a new case in the Support Site so the Denodo team can help you. [Using the Create Base View From Query Option](https://community.denodo.com/kb/en/view/document/Using%20the%20Create%20Base%20View%20From%20Query%20Option) Hope this helps!
Denodo Team
01-07-2021 06:12:46 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here