Hi all. I'm getting an error `com.databricks.sql.io.FileReadException` when attempting to create a materialized view which reads tables from two different schemas in the same catalog. Is this just a limitation in databricks or do I potentially have some configuration issue? If I take out any reference to the other schema I'm able to create the view just fine. I can provide a stack trace or more information if necessary.
e.g.
this works:
create materialized view my_catalog.my_schema.kk_test as select * from my_catalog.my_schema.some_table
this does not work:
create materialized view my_catalog.my_schema.kk_test1 as select * from my_catalog.my_other_schema.some_table
(this is a very simplified version, I do actually need data from both schemas)