Delta Live tables - If there is no target schema defined , where live tables will create.

[BalaRamesh]

Currently i am working Delta live tables.  one of  my ex - team member designed the job and they did not defined in target schema as empty  in destinations (settings -->destination ---> Target Shema). where delta live tables will create if it is empty.

.

[MuthuLakshmi]

@BalaRamesh 

The MVs are stored in metastore root storage location.

They are stored in the storage for the catalog you specified.

[BalaRamesh]

I am  in beginner. can you please explain me in details pls 

[MuthuLakshmi]

@BalaRamesh 
If you have catalog specified, there will be storage location for that and you will see this MV created there.

Refer to this doc to understand about storage location:

https://docs.databricks.com/aws/en/connect/unity-catalog/cloud-storage/managed-storage