1.77 release notes

Short-term support (STS)

Welcome to the release notes for Matillion ETL version 1.77.

This version is a short-term support (STS) release, with a lifecycle of approximately 8 weeks that will run until February 2025.
The current latest long-term support version is 1.75, which will be supported until at least November 2025.

Read more about Matillion ETL supported releases.

1.77.1

December 18th, 2024

Known issues

There are no known issues at this time.

Breaking changes

There are no breaking changes as part of this release.

Deprecations

Snowflake single-factor password authentication

On December 1st, 2024, Snowflake announced plans to block single-factor password authentication by November 2025. We will act swiftly and in alignment with Snowflake to ensure that password authentication to Snowflake is deprecated in future releases of Matillion ETL.

Matillion introduced support for Snowflake key pair authentication in version 1.40 on August 20th, 2019. Therefore, as long as you're running version 1.40 or later, you can switch your Snowflake project and environment authentication mechanisms from a password to a private key. We advise all customers perform this action as soon as possible.

If you're running version 1.39 or older, we urge you to upgrade to one of our supported releases to receive our latest features, bug fixes, and security enhancements.

Warning

If you're running Matillion ETL for Snowflake on version 1.39 or older, we anticipate that your instances will stop working once Snowflake blocks single-factor authentication in November 2025.

Manage CDC

As of December 1st, 2024, the Manage CDC feature is now end of life (EOL). This feature will be fully removed from Matillion ETL in a future release. Read the tech note Removal of Manage CDC from Matillion ETL to learn more.

Dynamics Nav

Matillion intends to deprecate and remove the Dynamics NAV Query connector from Matillion ETL. We are currently aiming to deprecate this connector in the next long-term support (LTS) release.

New features and improvements

Snowflake query tagging

We've added the ability for Snowflake users to apply a Snowflake tag to a Matillion ETL job, for example to assist in allocating resource costs within your organization. You can create one or more query tag configurations, and these configurations define which tags will be passed to Snowflake when jobs are run.

Other improvements and bug fixes

Improved the progress bar and messaging in the Migrate dialog when migrating from one Matillion ETL instance to another to clarify what resources have been migrated and which task is in progress.
Fixed an issue to ensure that the API Query component cannot be initialized with invalid options following an unclean shutdown.
Enabled the use of a deprecated MongoDB connector to avoid existing jobs breaking, due to persistence issues with the current MongoDB connector.
Added server certificates to the trust store to allow Bash "internal" REST API calls to be made using an HTTPS endpoint.
Improved the Manage Schedules dialog by adding a field for filtering schedules by name. We recommend using this feature if you have lots of schedules set up for your jobs.
Fixed an issue to ensure that an invalid region selection does not stall the retrieval of SQS endpoints.
Improved the Support information dialog in the Help menu to show more useful, detailed information about the disk space partitioning.
Fixed an issue for Delta Lake on Databricks users where views were not displaying in the Views drop-down menu in the Environments panel.
Improved 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)..

Driver updates

Updated the Snowflake JDBC driver from version 3.15.1 to version 3.20.0.