Metadata Importer
The Agnostic Data Labs App manages metadata in local JSON files in the developer’s or modeler’s development environment.
The app connects to the files, and loads them into a consolidated in-memory model from where this metadata can be accessed to generate code.
Adding new metadata, or updating existing, can be performed by using the App to add or update Metadata Objects. Creating a new Metadata Object in the App will create, or update a file for the metadata.
It is possible to add new JSON files following the expected schema directly to the folders where the model is stored. This metadata includes id references for Metadata Objects.
It is also possible to import metadata through the app. This allows matching the import set against the existing metadata without the id metadata. Gathering the metadata can be done through a number of methods.
This article set includes sample SQL scripts for gathering JSON metadata for Connections and Data Objects.
The article set also includes the JSON from running these queries on a SQL Server with the example database available.
Any import JSON metadata for the importer must be provided directly to the App, either by dragging and dropping a file on the import area, opening the file through the open file button, or by copy/pasting the JSON into the editor.