What's New & Latest Features | Matillion ETL for Snowflake

What’s New

  • 05-10-2017 [1.29] New Data Load Components, File Browser Enhancements, Advanced Connection Options and more
    • Matillion ETL for Snowflake Introduces the ability to configure Matillion ETL in a highly available topology with fully active-active cluster. This feature is only available on large and xlarge instance types.
      • Jobs run from SQS, the API or the built-in Scheduler will now fail-over in the event of an instance failure.
      • Scheduled runs missed because a server is offline will be run when it becomes available again
      • Once two or more members are in the cluster, a Cluster Info tab shows membership status and activity.
      • OAuth tokens, Database Drivers and RSD Profiles are replicated via the persistence database (postgres)
      • Logging from each node is sent to Cloudwatch
    • New Jira Query component loads data from Atlassian’s popular Software Development Platform.
    • New PayPal Query component can load payment and other data from Paypal Business accounts.
    • New ServiceNow Query component loads data from Servicenow’s IT Service Management (ITSM) platform.
    • New Stripe Query component loads data from Stripe’s payment platform
    • New Email Query component can query an IMAP based email system.
    • New YouTube Analytics component can query data from the YouTube Analytics API.
    • All query components now allow you to override the output table so you can specify an existing table to load or append to.
    • Excel Query can now load files from Google Cloud Storage, as well as Amazon S3
      • You only see S3 and/or GCS when you have credentials in the environment, otherwise they are hidden.
    • New option to drop a schema from the Environment Tree.
    • Specify a region in S3 Unload (to allow writing to buckets to other regions)
    • S3 / Google Cloud Storage file browser enhancements
    • Set advanced connection options during OAuth flow (e.g. to connect to a Salesforce Sandbox)
    • Warning: Manage Backups and View Audit haven’t been removed, they have been moved to the Admin menu
    • Map Values component
    • Additional support for ORC file types