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.

3 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.


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.

Matillion Agent  

Ian Funnell —

Hi Anthony,

This issue has been addressed in version 1.31 of Matillion. Please update to the latest version to take advantage of the new functionality.

Best regards,

Post Your Community Answer

To add an answer please login