Here’s the difference between Prefect and Lightdash. The comparison is based on pricing, deployment, business model, and other important factors.
Prefect offers an open-source data flow automation platform. The product offerings include Prefect Core, to run data applications, built on Python and composed of a task library that enables looping, adding parameters, mapping dynamic tasks, and more. Another offering is Prefect Cloud, a command center for user workflows enabled by Cloud UI, state locking, hybrid execution, GraphQL for ETL, and more. The clients of the company include CISCO, SymphonyRM, trademe, etc.
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.
|Categories||Workflow Orchestration||Metrics Store, Business Intelligence (BI)|
|Stage||Early Stage||Early Stage|
|Target Segment||Enterprise, Mid size||Mid size, SMBs|
|Deployment||SaaSOn Prem||Open source|
|Business Model||Open Source||Open Source|
|Pricing||Freemium, Contact Sales||Freemium|
|Companies using it|