DLT Direct Publishing Mode

[804082]

Hello,

I'm working on a DLT pipeline and have a block of SQL that runs...

USE CATALOG catalog_a;
USE SCHEMA schema_a;
CREATE OR REFRESH MATERIALIZED VIEW table_a AS
SELECT ... FROM catalog_b.schema_b.table_b;

Executing this block returns the following...

com.databricks.pipelines.common.errors.DLTSparkException: [UNSUPPORTED_COMMAND_IN_NON_DPM_PIPELINE] USE CATALOG only supported in direct publishing mode enabled DLT pipeline

I can't find any documentation or mention of this error, or anything about enabling "direct publishing mode". Any idea as to how to do that? Or is there another recommended/possible way to create a materialized view using data from another catalog?

Thanks in advance.

[gchandra]

Direct Publishing Mode is a Private Preview feature. 

Till it becomes Public Preview or GA, please remove the USE Catalog and Use Schema and try catalog.schema.view  

[804082]

Ah, thank you! I couldn't find anything about Direct Publishing Mode through my Google search (in fact, if you search it now, this post is the top result).

I believe I'll be waiting until it goes into public preview/GA. Removing USE CATALOG and USE SCHEMA, and instead using catalog.schema.view, returns...

org.apache.spark.sql.catalyst.ExtendedAnalysisException: Unsupported SQL statement for table 'catalog.schema.view': Multipart table names is not supported.