Generating a schema from sample data

  1. Select Data Catalog > Object Schemas.
  2. In tiles view, click the Add tile. In grid view, click the Add icon above the grid.
  3. Select Generate from Sample Data from the drop-down list that is displayed.
  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. For BODs, only a single sample file can be selected.
    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.
    • PSV sample files must use .txt as the file extension
  5. Click NEXT to specify the object information.