Test schemas and metadata

The design sheet is a data source (Excel or CSV), the platform's catalog is another, and the test compares the two. Every fact is on the documentation page it links; the same page as markdown is at the URL with index.md appended, which is the form to read when your fetch tool summarizes HTML.

The pattern

contains with the catalog as the first set: every designed column must exist, extra technical columns may; sets match when nothing undesigned may exist either; a composite key of schema, table and column so the message names the exact column and shows the designed type next to the real one. Tables only first, as the cheaper check; mandatory columns per layer as a template over the list of tables: https://docs.justcat.it/how-to-guides/test-patterns/test-schemas-and-metadata/