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 ...
Forum Discussion
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
