Creating a metadata definition - 8.0

Creating and using metadata in Talend Studio

Version
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development > Designing Jobs
Last publication date
2024-02-06

Creating a metadata definition allows you to set up reusable information across all of your components.

Before you begin

This tutorial makes use of a .csv file. Download the following folder and extract the file: customers_unordered.zip.

Procedure

  1. In the Repository, expand Metadata then right-click File delimited and click Create file delimited.
  2. In the Name field, enter a name.

    Example

    Customers
  3. Optional: In the Purpose field, enter a purpose.

    Example

    Creating reusable metadata thanks to a .csv file
  4. Optional: In the Description field, enter a description.

    Example

    Reusable shareable customer metadata
    Tip: Enter a Purpose and Description to stay organized.
  5. Click Next.
    You are brought to Step 2 in the wizard.
  6. Click Browse and select the file of your choice in the File Explorer.
  7. Click Next.
    You are brought to Step 3 in the wizard.
  8. Optional: Define the parse settings.

    Example

    • Under File Settings, select your Field Separator and change it, if needed.
      Note: The most common Field Separator is ;
    • Under Preview, select Set heading row as column names. The Header field automatically fills with the value 1, meaning the first row of your file has the file headers.
    Tip: Under Preview, click Refresh Preview to check the parsing results.
  9. Click Next.
    You are brought to Step 4 in the wizard.
  10. Optional: In the Name field, enter a name.

    Example

    customersSchema
  11. Optional: Update the Schema so it is identical to the structure of the sample file.

    Example

    Change the Number Type to String. A postcode number does not serve an arithmetic function.
  12. Click Finish.

Results

In the Repository, under Metadata, you can find and use your metadata.