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

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

BalaRamesh — Fri, 09 May 2025 08:36:12 GMT

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.

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

MuthuLakshmi — Fri, 09 May 2025 09:27:01 GMT

@BalaRamesh

The MVs are stored in metastore root storage location.

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

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

BalaRamesh — Fri, 09 May 2025 10:08:49 GMT

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

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

MuthuLakshmi — Fri, 09 May 2025 15:15:02 GMT

@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