Fixed an issue where a recent Redshift update changing the Redshift cluster schema prevented Matillion ETL from using External Tables via Amazon Spectrum.
Fixed an issue where certain Matillion ETL functions such as Migrate, Python Script, and COPY INTO commands may have caused instance credentials to be stored in log files.
Updated Google Ad Manager Query from API v201905 to API v201908, anticipating the deprecation of v201905 in June 2020. Users can override this version change using the "Version" connection option.
Project Admin role has been added to External Security users.
New data sources have been added to the Zendesk Query component: group_memberships, groups, satisfaction_ratings, sla_policies, tags, ticket_audits, ticket_comments, ticket_fields, ticket_forms, ticket_metrics_events_incremental.
Bug fixes
All platforms
Fixed an issue where the Data Transfer component would fail to maintain a connection when loading from Sharepoint.
Fixed an issue where the Zendesk Query component was bringing in erroneously-empty date fields.
Fixed an issue where Twitter Query component was attempting to use an outdated version of the AdStats data source.
Fixed the following error related to the Google Ad Manager Query component: "Error parsing int value [null]".
Non-functional 'FromFriendlyName' columns have been removed from the Gmail Query component data sources.
Fixed an issue that affected column names generated by the Extract Nested Data component, which caused issues where jobs containing this component would break if created before 1.44.
Amplitude Extract component allows users to connect to their Amplitude account and load their data into tables.
Box Extract component allows users to collect data regarding their stored files in Box and load it into tables.
Dropbox Extract allows users to collect data regarding their stored files in Dropbox and load it into tables.
Job Start Control empowers users to "prevent duplicate job" runs by selecting this option in the Manage Schedules dialog. When selected, "prevent duplicate job" allows users to specify that a scheduled job run should not be queued if that same job from a previous schedule is still running, thus preventing duplicates from stacking up in the queue.
Box and Dropbox have been added as "source" options to the Data Transfer component, allowing users to move their stored files between cloud services.
An Add New Data Sources dialog has been added to the Google Analytics Query component, allowing users a way of adding new tables to the Data Sources property without the need to deal with custom schemas.
Git Credentials can now be stored so that users don't need to re-enter credentials every time they want to fetch or push a branch.
Project Admin role has been added to users defined in Internal Security configuration, allowing users with this role to see and access all projects regardless of the project privacy settings.
Snowflake
Snowflake private key "passphrase" protection is now available when connecting to Snowflake, offering users an additional layer of security.