Hello,

You can use the Genie statement_id and the Statement Execution API to retrieve the SQL result set, then read result.result.data_array to build your DataFrame.​

A working example is provided in the Databricks Apps Cookbook: https://apps-cookbook.dev/docs/dash/bi/genie_api/

Hope this helps!​