Finally, a data transformation solution built for data analysts – use SQL to model and transform data and get one click data testing, lineage, data catalog, versioning and much more.
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 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).