Dashboard extraction fails when Lakeview returns queryLines instead of query #417
Description
Problem Summary:
The EXPORT_ASSESSMENT_TO_EXCEL notebook I created within the UCX installation is currently failing when using Dashboard().get_dashboard().
Root Cause:
I've traced the issue to the lsql library, specifically in Lakeview/model.py. The problem is in the get_dashboard function, which uses the Dashboard and Dataset dataclasses to extract the dashboard name, query, and display name from a Lakeview dashboard.
Specific Issue:
- Expected behavior: The function should return a query statement
- Current behavior: Lakeview dashboards parsed by the
Dashboard().get_dashboard()now returning a list called queryLines instead of a query.
*Result: The query field returns None, causing the notebook to fail.
Sample Error
exporting(Dataset(name='00_1_count_table_failures', query=None, display_name='00_1_count_table_failures')