Community Conundrum 25:Feature Visualization is now live! Read More

When creating dataset in dataiku from ms sql query it shows an error that parameter @someparameter is not defined

Level 1
When creating dataset in dataiku from ms sql query it shows an error that parameter @someparameter is not defined
When creating dataset in dataiku from ms sql query it shows an error that parameter @someparameter is not defined, but it is defined in front of query. Is there any way to create dataset in dataiku from sql query with parameters?

Regards,

Mindaugas Valaitis
0 Kudos
1 Reply
Dataiker
Dataiker

Hello,



For such advanced SQL scripts with variables, we recommend using an "SQL script" recipe (in the flow) instead of an SQL query dataset. You can see an example below:





 



For creating an "SQL script" recipe you can choose as such:





Note that your recipe would not require an input dataset.



Cheers,



Alex

0 Kudos
Labels (1)