<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic ProfilingError: SPARK_ERROR. Spark encountered an error while refreshing metrics. in Data Engineering</title>
    <link>https://community.databricks.com/t5/data-engineering/profilingerror-spark-error-spark-encountered-an-error-while/m-p/155753#M54305</link>
    <description>&lt;P&gt;I've a table with the following profiling settings&lt;/P&gt;&lt;PRE&gt;{&lt;BR /&gt;  "status": "MONITOR_STATUS_ACTIVE",&lt;BR /&gt;  "profile_metrics_table_name": "edw_prd_aen.silver.fct_retail_permit_profile_metrics",&lt;BR /&gt;  "drift_metrics_table_name": "edw_prd_aen.silver.fct_retail_permit_drift_metrics",&lt;BR /&gt;  "dashboard_id": "01f0ae86bd4c1fc6b95db17d44a13cf6",&lt;BR /&gt;  "schedule": {&lt;BR /&gt;    "quartz_cron_expression": "51 0 12 * * ?",&lt;BR /&gt;    "timezone_id": "Asia/Dubai"&lt;BR /&gt;  },&lt;BR /&gt;  "assets_dir": "...",&lt;BR /&gt;  "output_schema_name": "edw_prd_aen.silver",&lt;BR /&gt;  "table_name": "edw_prd_aen.silver.fct_retail_permit",&lt;BR /&gt;  "notifications": {&lt;BR /&gt;    "on_failure": {&lt;BR /&gt;      "email_addresses": [&lt;BR /&gt;        "..."&lt;BR /&gt;      ]&lt;BR /&gt;    }&lt;BR /&gt;  },&lt;BR /&gt;  "time_series": {&lt;BR /&gt;    "granularities": [&lt;BR /&gt;      "1 week"&lt;BR /&gt;    ],&lt;BR /&gt;    "timestamp_col": "_ingest_date"&lt;BR /&gt;  },&lt;BR /&gt;  "monitor_version": "0",&lt;BR /&gt;  "custom_metrics": [],&lt;BR /&gt;  "slicing_exprs": []&lt;BR /&gt;}&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I added a new column to the table and the refresh has started failing with the following error.&lt;/P&gt;&lt;PRE&gt;ProfilingError: SPARK_ERROR. Spark encountered an error while refreshing metrics.&lt;/PRE&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dhruv22_0-1777435414693.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/26499i0CBFC38AFAB7BFD9/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Dhruv22_0-1777435414693.png" alt="Dhruv22_0-1777435414693.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
    <pubDate>Wed, 29 Apr 2026 04:03:56 GMT</pubDate>
    <dc:creator>Dhruv-22</dc:creator>
    <dc:date>2026-04-29T04:03:56Z</dc:date>
    <item>
      <title>ProfilingError: SPARK_ERROR. Spark encountered an error while refreshing metrics.</title>
      <link>https://community.databricks.com/t5/data-engineering/profilingerror-spark-error-spark-encountered-an-error-while/m-p/155753#M54305</link>
      <description>&lt;P&gt;I've a table with the following profiling settings&lt;/P&gt;&lt;PRE&gt;{&lt;BR /&gt;  "status": "MONITOR_STATUS_ACTIVE",&lt;BR /&gt;  "profile_metrics_table_name": "edw_prd_aen.silver.fct_retail_permit_profile_metrics",&lt;BR /&gt;  "drift_metrics_table_name": "edw_prd_aen.silver.fct_retail_permit_drift_metrics",&lt;BR /&gt;  "dashboard_id": "01f0ae86bd4c1fc6b95db17d44a13cf6",&lt;BR /&gt;  "schedule": {&lt;BR /&gt;    "quartz_cron_expression": "51 0 12 * * ?",&lt;BR /&gt;    "timezone_id": "Asia/Dubai"&lt;BR /&gt;  },&lt;BR /&gt;  "assets_dir": "...",&lt;BR /&gt;  "output_schema_name": "edw_prd_aen.silver",&lt;BR /&gt;  "table_name": "edw_prd_aen.silver.fct_retail_permit",&lt;BR /&gt;  "notifications": {&lt;BR /&gt;    "on_failure": {&lt;BR /&gt;      "email_addresses": [&lt;BR /&gt;        "..."&lt;BR /&gt;      ]&lt;BR /&gt;    }&lt;BR /&gt;  },&lt;BR /&gt;  "time_series": {&lt;BR /&gt;    "granularities": [&lt;BR /&gt;      "1 week"&lt;BR /&gt;    ],&lt;BR /&gt;    "timestamp_col": "_ingest_date"&lt;BR /&gt;  },&lt;BR /&gt;  "monitor_version": "0",&lt;BR /&gt;  "custom_metrics": [],&lt;BR /&gt;  "slicing_exprs": []&lt;BR /&gt;}&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I added a new column to the table and the refresh has started failing with the following error.&lt;/P&gt;&lt;PRE&gt;ProfilingError: SPARK_ERROR. Spark encountered an error while refreshing metrics.&lt;/PRE&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dhruv22_0-1777435414693.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/26499i0CBFC38AFAB7BFD9/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Dhruv22_0-1777435414693.png" alt="Dhruv22_0-1777435414693.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 29 Apr 2026 04:03:56 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/profilingerror-spark-error-spark-encountered-an-error-while/m-p/155753#M54305</guid>
      <dc:creator>Dhruv-22</dc:creator>
      <dc:date>2026-04-29T04:03:56Z</dc:date>
    </item>
  </channel>
</rss>

