Forum Discussion

rpc1235x's avatar
rpc1235x
New Contributor II
2 years ago
Solved

How to output the SQL statement that was executed in Snowflake - Execute pipe?

Hello, I have designed this pipeline that: Generate a month range as $date_1 and $date_2 These variables are inserted into a SQL statement in the "Snowflake - Execute" pipe Then this is inserted...
  • Aleksandar_A's avatar
    2 years ago

    Hello rpc1235x,

    You can produce the query string in the Datetime Fixer Mapper, and pass it as is to the Snowflake Execute Snap with Pass Through enabled.

    That way you will have the query string in the original attribute downstream.

     

    Regards,

    Aleksandar.