I have a Databricks app that makes calls to Genie API, it successfully returns a response containing the text response and the generated SQL query. However, the actual result of the SQL query is missing, in the result object, there is the metadata for the result but the data array is None.
result=ResultData(byte_count=None, chunk_index=0, data_array=None, external_links=[], next_chunk_index=None, next_chunk_internal_link=None, row_count=1, row_offset=0)
When I inspect in monitoring, there is also no SQL result whereas if I use the exact same prompt in the Genie web interface then there is a result (As shown in the attached screenshots).
Any idea of the issue here?
