tDatasetInput Standard properties

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.

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.

URL

Type the URL of the Talend Data Preparation web application, between double quotes.

Email

Type the email address that you use to log in the Talend Data Preparation web application, between double quotes.

Password

Click the [...] button and type your user password for the Talend Data Preparation web application, between double quotes.

If you are working with Talend Cloud Data Preparation and if:

• SSO is enabled, enter an access token in the field.
• SSO is not enabled, enter either an access token or your password in the field.

Dataset Name

Click the Choose a dataset button to select a name from the list.

Fetch Schema

Click this button to retrieve the schema from the dataset defined in the Dataset Name field.

Dataset ID

Type the ID of the dataset to be used, between double quotes.

tStatCatcher Statistics

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

Usage rule

This component is used as a start component and requires an output link.

Limitation

• If the column headers of your dataset in Talend Data Preparation contain whitespaces or special characters, the schema fetched in Talend Studio will be considered invalid.

• In Talend Studio, after fetching a schema from a dataset, you can add new columns but you must then give the exact same name (case sensitive) to the equivalent column in Talend Data Preparation.

• Variations between the schema of your data in Talend Data Preparation and in Talend Studio may lead to errors.