Forum Discussion

Fischerd's avatar
Fischerd
New Contributor
7 years ago

Viewing SQL generated by a Snap

Is there a way I can view the exact SQL that is generated by a pipeline? I am debugging a pipeline that uses the Oracle - Execute snap. The results from the generated SQL are not what I am expected and I would like to be able to see what statement is being run, so I can fix my mistakes

Thank you in advance
Dan

1 Reply

  • jcampion's avatar
    jcampion
    New Contributor III
    7 years ago

    Hi Dan,
    Usually I use a mapper before the SQL snap to construct the query and put it in a $sql_query field. Change the SQL snap to use $sql_query. That way, I can grab it during preview and use it directly against the database.
    Hope that helps,
    Judy