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

[Mindaugas83]

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

[Alex_Combessie]

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