Empower your data analytics team to transform data safely and easily.

With Montara, data engineers can enable the data analytics team to transform and model data while making sure that changes are done properly, with the right checks and balances in place.

Scale your data analytics capabilities safely and easily with Montara: data analysts transform and model data with the power of SQL while the platform seamlessly provides the benefits of software development best practices such as code versioning, review and approval processes, automated testing and documentation, lineage, automatic CI/CD and more.

Transform data with SQL

Montara lets data analysts write pure SQL queries to quickly and easily model and transform data and build out data pipelines without the need to learn new technologies, maintain configuration files or require help and support from data engineers. Analysts can preview models while developing to make everything is valid and accurate, all within Montara and in the flow of work.

Data testing and validation

To ensure quality code and clean data, Montara makes is extremely easy to test and validate models, transformations and data pipelines while developing, before deploying changes to production. With Montara analysts can easily set up data validation tests to automatically run when models are executed as part of pipeline runs. Team members can also build custom tests as well as build complex ad-hoc analysis queries to run against test pipeline runs or the production environment for added testing and validation.

Automated CI/CD

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.

Data lineage and catalog

Montara provides a powerful data lineage view all the way down to 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.

Deploy with Confidence

With Montara it’s easy to develop, manage and run data pipelines. Montara supports review and approval processes so that admins can verify that code adheres to best practices, models have tests, solid documentation and return the right results in a test environment. Approved pipelines can run in multiple ways: manually, on a schedule or by triggering the pipeline from external sources (e.g. when a data ingestion job ends).