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


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.

Setup Info
      Help me…