Here’s the difference between Stitch and Lightdash. The comparison is based on pricing, deployment, business model, and other important factors.
Stitch provides extract, transform and Load (ETL) as a service for developers to securely manage the data preparation process. It allows users to configure their own data pipeline in a way that balances replication frequency and data selection by choosing the tables, fields, collections, and endpoints required in the warehouse. The product offers replicate API, monitoring & alerting during ETL process, security, compliance, cross-platform integration, and private infrastructure.
Lightdash removes the gap between your data transformation layer and your data visualization layer. It enables data analysts and engineers to control all of their business intelligence (data transformations/business logic as well as data visualization) in a single place. Lightdash integrates with your dbt project and gives a framework for defining metrics and specifying joins between models all within your existing dbt YAML files. The data output from your dbt project is then available for exploring and sharing in Lightdash.