What is "External tables backed by Delta Lake"?

tana_sakakimiya — Mon, 15 Sep 2025 06:35:26 GMT

Goal: event-driven without implementing job triggereed on file arrival

I see hope to incrementally update materialized views which have external tables as their sources.
This is quite a game changer if it works for various data formats.
(since MV started supporting trigger on update recently)

Incremental refresh for materialized views | Databricks on AWS
it mentioned that materialized view support "external table backed by delta lake"

Delta tables, including Unity Catalog managed tables and external tables backed by Delta Lake.

does it mean external source data required to be in delta format? or parquet format data source can be external table backed by delta lake if it is declared as an external table properly?

Re: What is "External tables backed by Delta Lake"?

szymon_dybczak — Mon, 15 Sep 2025 07:20:48 GMT

Hi @tana_sakakimiya ,

Yes, only external tables that are in delta format are supported. Databricks supports other table formats, but to be able to use this particular feature, your table needs to be in Delta format.

But if you have parquet files it's really easy to convert them to delta format, so that shouldn't be an issue here.

topic Re: What is "External tables backed by Delta Lake"? in Data Engineering

What is "External tables backed by Delta Lake"?

Re: What is "External tables backed by Delta Lake"?