SQL Warehouse error: "Cannot read properties of undefined (reading 'data')" when querying system tab

kevinleindecker
New Contributor III

‎03-30-2026 11:12 AM

Queries that previously worked started failing in SQL Warehouse (Dashboards) without any changes on our side.

The query succeeds, but fails to render results with error:
"Cannot read properties of undefined (reading 'data')"

This happens with:
- system.billing.usage (when selecting struct fields like identity_metadata.run_as)
- queries with aggregations and joins (even after fixing GROUP BY consistency)

The same query works:
- in notebooks
- when simplified

But fails:
- in SQL Warehouse (dashboard/editor)

This indicates a regression in result rendering or query execution plan.

Example query:

SELECT
  workspace_id,
  sku_name,
  usage_start_time,
  usage_end_time,
  usage_date,
  usage_unit,
  usage_quantity,
  identity_metadata.run_as
FROM system.billing.usage

Error: The query succeeded, but we are unable to display the results due to the following error that occurred while fetching the data: Cannot read properties of undefined (reading 'data').

This same problem is repeated in the Dashboard you suggested in the link https://github.com/databricks/tmm/blob/main/System-Tables-Demo/Lakeflow/LakeFlow%20System%20Tables%2... in the [Operational Observability] Highest Failure Jobs view.