Property Type

Select the way the connection details
will be set.

• Built-In: The connection details will be set
  locally for this component. You need to specify the values for all
  related connection properties manually.

• Repository: The connection details stored
  centrally in Repository > Metadata will be reused by this component. You need to click
  the […] button next to it and in the pop-up
  Repository Content dialog box, select the
  connection details to be reused, and all related connection
  properties will be automatically filled in.

Schema and Edit schema

A schema is a row description. It defines the number of fields
(columns) to be processed and passed on to the next component. When you create a Spark
Job, avoid the reserved word line when naming the
fields.

• Built-In: You create and store the schema locally for this component
  only.

• Repository: You have already created the schema and stored it in the
  Repository. You can reuse it in various projects and Job designs.

• View schema: choose this
  option to view the schema only.

• Change to built-in property:
  choose this option to change the schema to Built-in for local changes.

• Update repository connection:
  choose this option to change the schema stored in the repository and decide whether
  to propagate the changes to all the Jobs upon completion. If you just want to
  propagate the changes to the current Job, you can select No upon completion and choose this schema metadata
  again in the Repository Content
  window.

Guess
schema

Click this button to retrieve the
schema from the data object specified.

Authentication method

Account
name

Enter the name of the Data Lake
Storage account you need to access. Ensure that the administrator of the
system has granted you the appropriate access permissions to this
account.

Endpoint
suffix

Enter the Azure Storage service
endpoint.

The combination of the account name and the
Azure Storage service endpoint forms the endpoint of the storage
account.

Shared
key

Enter the key associated with the
storage account you need to access. Two keys are available for each account
and by default, either of them can be used for this access. To know how to
get your key, read Manage a storage account.

This field is available if you select Shared key from Authentication method drop-down list.

SAS
token

Enter your account SAS token. You can
get the SAS token for each allowed service on the Microsoft Azure portal
after generating SAS. The SAS token format is https://<$storagename><$service>.core.windows.net/<$sastoken>,
where <$storagename> is the
storage account name, <$service> is the allowed service name (blob, file,
queue or table), and <$sastoken> is the SAS token value. For more
information, read Constructing the Account SAS
URI.

This field is available if you select
Shared access signature from
Authentication method drop-down
list.

Check
connection

Click this button to validate the
connection parameters provided.

Filesystem

Enter the name of the target Blob
container.

You can also click the … button to
the right of this field and select the desired Blob container from the list
in the dialog box.

Blobs
Path

Enter the path to the target
blobs.

Format

Set the format for the incoming data.
Currently, the following formats are supported: CSV, AVRO, JSON, and Parquet.

Field
Delimiter

Set the field delimiter. You can
select Semicolon, Comma, Tabulation, and
Space from the drop-down list; you can
also select Other and enter your own in
the Custom field delimiter field.

Record
Separator

Set the record separator. You can
select LF, CR, and CRLF from the
drop-down list; you can also select Other
and enter your own in the Custom Record
Separator field.

Text
Enclosure Character

Enter the character used to enclose
text.

Escape
character

Enter the character of the row to be
escaped.

Header

Select this check box to insert a header row to the data retrieved.

File
Encoding

Select the file encoding from the
drop-down list.

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at the Job level
as well as at each component level.

ERROR_MESSAGE

The error message generated by the component when an error occurs. This
is an After variable and it returns a string.

NB_LINE

The number of rows successfully processed. This is an After variable and it returns
an integer.

Usage rule

This component is usually used as a start component of a Job or
subJob and it always needs an output link.