Here’s the difference between Fivetran and Lightdash. The comparison is based on pricing, deployment, business model, and other important factors.
Provider of cloud-based data integration solutions for analytics teams. The product offered by the company is a cloud middleware that integrates data from various SaaS services and databases into a single data warehouse. It also allows end-users to use their spreadsheets as databases. The features of the product include automated schema migrations, data integration management, 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.