JSON

You can import metadata from JSON files into a JSON environment.

To import metadata from JSON files, follow these steps:

  1. On the Explore tab, click a JSON environment tile to view its details.
    Alternatively, under Filter By Database Type, select the JSON option to view all JSON environments.
  2. Click Options.
    The available options appear.
  3. Click Scan Metadata.

    4. The JSON Metadata Scan - Step1 page appears.

  4. Under the JSON Schema section, drag and drop or use to browse and select the JSON schema file.
  5. Under the Data File [JSON] section, drag and drop or use to browse and select the JSON data file.
  6. Use the following scan options:
    Add New
    Use this option to insert new metadata into the environment.
    Update Existing + Add New
    Use this option to update the existing metadata based on tables and columns in the JSON file.
    Update Existing + Add New + Invalidate
    Use this option to update the existing metadata without deleting it.
    Delete & Reload
    Use this option to delete all the business properties and data dictionary stored as metadata for this environment.
    Import Comments
    Use this option to import comments and descriptions defined in the JSON file.
    Skip Empty Cells
    Use this option to skip blank cells in the JSON file to avoid overwriting existing metadata with empty values. This option is available only when you select the Update Existing + Add New or Update Existing + Add New + Invalidate options.
    Import User Defined Fields
    Use this option to import environment-specific custom fields configured as User Defined Fields (UDFs). This option is available only when you select the Update Existing + Add New or Update Existing + Add New + Invalidate options.
  7. Click the appropriate Import Model Type.
  8. Click .

    9. The JSON Metadata Scan - Step2 page appears.

  9. Select the required schema and tables.
  10. Click .

    11. The metadata is imported and saved in the environment.