Microsoft Azure Blob Storage V3 Connector > Mappings for Microsoft Azure Blob Storage V3 > File formatting options
  

File formatting options

When you select the format of a Microsoft Azure Blob Storage file, you can configure the formatting options.
The following table describes the formatting options for Avro, Parquet, JSON, and delimited flat files:
Property
Description
Schema Source
The schema of the source file.
Select one of the following options to specify a schema:
  • - Read from data file. Imports the schema from the file in Microsoft Azure Blob Storage.
  • - Import from schema file. Imports schema from a schema definition file in your local machine.
Schema File
The schema definition file in the agent machine from where you want to upload the schema.
The following table describes the formatting options for flat files:
Property
Description
Flat File Type
The type of flat file.
Select one of the following options:
  • - Delimited. Reads a flat file that contains column delimiters.
  • - Fixed Width. Not applicable.
Delimiter
Character used to separate columns of data. You can set values as comma, tab, colon, semicolon, or others.
You can't set a tab as a delimiter directly in the Delimiter field. To set a tab as a delimiter, you must type the tab character in any text editor. Then, copy the character to the Delimiter field.
EscapeChar
Character immediately preceding a column delimiter character embedded in an unquoted string, or immediately preceding the quote character in a quoted string.
Qualifier
Quote character that defines the boundaries of text strings. You can configure parameters such as single quote or double quote.
You can use the output text qualifier when a delimiter value is present in the data.
Qualifier Mode
Not applicable.
Code Page
Select the code page that the Secure Agent must use to read data from a delimited flat file. Select UTF-8 for mappings.
Header Line Number
Specify the line number that you want to use as the header when you read data from Microsoft Azure Blob Storage. You can also read a data from a file that does not have a header. To read data from a file with no header, specify the value of the Header Line Number field as 0.
First Data Row
Specify the line number from where you want to start reading the data. Enter a value greater than or equal to one.
To read data from the header, the value of the Header Line Number and the First Data Row fields should be the same. Default is 1.
Target Header
Not applicable.
Distribution Column
Not applicable.
Is Escape Character Data Retained
Not applicable.
Max Rows To Preview
Not applicable.
Row Delimiter
Not applicable.
The following table describes the formatting options for JSON files:
Property
Description
Data elements to sample
Not applicable.
Memory available to process data
Not applicable.