Delta live table segregation

Frustrated_DE
New Contributor III

Hi,

   I've recently been prototyping on Databricks, I was hoping to develop using DLT pipelines in medallion architecture but with isolation of bronze/silver & gold layers in different catalogs in UC for security purposes.

At the moment is there a limitation whereby you are only able to use one DLT pipeline with a one to one relationship with a schema i.e all my tables will have to reside in the one schema?

Am I missing something obvious or is this the case? Any advice appreciated

tyler-xorbix
Databricks Partner

Hi @Frustrated_DE ,

This seems to be a long-requested feature based on this previous post: Solved: Re: DLT pipeline - Databricks Community - 45740
An alternative solution maybe to delegate permissions on the table level for this pipeline specifically. Mirror the permissions given for each catalog onto each table instead.