MS SQL stored Procedure working fine in SQL notebook but not in SQL recipe
arpitgupta02
Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1 Partner
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.