Example. I want to know the total number of rows in a physical table after my transformations is done. Iam using a table update component where I export the row count as a variable and post that in a slack message. But the row count only returns the row count of the view that matillion uses to update the table, not the row count of the final table.
Any suggestion of how to better achieve my goal?
4 Community Answers
Johan Forssell —
(You should really include an edit option in the community) In my final table i have approx 3 000 000 rows but if i use that table in a table input component the sample tab says its only 400 000 rows
Hi Laura. Thanks for your answer. I found the root of the inconsistency. I think the table input component was based on a old view created in redshift. When I deleted all my views and used the table input component again after revalidation I got the correct row count.