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.

This property is not available when other connection component is selected
from the Connection Component drop-down list.

Select the component whose connection details will be
used to set up the connection to Azure storage from the drop-down list.

Enter the name of the storage account you need to access. A storage account
name can be found in the Storage accounts dashboard of the Microsoft Azure Storage
system to be used. Ensure that the administrator of the system has granted you the
appropriate access permissions to this storage account.

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.

Select the protocol for this connection to be created.

Use Azure Shared Access Signature

Select this check box to use a shared access signature (SAS) to access the
storage resources without need for the account key. For more information,
see Using Shared Access Signatures
(SAS).

In the Azure Shared Access Signature field displayed,
enter your account SAS URL between double quotation marks. You can get the
SAS URL for each allowed service on Microsoft Azure portal after generating
SAS. The SAS URL 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, see Constructing the Account SAS
URI.

Note that the SAS has valid period, you can set the start time at which the
SAS becomes valid and the expiry time after which the SAS is no longer valid
when generating it, and you need to make sure your SAS is still valid when
running your Job.

Specify the name of the table into which the entities will be written.

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.

Click Edit
schema to make changes to the schema. If the current schema is of the Repository type, three options are available:

• 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.

Partition Key

Select the schema column that holds the partition key value from the drop-down
list.

Row Key

Select the schema column that holds the row key value from the drop-down list.

Select an action to be performed on data of the table defined.

• Insert: insert a new entity into the table.
• Insert or replace: replace an existing entity or insert a
  new entity if it does not exist. When replace an entity, any properties from the
  previous entity will be removed if the new entity does not define them.
• Insert or merge: merge an existing entity or insert a new
  entity if it does not exist. When merge an entity, any properties from the previous
  entity will be retained if the new entity does not define or include them.
• Merge: update an existing entity without removing the
  property value of the previous entity if the new entity does not define its
  value.
• Replace: update an existing entity and remove the property
  value of the previous entity if the new entity does not define its value.
• Delete: delete an existing entity.

For performance reasons, the incoming data is processed in parallel and in random
order. Therefore, it is not recommended to perform any order-sensitive data operation
(for example, insert or replace) if there are duplicated rows in your data.

Select an operation to be performed on the table defined.

• Default: No operation is carried out.

• Drop and create table: The table is removed
  and created again.

• Create table: The table does not exist and
  gets created.

• Create table if does not exist: The table is
  created if it does not exist.

• Drop table if exist and create: The table is
  removed if it already exists and created again.

Select this check box to process the input entities in batch.

Note that the entities to be processed in batch should belong to the same partition
group, which means, they should have the same partition key value.

Select the check box to stop the execution of the Job when an error
occurs.

Complete this table to map the column name of the
component schema with the property name of the Azure table entity if they are
different.

• Schema column name: enter the column name of the
  component schema between double quotation marks.
• Entity property name: enter the property name of the
  Azure table entity between double quotation marks.

For example, if there are three schema columns
CompanyID, EmployeeID, and
EmployeeName that are used to feed the values for the
PartitionKey, RowKey, and
Name entity properties respectively, then you need to add the
following rows for the mapping when writing data into the Azure table.

• the Schema column name cell with the value
  "CompanyID" and the Entity property
  name cell with the value "PartitionKey".
• the Schema column name cell with the value
  "EmployeeID" and the Entity property
  name cell with the value "RowKey".
• the Schema column name cell with the value
  "EmployeeName" and the Entity property
  name cell with the value "Name".

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

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

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

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

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

Usage rule

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