https://community.databricks.com/t5/data-engineering/depth-of-view-exceeds-the-maximum-view-resolution-depth-100/m-p/11091#M6130 <P>Thank you!</P><P>I found out the root cause for this error is that the view's new definition is trying to join another view which includes a join with this view itself, so it becomes an infinite loop. </P> Wed, 01 Feb 2023 12:54:45 GMT andrew0117 2023-02-01T12:54:45Z https://community.databricks.com/t5/data-engineering/depth-of-view-exceeds-the-maximum-view-resolution-depth-100/m-p/11089#M6128 <P>I got this error after updating a view. How can I increase the value of spark.sql.view.maNestedViewDepth to work around this? </P><P>Thanks!</P> Fri, 20 Jan 2023 04:37:31 GMT https://community.databricks.com/t5/data-engineering/depth-of-view-exceeds-the-maximum-view-resolution-depth-100/m-p/11089#M6128 andrew0117 2023-01-20T04:37:31Z https://community.databricks.com/t5/data-engineering/depth-of-view-exceeds-the-maximum-view-resolution-depth-100/m-p/11091#M6130 <P>Thank you!</P><P>I found out the root cause for this error is that the view's new definition is trying to join another view which includes a join with this view itself, so it becomes an infinite loop. </P> Wed, 01 Feb 2023 12:54:45 GMT https://community.databricks.com/t5/data-engineering/depth-of-view-exceeds-the-maximum-view-resolution-depth-100/m-p/11091#M6130 andrew0117 2023-02-01T12:54:45Z https://community.databricks.com/t5/data-engineering/depth-of-view-exceeds-the-maximum-view-resolution-depth-100/m-p/11090#M6129 <P>Hi, Could you please confirm if you are showing the view? (https://docs.databricks.com/sql/language-manual/sql-ref-syntax-aux-show-views.html) also, it will be helpful if you post the screenshot of the error. </P> Tue, 24 Jan 2023 08:12:56 GMT https://community.databricks.com/t5/data-engineering/depth-of-view-exceeds-the-maximum-view-resolution-depth-100/m-p/11090#M6129 Debayan 2023-01-24T08:12:56Z