Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2024 09:25 AM
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 pipelineI 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.