0 votes
I'm looking to use a project variable in the SQL TRigger for a scenario.  SQL works fine without the project variable.

The following works fine:

SELECT MAX(process_id) FROM DBO.PROCESSCONTROL
WHERE business_id = 'BOB'

but this stops if I change to:

SELECT MAX(process_id) FROM DBO.PROCESSCONTROL
WHERE business_id = '${variable1}'

and project global project variable as:

{
  "variable1": "BOB"
}

Am I doing something wrong or are global project variables not allowed in Scenario SQL Triggers?

Thanks for any help.
by
Hi matt,

The use of project variables inside of scenario steps is allowed and supported. Please post your logs to see the error you're getting.

Thanks!

Please log in or register to answer this question.

1,322 questions
1,342 answers
1,543 comments
11,891 users

©Dataiku 2012-2018 - Privacy Policy