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

Options
Mindaugas83
Mindaugas83 Registered Posts: 1 ✭✭✭✭
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
Tagged:

Answers

  • Alex_Combessie
    Alex_Combessie Alpha Tester, Dataiker Alumni Posts: 539 ✭✭✭✭✭✭✭✭✭
    Options

    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

Setup Info
    Tags
      Help me…