...
File Format: Allows you to configure the file format and source schema. Select the required file format from the dropdown.
...
| Expand |
|---|
| title | A parquet file is a type of column-oriented file format where the data in each column is stored independently. It contains a table-type format to store the data. |
|---|
|
.jpg?version=3&modificationDate=1677563204201&cacheVersion=1&api=v2&width=680) 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.
| Info |
|---|
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. | Anchor |
|---|
| Escape-Character |
|---|
| Escape-Character |
|---|
|
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. | Info |
|---|
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. | Anchor |
|---|
| Text-Qualifier |
|---|
| Text-Qualifier |
|---|
|
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.| Info |
|---|
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. |
...
| Expand |
|---|
| title | Plain text file is written in the syntax of JSON |
|---|
|
Waiting For UI |
Upload: Click the Upload button to upload the data file. Select the required file needed to upload and click Upload.
...