Creating a local dataset - Cloud

Talend Cloud Data Preparation User Guide

EnrichVersion
Cloud
EnrichProdName
Talend Cloud
EnrichPlatform
Talend Data Preparation
task
Administration and Monitoring > Managing connections
Data Quality and Preparation > Cleansing data
Data Quality and Preparation > Managing datasets
Import any local CSV, Excel, Avro, or Parquet file directly to your inventory. Datasets from various connections can be added via the add dataset button, but if you want to simply import one of your local files, you can easily do so with the Drag a file or browse option.

Procedure

To directly import a local dataset, you can either:
  • Drag your local file and drop it anywhere on the dataset screen.
  • Click the Drag a file or browse button to open your explorer and select the file to import.

Your file is uploaded and the local dataset is created. The Overview page directly opens. If a local connection has not been set up yet, it will be created on the fly.

This new connection will rely on the Cloud Engine for Design when possible, and only use an existing Remote Engine Gen2 if it is the only available one.

In the case that you already own a local connection, the local import will preferably rely on the oldest one created on the Cloud Engine for Design, and will use the one created on a Remote Engine Gen2 if necessary.

However, if no engine is available at import time, the local import will be disabled.

The information about the csv file properties, such as the escape character, field delimiter, etc. have been automatically detected in the background, but you can change them anytime in the dataset properties.

Results

Your local file is added to the list of datasets, and a Local connection is created if you did not own any beforehand.