cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

DLT with Unity Catalog: Multipart table name

Pierre1
New Contributor

Hello,

I can't seem to find up to date info on how to handle catalog.schema.table in DLT live table and Unity catalog.

My statement is the following and is failing with the error: Multipart table name is not supported. Any workaround possible?

Thanks a lot Pierre

 

 

 

create or replace streaming live table `prcatalog`.`dlt-bronze`.raw_traffic_dl2
TBLPROPERTIES( 'quality' = 'bronze')
as select *
from cloud_files(
  'abfss://pr-dlt-landing@fsdlapidpoc.dfs.core.windows.net/raw_traffic',
  'csv'
);

 

 

 

 

1 REPLY 1

szymon_dybczak
Contributor III

Hi @Pierre1 ,

Actually, you don't provide this infromation in the code. You specify this information when you create dlt pipeline.

If you do not select a catalog and target schema for a pipeline, tables are not published to Unity Catalog and can only be accessed by queries in the same pipeline.

Slash_0-1722599160969.png

For more information take a look on below documentation entry:

Use Unity Catalog with your Delta Live Tables pipelines - Azure Databricks | Microsoft Learn

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group