Matillion ETL release notes: v1.40

All platforms

Twitter driver upgraded to support Ads API v5
DoubleClick For Publishers (Google Ads Manager) driver upgraded to support API v201811 and later.
Windows Fileshare SMB2/3 Support for Data Transfer component and File Iterator component.
SAP NetWeaver Query - update to the location of additional files including a "JCo" connection library and the Java wrapper "sapjco3.jar".
Fixed an issue where SAP NetWeaver Query component was not correctly finding associated libraries.
Fixed an issue where HubSpot OAuth registration link would fail.

All platforms

Git functionality allows users to work with local and remote repositories, managing Project Versions as commits and branches seamlessly inside the Matillion ETL client. (Enterprise Only)
UI:
- Changes to error and validation messaging in product.
- Improve plus(+) sign and grid visibility.
- UI Refresh - Tabs with no component selected.
- Keyboard Shortcut Ctrl +A for single-line text input fields.
- Order the Component Tree.
- Add Manage Variables button in Code Editors.
- Filter added to Sample Tab.
- Simple JSON or XML parser for Configure API Profile Dialog.
- All sorting of Project versions in Manage Versions.
Components:
- Add more JDBC Table Metadata To Grid Fields.
- Dynamics CRM Query component now supports CRM2011 accessible from CRM Version dropdown.
- JDBC Incremental Load - Prepopulate URL Field with Connection Prefix.
- Create File Format component has new properties available.
- The API Profile Generator component is now able to find files in the current directory the user is in, rather than specifying the whole path of the file.
Remove row count from Result.java.
AMIs upgraded to Python 3.6.
- Warning: This upgrade may prevent previously-installed Python modules from working. We recommend users install pip3.6 and then reinstall modules.

Snowflake

New data staging components for:
Support for Structured Data
- New Extract Nested Data Component allows users to unpack their nested data structures (such as JSONs) guided by a visual tree structure of the data.
Support for Snowflake Streams:
- Create Stream Orchestration Component creates new Snowflake streams.
- Stream Input Component uses an existing stream to access table data.
Key pair authentication now supported for Snowflake environment credentials.
Azure nc and jq packages are pre-installed.