Matillion ETL release notes: v1.42
1.42.14 (interim release)
Bug fixes
Redshift
- Fixed an issue where a recent Redshift update changing the Redshift cluster schema prevented Matillion ETL from using External Tables via Amazon Spectrum.
1.42.11 (interim release)
Bug fixes, improvements, and driver updates
All platforms
- Fixed an issue where Database Query was producing validation errors after updating from v1.39.8 to v1.42.
- Fixed an issue where Create Table was displaying errors when given a database name containing a hyphen.
- Xero driver updated.
- Supported added for OAuth 2.0 for Xero Query. OAuth 1.0 is now deprecated.
1.42.10 (interim release)
Bug fixes and driver updates
All platforms
- Fixed an issue where SQS queues were unexpectedly disconnecting.
- Fixed an issue where some jobs were intermittently failing to validate.
- Fixed a PostGreSQL issue where "could not open relation with OID".
- Upgraded Google BigQuery driver to v19.
1.42.8 (interim release)
Bug fixes
All platforms
- Fixed an issue where the creation of a Google OAuth would fail.
- Fixed an issue where Query Result to Grid would sometimes use the wrong database name in Advanced Mode.
Snowflake
- Fixed an issue where the performance of a Matillion ETL instance could deteriorate over time when jobs were running concurrently.
- Fixed an issue where jobs that include a high number transformation jobs running in parallel were not always working as expected.
Redshift
- Fixed an issue where taking metadata from new tables with no encoding set could cause the Table Metadata To Grid component to fail validation.
1.42 (major release)
New features and improvements
All platforms
- New API endpoints for Git in Matillion ETL. Use the Matillion ETL v1 API to initialize and clone repositories, switch branches, and pull and push changes.
- Sage Intacct Query Component allows users to connect to their Sage Intacct data.
- S3 Unload component now supports the Parquet file type
- NetSuite Query now supports OAuth. To learn more, read NetSuite Query Authentication Guide.
- SharePoint Query component now supports OAuth. To learn more, read SharePoint Query Authentication Guide.
- SAP Hana added to the Database Query component.
Snowflake
- Materialized and Secure Views now available from the Create View component.
- S3 Unload component now allows JSON file formats to nest columns.
- Azure Blob Storage Unload component now allows JSON file formats to next columns.
Redshift
- Pardot Component offers a streamlined way of connecting to their Pardot account and querying data.
- Rewrite External Table component now supports the Parquet file type.
- Support added for MySQL driver v8.
Bug fixes and driver updates
Snowflake
- Snowflake Driver updated to 3.9.2
- Support added for MySQL driver v8