Renu_
Valued Contributor II

The issue could be because your JDBC driver doesn’t recognize Unity Catalog’s MATERIALIZED_VIEW table type, leading to this error. Try upgrading the Databricks JDBC driver which includes support for Unity Catalog features. You can also add UseNativeQuery=0 to your JDBC options to avoid native query parsing conflicts. And make sure your local Spark configuration aligns with Unity Catalog settings like access mode and permissions.