Skip to content

1.76 release notes

Below, you can find release notes for Matillion ETL version 1.76. Read more about Matillion ETL supported releases.

Matillion ETL version 1.76.4

2024 - November 20th

Improvements and bug fixes

All platforms

  • Fixed an issue that was causing an error when setting the Access URL option for the SurveyMonkey Query connector.
  • Fixed an issue that was causing intermittent errors in the Sync File Source component.
  • Fixed an issue that was causing the Run job in clone option when creating a schedule to show as "Enterprise only", even when the instance was using an Enterprise license.
  • Fixed an issue that was causing transformation jobs to intermittently fail with the error Input component <component name> is not in a valid state.

Databricks

Amazon Redshift

  • Fixed an issue that was preventing the S3 Manifest Builder component from listing files in subdirectories.

Matillion ETL version 1.76.3

2024 - November 7th

Improvements and bug fixes

  • Fixed an issue where OAuth for Dynamics 365 would not refresh. Now, Matillion ETL automatically sets InitiateOAuth=GETANDREFRESH for Dynamics 365 to auto refresh the OAuth.
  • Enabled the use of a deprecated MongoDB connector to avoid existing jobs breaking, due to persistence issues with the current MongoDB connector.
  • Improved Matillion ETL FIFO queues in the SQS Message component to include MessageID and MessageDeDuplicationID parameters to circumvent error software.amazon.awssdk.services.sqs.model.SqsException: The request must contain the parameter MessageGroupId. (Service: Sqs, Status Code: 400, Request ID: ea63b15d-a78d-52be-9b37-eccd69056a3b)..
  • Fixed an issue in Matillion ETL for Delta Lake on Databricks where views were not displaying in the Views drop-down menu in the Environments panel.

Matillion ETL version 1.76.2

2024 - October 25th

Improvements and bug fixes

All platforms

  • Fixed an issue where the Data Transfer component would time out while attempting to authenticate to an SFTP service.
  • Added a feature switch to allow disabling of password autocompletion in the user's browser.
  • Fixed a bug in the Performance monitor that was preventing metrics being displayed in the Performance tab.
  • Fixed a bug with the Anaplan Bulk component to ensure complete and accurate Anaplan exports by caching and combining split rows across pages, while maintaining thread safety for reliable data processing.
  • Fixed an issue where the Send Email component was giving an "Invalid Address" error when sending to recipients with a .teams.ms address.
  • Fixed an issue where jobs were not cancelling correctly in some circumstances.
  • Security and vulnerability fixes.
  • SFTP in the Data Transfer component now supports newer encryption algorithms (ssh-rsa is no longer supported).
  • Fixed an issue where certain single-threaded operations were affecting performance.
  • Fixed an issue where the Data Transfer component was failing when performing transfers between two different Amazon S3 bucket folders.
  • Fixed an issue in transformation jobs where it was not possible to select and delete all components on the canvas, though it was possible to select and delete some components.
  • Hardened Matillion ETL against CVE-2023-26119.

AWS Redshift

  • Fixed an issue where overlapping transactions in different jobs called by Run Transformation or Run Orchestration components were causing serialization violation errors.
  • Fixed an issue where connectors were unable to access S3 buckets in the me-south-1 location.
  • Fixed an issue that caused intermittent failures in transformation jobs that include a Table Input component.

Google BigQuery

  • Fixed a bug that was causing an error when the API Extract component created a table.

Driver updates

  • Google Ads driver updated 23.0.8649.0 → 24.0.9029.0, to allow the use of API v16.
  • SharePoint driver updated 21.0.8151.0 → 24.0.9001.0, to resolve an issue that was preventing queries of SharePoint lists exceeding 5000 items.

Matillion ETL version 1.76.1

2024 - October 18th

Bug fixes

All platforms

  • Fixed a bug in the Join component, discovered in version 1.76.0, which was preventing join expressions from being added.

Matillion ETL version 1.76.0

Bug

2024 - October 16th

Due to a bug found in the Join component on version 1.76.0, this release version has been revoked. We urge all customers who use marketplace listings to upgrade to version 1.76.1 or later, where this bug has been fixed.

2024 - October 10th

New features and improvements

All platforms

  • Bash Script and Python Script components can be locked down by means of a feature flag that only allows them to be executed by a specified restricted user.
  • When selecting SFTP as a source or destination for the Data Transfer component, the password and SFTP key parameters are obscured by displaying ********

Snowflake

  • The Format property for Create External Table, S3 Load, and S3 Unload will retrieve formats from the database and schema that the specified tables exist in.

    Warning

    This means jobs that previously used file formats that existed in the environment default schema, and not in the schema that the tables exist in, will no longer work. To fix this, recreate those file formats in the same schemas as the tables.

Delta Lake on Databricks

Driver updates

  • Databricks JDBC driver updated 2.6.25 → 2.6.34.
  • Snowflake JDBC driver updated 13.15.0 → 13.15.1.
  • LinkedIn driver updated 23.0.8921.0 → 24.0.8963.0. This affects both LinkedIn Query and LinkedIn Ads Query components. This removes support for the APIVersion connection property, as the driver now automatically uses the appropriate API version. You will need to remove this connection option if you have it set.
  • Facebook Ads driver updated 23.0.8565.0 → 23.0.8889.0. Facebook Ads driver now uses Marketing API version v19.
© Copyright 2024 Matillion Ltd | Legal | Privacy Policy | Disclaimer | Modern Slavery Statement