Hi Zhing Hang,

I assume you can access the data you need from Databricks through an API. In that case, you can indeed create an ad hoc data source to fetch that data and use it in your dashboard.

There is a tutorial available which does the same thing, instead of using the Databricks API it uses another API (to fetch data about satellites), but conceptionally it's the same:

Written tutorial: https://docs.dataminer.services/user-guide/Advanced_Modules/Dashboards_and_Low_Code_Apps/GQI/Extensions/Ad_hoc_data/Ad_hoc_Tutorials_Satellites.html

Video format: https://community.dataminer.services/video/kata-4-build-your-first-gqi/

Were you able to check/find these examples (helpful)?

Edit: Do note that the tutorial and video don't go to much in detail about actually fetching the data from the API. But once you have that 'example' downloaded from the catalog, you can take a look at how the implementation works. -> Let me know if you have additional questions.

    private IReadOnlyList<Satellite> FetchSatellites()
    {
        var request = WebRequest.Create(URL);
        using (var response = request.GetResponse())
        using (var stream = response.GetResponseStream())
        using (var reader = new StreamReader(stream, Encoding.Default))
        {
            return ReadSatellites(reader, true);
        }
    }

Hope this helps!

Best regards,

Ward