We are thrilled to release so many improvements to Meltano this week, with a special focus on bringing greater feature parity between the Command Line Interface (CLI) and the User Interface (UI). Our vision for Meltano spans many roles in a company, often involving cross-team collaboration of a data engineer and a data analyst. Through these improvements, and many more coming in the next few weeks, we look forward to meeting our users where they’re already getting work done every day.

If this is your first time exploring Meltano, you can follow our installation guide and starter tutorial to get going in minutes!

What’s new in 0.19

Meltano UI

• Users can now add new projects within the Meltano UI (previously CLI-only)
• #513 Added initial end-to-end tests for the UI

Extract

• !544 Add support for extracting data from CSV files by adding tap-csv to Meltano

Transform

• #431 Add the tap-zendesk transform to Meltano. It is using the dbt package defined in https://gitlab.com/meltano/dbt-tap-zendesk
• Add the tap-zuora transform to Meltano. It is using the dbt package defined in https://gitlab.com/meltano/dbt-tap-zuora

Analyze

• #431 Add the model-zendesk plugin to Meltano. It includes .m5o files for analyzing data fetched using the Zendesk API. Repository used: https://gitlab.com/meltano/model-zendesk

Orchestrate

• #514 Add ‘airflow’ orchestrators plugin to enable scheduling

For Contributors:

• #327 Add meltano add –custom switch to enable integration of custom plugins

Changes in 0.19

• #455 Updated documentation about target-snowflake

Fixes in 0.19

• #507 Ensure design name and table name don’t need to match so multiple designs can leverage a single base table
• #551 Fix HDA queries generated when an attribute is used both as a column and as an aggregate.
• #559 Add support for running custom transforms for taps without default dbt transforms.

---

Instructions for upgrading to the most current version of Meltano can be found in the version section of our documentation.

To see the full history of improvements to Meltano, please review our CHANGELOG

Each week on Friday morning the Meltano team holds our own “Demo Day”, where we share the improvements we’ve made and discuss the benefits to users.

Many of these improvements will be further described in our upcoming Monday release, but we also share work in progress that may need a few more sprints to be completed.

This week’s release includes the following changes to Meltano.

New

• #432 Add the tap-zuora transform to Meltano. It is using the dbt package defined in https://gitlab.com/meltano/dbt-tap-zuora

Changes

• Remove Snowflake references from advanced tutorial.
• #2 dbt-tap-zuora Remove custom SFDC related attributes from Zuora Account and Subscription Models
• Update Contributing – Code Style documentation to including pycache troubleshooting

Fixes

• #529 Resolve “SFDC Tutorial – ELT Fails due to invalid schema.yml” by #4 dbt-tap-salesforce removing the schema.yml files from the dbt models for tap-salesforce.
• #502 Fix the situation where an m5o has no joins, the design still will work.

---

Instructions for upgrading to the most current version of Meltano can be found in the version section of our documentation.

To see the full history of improvements to Meltano, please review our CHANGELOG

Each week on Friday morning the Meltano team holds our own “Demo Day”, where we share the improvements we’ve made and discuss the benefits to users. Many of these improvements will be further described in our upcoming Monday release, but we also share work in progress that may need a few more sprints to be completed.

In this week’s Demo Day:

• Micael demos our MVC Airflow integration with Meltano, which will deliver “Solo Piano” orchestration capabilities outlined in our opportunity assessment (#514)
• Yannis demos how simple it is to connect Meltano to Jupyter Notebooks (#539) + team discussion of personas who will use this and tutorial plans for Python, Scala, and R
• Jacob demos Meltano UI supporting multiple projects in a single install (crucial for supporting collaboration user stories, as expressed in #516 and #539)
• Discussion of step-by-step guide (wizard) for improve the new user onboarding experience of the Meltano UI

Check out our milestones to see what we’re working on, and learn about what’s coming next for Meltano. If you have suggestions, please file a new issue. Input welcome!

Each week on Friday morning the Meltano team holds our own “Demo Day”, where we share the improvements we’ve made and discuss the benefits to users. Many of these improvements will be further described in our upcoming Monday release, but we also share work in progress that may need a few more sprints to be completed.

In this week’s Demo Day:

• Jacob demos Yannis’ extensive improvements to data for tap-gitlab (#436)
• Jacob demos MVC for `meltano start` to simplify project creation (#419, #484)
• Ben demos discovering/adding taps and targets from the UI (#400, #419)
• Micael demos how users can create/contribute a custom tap (#327)
• Micael lead conversation around underlying complexity and constraints of the things we’ve chosen to integrate, the value of writing the “glue code” for our customers, and how Meltano is differentiated

Check out our milestones to see what we’re working on, and learn about what’s coming next for Meltano. If you have suggestions, please file a new issue. Input welcome!