Metric views materialization failure

Data Engineering

Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.

Hi, I have metric views with materilization option, it was running fine but today it just failed without any change to my metric view definition, all metric views are failing so I guess is something general. Based on limited logs (users can´t fully audit DLT code) looks like clustering columns required by user are not being added to stats columns.

Thank you in advance

Here is an example of how materializations are defined in yml file:

materialization:
  schedule: CRON '30 0 5 ? * Mon' AT TIME ZONE 'UTC'
  mode: relaxed
  materialized_views:
    - name: baseline
      type: unaggregated
      cluster_by:
        auto: false
        cols:
          - Travel Month
          - Operating Carrier
          - Departure Airport IATA
          - Arrival Airport IATA