Here’s the difference between Lightdash and Canvas. The comparison is based on pricing, deployment, business model, and other important factors.
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.
Canvas is a collaborative data exploration tool that helps modern business teams make decisions without SQL.