This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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
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
