1.70 release notes

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

Tech notes

If you're experiencing out-of-memory (OOM) exceptions or high CPU usage since updating to version 1.68.7 or above, read Tech note - Redshift RingBuffer exceeding expected limits for a workaround.

2023 - May 5th

Fixed an issue where the Google Analytics Query component would not return any data when the query included an IS LIKE clause.
Fixed an issue where the Google Analytics Query component was incorrectly using a page size of 200 immutably. The page size now defaults to the maximum value, 10,000, and the connection option works as expected if you wish to lower this number.
Fixed an issue where an instance migration would complete without successfully exporting Matillion ETL users stored in a Matillion ETL database.
Fixed an issue where the Salesforce Output component would fail because fields that began with a comma were not being enclosed in double quotes.

2023 - April 12th

Added MariaDB to the list of available database types when using the Database Query component.

Added an Assign Tag component. This component lets you assign existing tags to Snowflake objects, enabling you to better track object usage within your Snowflake account.
Added an Anaplan Bulk component, which uses the Anaplan API to retrieve bulk data to load into a table via an Anaplan "export" or custom "view".

The following features are now generally available for Matillion ETL for Snowflake, Amazon Redshift, and Delta Lake on Databricks:
- The Run dbt Command
- The Sync File Source
- The Manage External File Sources
The Preview Labs feature is no longer available.

Added an SAP ODP Extract (Preview) component, which is available as a public preview offering, and enables Matillion ETL users to connect directly through SAP ODP to access available data sources in SAPI and ABAP CDS view.

All Query components (for example, Salesforce Query) can now stage data using Databricks personal staging. In a Query component's properties, click Stage Platform → Personal Staging. Read the component documentation for more information.
You can now configure concurrent connections in your Matillion ETL environment settings.

Fixed an issue where the Google BigQuery component would not generate correct SQL to run when configured in Basic Mode and where a table had a column of type struct.
Fixed an issue where the Zendesk Support Query component was not retrieving data from column custom_field_options_ in the ticket_fields table.
Fixed an issue where API Query Profile parameters were being duplicated during paging, causing the API Query component to fail.
Fixed an issue where an incorrect number of concurrent users were shown when applying licences on multiple environments.