API for Generating Links to Explore Results in Lightdash

[yu-iskw]

Description

Introduce an API endpoint in Lightdash that generates a link to an explore result, similar to the RunSqlQuery API, but instead of returning the resulting data, it provides a URL to the explore view on Lightdash.

What problem does this solve?

Currently, Lightdash offers the RunSqlQuery API to obtain the results of a query directly. However, users may want to programmatically explore data in Lightdash by accessing or sharing a link to the explore result on the Lightdash platform without needing to save the chart. This feature will enhance usability by allowing users to quickly navigate to the explore view, facilitating data exploration and collaboration.

https://docs.lightdash.com/api/v1/#tag/Exploring/operation/RunSqlQuery