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

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