Depends. Even something basic like "Check if the produced artifact is a valid .zip/.tar.gz" can be enough in the beginning, probably would have prevented the issue I shared before.

Then once you grow/need higher reliability, you can start adding more advanced checks, like it has the tables/data structures you expect and so on.