Hi @susanne ,
Use Tables Instead of Views: If possible, convert your views to tables.
@dlt.table(
name=target_table,
)
def get_gold_table():
df = spark.sql(f"""{gold_selection}""")
return df
Direct Publish Feature: The Direct Publish feature does not support publishing views to another schema. It is intended for tables and materialized views, which can be published to the catalog.
Solution: To publish data to a different schema, consider using a table or materialized view instead of a view, as these can be written to the catalog.