We are creating a Bronze table on top of ADLS data using Auto Loader with DLT. After that, we create the Silver table using a for-each-batch sink. Finally, we create the Gold table through a DLT materialized view.

However, when creating the Gold table through DLT, we get an error that the Silver table is not found. When we create the Silver table using the normal DLT mode (without the for-each-batch sink), everything works fine.

It seems DLT is unable to recognize whether the sink table has been created. 

Could someone please help me here.