Use SQL to transform and model data. Montara lets you write pure SQL queries to quickly and easily model data and build out your data pipeline without the need to learn new technologies, maintain configuration files or require help and support from data engineers. Preview your models while developing to make sure your models are valid and accurate, all within Montara and in the flow of work.

Test and validate your models, transformations and data pipelines while developing, before deploying changes to your pipelines and to production. Montara lets you easily set up data validation tests as part of modeling your data to automatically run when your models are executed as part of pipeline runs. You can also build custom tests as well as build complex ad-hoc analysis queries to run against test pipeline runs or your production environment.

With Montara, Continuous Integration (CI) and Continuous Deployment (CD) are handled by the platform transparently. Data analysts focus on modeling and analyzing data without having to worry about code versioning or maintaining code repositories. Deploying changes to models and pipelines is simple and easy, including the ability to deploy pipelines to a test environment to verify that everything looks good before deploying to production.

Montara provides a powerful data lineage view all the way down to your reports and dashboards with our unique report-level lineage capability. Integrate your reporting tool (such as Tableau and Looker) with Montara and get a clear understanding of how changes to models impact analysis, reports and dashboards.

Montara also automatically generates a data catalog that documents all your models, including giving you the ability to annotate columns while developing your models so that stakeholders in the organization can easily collaborate and use models in their analysis.

With Montara it’s easy to develop, manage and run data pipelines. Montara automatically infers and sets up your data pipeline from your models as and allows you to set up pipelines manually and visually. You can run every pipeline in multiple ways: manually, on a schedule or by triggering the pipeline from external sources (e.g. when your data ingestion job ends). You can also trigger any external process at the end of a Montara pipeline run easily (for example, trigger a dashboard refresh post-pipeline run).

Montara lets data teams deploy with confidence: Preview any changes to models before deployment, test complete pipelines with a click of a button in an isolated test environment automatically set up by Montara and verify the data using powerful analysis capabilities to make sure code and data you push to your production environment behaves correctly and data is clean and accurate.

Give team members access to the right data and capabilities with robust governance controls. With Montara, admins can limit who can access certain models and data, enable specific team members to run and manage pipelines or run analysis on data and more. With detailed auditing capabilities, administrators can see resource consumption of models, pipelines or queries to verify that everything runs smoothly, efficiently and according to organizational policies.