If you have an Amazon S3 account, you might want to go further. Once you have uploaded a file to S3, you can create a connection to this S3 bucket and retrieve the dataset from Talend Cloud Pipeline Designer.
You will then be able to reproduce the use case with the dataset hosted in Amazon S3.
Before you begin
Make sure your user or user group has the correct permissions to access the Amazon S3 resources.If you do not have these permissions you can try one of the following options.
Note: The default error that displays when trying to access S3 resources without sufficient permissions is Bad Gateway.
- (recommended) Ask the administrator who manages your Amazon account to give you/your user the correct S3 permissions.
- Implement your access policy yourself by following the Amazon documentation if you are allowed to do so.
- (not recommended) Attach the AmazonS3FullAccess policy to your group/your user through the IAM console. This allows you to read and write to S3 resources without restrictions to a specific bucket. However this is a quick fix that is not recommended by Talend.
Retrieve the financial_transactions.avro file from the Downloads tab in the left panel of this page.
- Upload the financial_transactions.avro file to your Amazon S3 bucket as described in the Amazon S3 documentation.
- On the Home page of Talend Cloud Pipeline Designer, click .
- In the panel that opens, give a name to your connection, s3 connection for example.
Select your Remote Engine Gen2 in the Engine
Note: If you want to use a Remote Engine Gen2, you need to create it from Talend Cloud Management Console. If it exists but does not have the AVAILABLE status that means it is up and running, you will not be able to select a Connection type in the list nor to save the new connection. The list of available connection types depend on the engine you have selected.
Select S3 connection in
the Connection type list.
- Check your connection and click ADD DATASET to point to the file that you have previously uploaded in your S3 bucket.
In the Add a new dataset
panel, fill in the connection information to your S3 bucket:
- Give a display name to your dataset, financial data on S3 for example.
- Add a description if needed.
- In the Bucket field, select or type the name of your S3 bucket.
- In the Path field, type in the path to the financial_transactions.avro file you have previously uploaded to your S3 bucket.
- In the Format list, click AUTO DETECT to automatically detect the format or select Avro in the list.
Click VIEW SAMPLE to check that your data is valid and
can be previewed.
- Click VALIDATE to save your dataset.
Once your pipeline is executed, the updated data will be visible in the file located on Amazon S3.