What is difference between _RAW tables and _APPEND_RAW tables of Bronze-Layer of Azure Databricks

Devsql
New Contributor III

Hi Team,

I would like to know difference between _RAW tables and _APPEND_RAW tables of Bronze-Layer.

As both are STREAMING Tables then why we need 2 separate tables.

Note: we are following Medalion Architecture. Also above tables are created via Delta Live Tables pipeline. so they are basically DLT Tables.

Thanks
Devsql