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

BalaRamesh
New Contributor II

‎05-09-2025 01:36 AM

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.

 

BalaRamesh_0-1746779647873.png

 

.

 

 

0 Kudos

MuthuLakshmi
Databricks Employee
Databricks Employee

‎05-09-2025 02:27 AM

@BalaRamesh 

The MVs are stored in metastore root storage location.

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

0 Kudos

BalaRamesh
New Contributor II
In response to MuthuLakshmi

‎05-09-2025 03:08 AM

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

0 Kudos

MuthuLakshmi
Databricks Employee
Databricks Employee

‎05-09-2025 08:15 AM

@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

0 Kudos