How to publish delta live table(DLT) in different catalog instead of hive_metastore

Viewed 35

Hi, community,
  I want to publish(save) the delta live table(DLT) into a different catalog database.
  The following image target field only asks for the database name, not for the catalog. enter image description here

I've referred to documentation but couldn't find anything helpful.

1 Answers

Unity Catalog isn't supported in Delta Live Tables yet - as I remember, it's planned to be released really soon.

Right now, there is a workaround - you can push data into a location on S3 that then could be added as a table in Unity Catalog external location.

P.S. It's not recommended to use default "Storage location" - it won't work with Unity Catalog as it's on DBFS Root. It's better to push it to a S3.

Related