Generic Metadata Schema for Data Solution Automation
A JSON Schema and C# object model for an exchange format that describes the metadata needed to generate data warehouse transformation logic, so different data-automation tools can share the same source-to-target and physical-model metadata.
This project defines an exchange format for data logistics generation metadata that supports Data Solution Automation: generating the transformation logic for a data warehouse from a shared description rather than a tool-specific one. The repository holds the JSON Schema definition for that format, a C# class library for deserializing and validating files against it, C# examples using the interface, and a regression test project.
The metadata a conforming file carries includes source-to-target mappings, physical model metadata such as columns, tables and data types, and connectivity information or a proxy for it, kept text-based so it works under version control.
The intent is to separate the metadata format from the user interface and management layer built on top of it, so different vendors' tools, including a dedicated UI with templates or an adapter exposing the same data as JSON or a database view, can all read and write the same underlying metadata.