Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Updates not showing

Hi, The table Update step doesn't seem to show an accurate reflection of the number of updates that occurred. Is this by design?

I know the JDBC makes this information available as I get confirmation on the number of updates when using my SQL Client DBeaver.

2 Community Answers

Matillion Agent  

Kalyan Arangam —

Hi Anthony,

I understand this can be misleading. The component provides 3 row counts, we export all of them via variables. None of them really make sense being used as a total on their own, nor does summing them particularly.

I have raised an internal ticket (EMD-5145) to either come-up with a better way of displaying the results or do-away with displaying the total.

If you’d like to make use of the row-counts for some auditing purposes, please export these values into variables and use them appropriately.

Hope this helps.

Best
Kalyan


Anthony Schneider —

I vote for a better way of displaying. People don't want to write their own logging code as it complicates the overall solution, which should be primarily focused on ETL and data transformation not logging and alerting.

Post Your Community Answer

To add an answer please login