tDatasetInput Standard properties - 7.2

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

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

Fetch Schema

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

Platform

Two options are available for this drop-down list:

• Data Preparation is the default value. Use this option if you want to use the tDatasetInput component in the Talend Data Preparation context.
• Data Catalog. This value only exists for internal testing pruposes, and should not be selected, unless explicitely asked to do so by your Talend support representative.

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.