This article describes the principal changes of Amazon Component.
If you need further information, please consult the full changelog.
The plugin download section can be found at this page.
Stambia DI is a flexible and agile solution. It can be quickly adapted to your needs.
If you have any question, any feature request or any issue, do not hesitate to contact us.
This article is dedicated to Stambia DI 2020 (S20) or higher.
If you are using Stambia DI S17, S18 and S19 please refer to this article.
Folder creation with the tool AWS S3
The existing S3 TOOL allows to retrieve a remote file which is on S3 and store it locally, through the operation "getfile" which will download it locally in the local path defined.
When the defined path on the parameter "Local File Path" doesn't exist then the tool AWS S3 will now automatically create the corresponding folder.
Before this change, an error was thrown if the folder did not exist.
Addition of a sample project
A sample project has been added to help for Amazon Component usage.
The new sample project is shipped with the Component, so you simply have to install the new version and you'll have at your disposal the sample project.
Check this article to learn how to use the sample projects shipped inside a Component.
Snowflake External Storage Attribute
Snowflake Component allows to use Amazon S3 as storage location.
Amazon Component has been updated to automatically provide the availables S3 nodes of the workspace in the Snowflake Metadata.
Below is an example of the Snowflake Metadata with the list of available nodes:
Note that this requires to use also the corresponding Snowflake Component which has been updated according for this list.
Minor improvements and fixed issues
This version contains some minor improvements and fixed issues, which can be found in the complete changelog.
The complete changelog with the list of improvements and fixed issues can be found at the following location.
This version contains some issues which can be found on the full changelog.
LOAD Rdbms to Redshift (with copy)
Allow using stringDelimiter and fieldDelimiter at the same time.
Amazon S3 with Metadata Configuration
To load data from your local databases, the data need to be exported in a file and this file is copied in a Amazon S3 bucket.
Metadata Configurations on the Amazon S3 bucket name were ignored.
Change Data Capture (CDC)
Multiple improvements have been performed to homogenize the usage of Change Data Capture (CDC) in the various Components.
Parameters have been homogenized, so that all Templates should now have the same CDC Parameters, with the same support of features.
Multiple fixes have also been performed to correct CDC issues. Refer to the changelog for the exact list of changes.