Hello @Anubhav2011 ,

From your question, it means that you want the output to appear in the Catalog UI as an actual Table, not a Materialized View (MV). In DLT, datasets derived from other DLT datasets are shown as MVs (or Streaming Table). They’re still backed by Delta tables and are managed by Unity Catalog, but DLT controls the refresh strategy and caches results, which lowers query latency and resource usage. This behavior is by design in DLT, intended to simplify and optimize ETL workflows, rather than a limitation. And I don't think there is a way to achieve that workaround.

If you still need a plain table (not shown as MV, but actual Table in UC UI), write it outside DLT logic by reading the DLT output and saving it explicitly:

df = spark.table("workspace.default.processed_trip_mv") # DLT output

# Custom Silver logic...

df.write.mode("overwrite").saveAsTable("workspace.default.processed_trip_actual_table")

Hope that helps, happy to clarify further.

Best, Ilir