1.68 Release Notes
-
DarkLight
1.68 Release Notes
-
DarkLight
Overview
Below, you can find release notes for Matillion ETL version 1.68.x
Matillion ETL version 1.68.6 (interim release)
2023 - March 10th
- AWS Redshift JDBC driver updated
1.2.55.1083
→2.1.0.9
Matillion ETL version 1.68.5 (interim release)
2023 - February 6th
- Fixed an issue where external columns were not being retrieved as expected after a Redshift cluster upgrade.
Matillion ETL version 1.68.4 (interim release)
2023 - January 13th
- Added a Login URL (optional) field to the Configure OAuth dialog for Salesforce Bulk Query.
- The Google Ads Query component now supports the
per_store_view
data source. - Google Ads API driver updated.
21.0.8222.0
→22.0.8353.0
. Read the Google Ads data model. - Facebook Ads API driver updated.
21.0.8222.0
→22.0.8353.0
. Read the Facebook Ads data model. - By default, Facebook Ads Query now uses v15 of the Facebook Marketing API. Read Available Marketing API Versions to learn more. Use the
version
connection option if you wish to change to an older version.
Matillion ETL version 1.68.3 (major release)
2022 - December 20th
New features and improvements
All platforms
- Improved Matillion ETL's support of Python.
- Added a Manage Interpreters dialog. Create a named "interpreter" and point it at your preferred Python version. Matillion ETL now distributes with Python 3.6 and 3.8 but any version of Python can be installed as per user requirements.
- Manage Interpreters also lets you disable Python versions as required.
- Versioned the following components. Existing jobs using the old version of the component will continue to work as expected. New instances of the components will use the new version. When making new jobs with the new version of these components, you may need to configure fresh OAuth entries (where applicable):
- Apache Hive Query component.
- Apache Spark SQL Query component.
- NetSuite Query component.
- SugarCRM Query component.
- Added CSV and ZIP-CSV content types to the Salesforce Output component's Content Type parameter.
- Improved Add OAuth Entry dialog readability by alphabetizing third-party services.
- Improved the Salesforce Query component by adding an "Other" option to the Authentication Method parameter. When this option is chosen, use the Connection Options to specify an OAuth access token. Read the component documentation for more details.
- Improved the API v1 - Metadata endpoint.
Snowflake, Amazon Redshift, and Google BigQuery
- Updated the Salesforce Output component:
- Added the ability to capture and truncate batch results.
- Added the ability to truncate rejected records.
Delta Lake on Databricks
- Added support for Databricks Unity Catalog at the Matillion ETL environment level. Users can now connect to a specific catalog on the Delta Lake Defaults page when setting up an environment or project in Matillion ETL for Delta Lake on Databricks.
- Added a Run Delta Live Table component, which lets you start a Delta Live Tables pipeline from Matillion ETL.
- Added the ability to cancel a running Databricks pipeline. Right-click a running pipeline in the Tasks tab, and click Cancel.
Bug fixes
All platforms
- Fixed an issue where components that referenced a deleted secret manager secret could no longer be updated to point at a different secret.
- Fixed an issue where the Salesforce Query component wasn't able to authenticate using JWT Token Access.
- Fixed an issue where the Data Transfer component was failing to unpack zip files.
Snowflake, Delta Lake on Databricks, and Amazon Redshift
- Fixed an issue where some commands in CloudFormation templates were failing, causing Matillion ETL to not start in some cases.
Snowflake
- Fixed an issue where Git "fetch" operations were failing due to a bug in Apache on Azure.
- Fixed an issue where refreshing or logging out and back in to Matillion ETL always opened the default environment, regardless of which environment the user was previously using. The previously selected environment will now be selected automatically when logging back in.
- Fixed an issue where attempting to view the Task History of a very large scheduled job could result in out-of-memory errors.
Delta Lake on Databricks
- Fixed an issue where Table Metadata wasn't correctly saving and displaying zero values in the Size or Scale fields.
Driver updates
- Apache Hive API driver updated
20.0.7627.0
→22.0.8326.0
- Apache Spark SQL API driver updated
18.0.6934.0
→22.0.8322.0
- Couchbase API driver updated
21.0.8011.0
→22.0.8322.0
- NetSuite API driver updated
20.0.7662.0
→22.0.8322.0
- Salesforce API driver updated
21.0.8129.0
→22.0.8356.0
- SugarCRM API driver updated
18.0.6705.0
→22.0.8322.0