Generating a schema from sample data
- Select Data Catalog > Object Schemas.
- In tiles view, click the Add tile. In grid view, click the Add icon above the grid.
- Select Generate from Sample Data from the drop-down list that is displayed.
-
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.
-
Click NEXT to specify the object information.
See Object information.