How to identify the exact SQL query sent to source system?

Hello,

I have a loading process that is not working as expected. It has been done as many other processes are working correctly, but this one is not.

The problem is that in the Data Monitoring, in the Remote Queries section, the parameterised SQL statement is shown. This is

SELECT … FROM … where “_load_date” > CAST( ? AS TIMESTAMP)

, where the ? will be replaced by a timestsamp which is calculated in a table function SQL view.

While I can know the calculated TIMESTAMP, I don’t see the one that is actually sent to the data source, and it looks like something is wrong with that, since I’m getting data that doesn’t match the where filter.

I haven’t seen any way to know what time stamp was sent in the where, neither in the monitoring, nor in the data flow logs, which makes me totally lost and the process out of control.

Does anyone have any idea where I could find it?

Thanks.