Possible BUG with SQLTrigger

Options
tim-wright
tim-wright Partner, L2 Designer, Snowflake Advanced, Neuron 2020, Registered, Neuron 2021, Neuron 2022 Posts: 77 Partner

This is somewhat related to the issue noted here: about not being able to access a the name or type of a scenario trigger but it is more specifically about the results returned by a SQLTrigger.

In the documentation it states that "SQL triggers pass the output of the query" to other Scenario steps.

However I only see metadata about the triggering query (and not the actual output from the query). I'm not sure if that is expected behavior and I wrongly interpreted the documentation OR if it may be a minor bug.

Below from a call to Scenario().get_all_variables() from within a python Scenario Step (reformatted a bit and removing some project and global variables).

sqlTriggerOutput.PNG

Also related to this user question by @Tim86
here.

Answers

  • NedM
    NedM Dataiker Posts: 8 Dataiker
    Options

    Hi Tim!

    Thank you for bringing this up, and apologies for the delayed reply!

    I've run some tests on DSS 8.0.3, and can confirm that I obtain the same results as you; specifically, I have been unable to retrieve the results of the SQL query trigger.

    I will continue investigating, and will update you if I find a solution. If I don't find one, I will report it to our product team for further investigation.

    In the meantime, one potential workaround would be to re-submit the same query from a "Execute SQL" step in the scenario, or using the SQLExecutor class of the DSS python APIs in a "Execute Python Code" step.

    Again, thank you very much for bringing this to our attention

    Ned

Setup Info
    Tags
      Help me…