1.74 release notes

Below, you can find release notes for Matillion ETL version 1.74.x

Read about Matillion ETL supported releases.

Note

The 1.74.0 release notes were published missing the following line item:

Improved the behaviour of our file filter RegEx functionality in the File Iterator component as it did not align with the documented behavior. Customers with existing file filters with regular expressions that don't match the full path as described below should update these components to match the new behavior.
- Before: filename.ext
- After: .*/filename.txt

The 1.74.0 section of this page has now been updated to include this item and we apologize for any inconvenience caused.

Matillion ETL version 1.74.9

2024 - July 24th

Improvements and bug fixes

Fixed an issue where the validation state of components was not cached, leading to unexpected invalidation of components.

Matillion ETL version 1.74.8

2024 - June 26th

Improvements and bug fixes

Updated the base virtual machine from CentOS Stream 8 to CentOS Stream 9.
Improved the logging of validation errors so that users can better identify the root cause of a validation failure.

Matillion ETL version 1.74.7

2024 - May 20th

Improvements and bug fixes

Fixed an issue where a data load to Amazon Redshift could fail with an S3 bucket region mismatch error.
Fixed an issue where the application would freeze when trying to log in to the server.

Matillion ETL version 1.74.6

2024 - April 15th

Improvements and bug fixes

Fixed an issue where scheduled jobs would not trigger.
Fixed an issue where Matillion ETL could become unresponsive when using Git integration.
Fixed an issue where task_batch_history indexes were not created.
Security and vulnerability fixes.

Matillion ETL version 1.74.5

2024 - March 19th

Bug fixes

Fixed an issue where spaces in Amazon S3 bucket and folder names were not being treated as valid.
Fixed an issue where folders in an Amazon S3 bucket were being listed as files in the file selection dialog for certain components.
Fixed an issue that was causing the thread count to increase until the Matillion ETL instance stops responding in some circumstances.
Fixed an issue that caused the S3 Load component to be unable to access S3 buckets in a region different from the one the Matillion ETL instance is hosted in.

Matillion ETL version 1.74.4

2024 - March 11th

Bug fixes

Fixed an issue where processing AWS S3 object lists was not working as expected.

Matillion ETL version 1.74.3

2024 - March 1st

Improvements

Enabled use of Azure's US Government key vault for credential storage.

Matillion ETL version 1.74.2

2024 - February 28th

New features and improvements

Fixed an issue in Excel Query where, after a recent upgrade of the AWS SDK, if a Storage URL parameter contained spaces, AWS S3 would not return a "404 not found".
Removed an AWS call to request the region for S3 buckets.
Added an improvement to ensure that special characters and whitespace can be used in S3 buckets and keys.

Driver updates

MongoDB API driver updated 22.0.8389.0 → 23.0.8749.0. This fixes an issue where instances of the MongoDB Query component could hang during component validation.

Matillion ETL version 1.74.1

2024 - February 9th

New features and improvements

Added an improvement to confirm that URLs are parsed correctly following a successful log in.
Security fixes.

Matillion ETL version 1.74.0

2024 - January 10th

New features and improvements

All platforms

The Performance monitor feature is now generally available. The performance monitor displays critical real-time performance metrics for your Matillion ETL instances.
Added support for end-to-end data encryption to the SAP ODP Extract connector.
Improved the behaviour of our file filter RegEx functionality in the File Iterator component as it did not align with the documented behavior. Customers with existing file filters with regular expressions that don't match the full path as described below should update these components to match the new behavior.
Before: filename.ext
After: .*/filename.txt

Delta Lake on Databricks

When creating a new environment, you can now specify a full Databricks URL as the Workspace ID.
Added environment default Unity Catalog as an Automatic variable.

AWS

Updated the AWS SDK for Java to support AWS security best practices, as detailed in this Tech Note.

Bug fixes

All platforms

Removed the S3 URL Region property from all components where it was used; this was originally introduced to work around an AWS issue that has now been fixed by AWS.

Snowflake

Fixed an issue where SAP ODP delta files were exceeding Snowflake size limits.
Fixed an issue that was causing Salesforce Query to hang when using Join or Union All operations. (AWS)

Amazon Redshift

Fixed an OAuth issue that was causing the Data Transfer component to fail in some circumstances when attempting to pull a file from the Documents Library in SharePoint.

Driver updates

AWS Redshift JDBC driver updated 2.1.0.9 → 2.1.0.18
- This driver update includes a fix for the issue described in this tech note and customers may wish to consider upgrading their Matillion ETL version if affected.
Google Ad Manager API updated v202205 → v202308
Marketo API driver updated 22.0.8384.0 → 23.0.8565.0
Salesforce Marketing Cloud API driver updated 21.0.8222.0 → 23.0.8669.0