I have this strange case where data is not written back to data lake.

I have 3 container- . Bronze, Silver and Gold. I have done the mounting and have not problem to read the source data and write it Bronze layer ( using hive meta store catalog).

Then I pick the data from bronze for cleanisng and creating Silver tables and writing it to Silver. In data brick I can query this silver tables but when I check the silver container in azure portal it empty.

Below is the location i use and I have checked multiple times if I use correct storage name and its right one.

LOCATION 'dbfs:/mnt/silver@{{ table.STORAGE_ACCOUNT_NAME }}.dfs.core.windows.net/{{ table.TABLE_SOURCE }}/{{ table.TABLE_NAME }}';