Databricks Community

Hi @FAHADURREHMAN  Please find below my findings  Since you're using Auto Loader (cloudFiles)  this behavior is expected. By default, when you provide a path like: s3://bucket/folder/ Spark recursively reads all subfolders.pathGlo...

The query is not working when using dedicated cluster so please raise a support ticket with the databricks support team. 

Hi @dtb_usr  Can you run the query the same MV from a SQL Warehouse or Shared compute? 

Hi @dtb_usr  Thank you for sharing the error. I understand now. Can you raise a support ticket with the databricks team we need to dig deeper into the issue. 

Hi @dtb_usr  Good day!! Can you share me the error that you are getting when accessing the view.