Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

MS SQL stored Procedure working fine in SQL notebook but not in SQL recipe

arpitgupta02
Level 1
MS SQL stored Procedure working fine in SQL notebook but not in SQL recipe

Hi,

I am trying to execute MS SQL stored procedure in DSS to create a dataset from connection, It works fine in SQL notebook but from there we cannot create a dataset in flow so I want to execute it as a SQL recipe but there my Stored procedure is giving error, Invalid object name.

Can somebody help what can be the issue as I am running same SQL stored procedure for running at both places.

0 Kudos
0 Replies