.jpg?version=2&modificationDate=1678263940527&cacheVersion=1&api=v2&width=453&height=241)
File Format: Allows you to configure the file format and source schema. Select the required file format from the dropdown.
Once the File Format is selected, all the related configurations will appear.
Parquet
.jpg?version=2&modificationDate=1677564065016&cacheVersion=1&api=v2)
Delimited
.jpg?version=3&modificationDate=1677563204201&cacheVersion=1&api=v2&width=680&height=69)
Header Row: Allows to specify that the file's first row data must be considered a header row. Data available in the header row separated by delimiter are column names.
Delimiter: Delimiter is a character separator that separates the values stored in rows. Allows to define the predefined and custom delimiter for the data. Select the required delimiter from the dropdown.
Comma: Allows to select a Comma (,) delimiter for the data.
Tab: Allows to select a Tab ( ) delimiter for the data.
Custom: Allows to define the custom delimiter. For Example: Semicolon, Colon, Pipe, Forward Slash.
Selection of Custom enables the Custom Delimiter.
Custom Delimiter: Allows to define a new custom delimiter for the data.
Selection of Custom from the Delimiter dropdown is mandatory to define the custom delimiter.
Escape Character: An Escape character and a Text Qualifier create a sequence recognized and ignored during parsing. Its purpose is to allow the use of escape sequences in the data that would otherwise be seen as delimiter occurrences.
It avoids the delimiter collision. The character preceded by a backslash (\) is known as an escape character.
An escape character will come into the picture when there is a delimiter in the data. It is used to escape the delimiter only.
Text Qualifier: Text qualifier is used in the event that delimiters are contained within the row cell. If the cell contains a delimiter and a text qualifier is not used, then the data that occurs after the delimiter will spill into the next column.
The Text Qualifiers are single (' ') or double (“ “) quotation marks around data elements to identify the element as text- or character-based data.
A text qualifier is a character used at the beginning and end of a field value.
If the data has many strings or sentences that contain commas,
Wrap all string values in quotation marks (“”).
Use another delimiter from the dropdown that may not be present in your data.
Use a custom delimiter that may not be present in your data.
Json
.jpg?version=2&modificationDate=1678266441626&cacheVersion=1&api=v2)
Upload: Click the Upload button to upload the data file. Select the required file needed to upload and click Upload.
The selected file size must be less than 2MB.
The View Batch Schema button gets enabled after uploading the selected file.
View Batch Schema: Allows you to view and modify the selection of source schema.
Source Data Format
.jpg?version=1&modificationDate=1677217044423&cacheVersion=1&api=v2&width=374&height=193)
All the available parent column names in the uploaded data file will appear here.
Filter: It allows you to search and filter the specific columns here. Scroll down manually to see the entire list.
Column list: As required, you can select or deselect the parent column name list of the left-hand side drawer.
By default, all the columns available in the source data format are selected.
JSON: JSON schema will update dynamically when columns/keys are selected or deselected from the left-hand side drawer. It displays the standardized schema structure that needs to be mapped in the project schema.
Users can only view the standardized schema structure.
After changes, copy the created entire schema and paste it into the defined project schema at the right-hand side drawer.
Click Save Changes to save the configuration.
