Generating a schema from sample data

  1. Select Data Catalog > Object Schemas.
  2. In the tiles view, click the Add tile. In the grid view, click the Add icon.
  3. Select Generate from Sample Data from the displayed list.
  4. The Generate from sample data option is selected by default. Drag and drop or click Select Files, to upload one or more sample data files to generate a schema. All selected files must be of the same object type and subtype.
    Note: JSON sample files must use .json or .ndjson as the file extension to be properly inferred. Only newline-delimited JSON sample files should use the .ndjson extension.
    • A sample file that begins and ends with square brackets is inferred as a conventional JSON object. For this scenario, you cannot change the inferred subtype.
    • A sample file that contains a single object that spans multiple lines is inferred as a conventional JSON object.
    • A sample file that contains one or more single-line JSON objects is inferred as a newline-delimited JSON object.
    Note: For BODs, these restrictions apply:
    • Only a single sample file can be used.
    • The schema generation wizard does not support defining multiple namespaces.
  5. To specify the object information, click NEXT.
    See Object information.