https://community.databricks.com/t5/data-engineering/what-is-difference-between-raw-tables-and-append-raw-tables-of/m-p/78487#M35538 <P>I don't exactly understand your question, so let me try to give you a generic answer. You don't need to do anything, if you're fine with working with one table, then just go with one.</P><P>An append-only table, as the name suggests, will only contain insert operations. By using the table property "delta.appendOnly" you can also force it.</P><P>And "a not-only append" table, obviously, might contain next to inserts, also updates and deletes.</P><P>In general, there's no right or wrong answer, as it highly depends on your use case/architecture.</P> Fri, 12 Jul 2024 09:30:07 GMT Witold 2024-07-12T09:30:07Z https://community.databricks.com/t5/data-engineering/what-is-difference-between-raw-tables-and-append-raw-tables-of/m-p/78486#M35537 <P>Hi Team,</P><P>I would like to know difference between _RAW tables and _APPEND_RAW tables of Bronze-Layer.</P><P>As both are STREAMING Tables then why we need 2 separate tables.</P><P>Note: we are following Medalion Architecture. Also above tables are created via Delta Live Tables pipeline. so they are basically DLT Tables.</P><P>Thanks<BR />Devsql</P> Fri, 12 Jul 2024 10:11:19 GMT https://community.databricks.com/t5/data-engineering/what-is-difference-between-raw-tables-and-append-raw-tables-of/m-p/78486#M35537 Devsql 2024-07-12T10:11:19Z https://community.databricks.com/t5/data-engineering/what-is-difference-between-raw-tables-and-append-raw-tables-of/m-p/78487#M35538 <P>I don't exactly understand your question, so let me try to give you a generic answer. You don't need to do anything, if you're fine with working with one table, then just go with one.</P><P>An append-only table, as the name suggests, will only contain insert operations. By using the table property "delta.appendOnly" you can also force it.</P><P>And "a not-only append" table, obviously, might contain next to inserts, also updates and deletes.</P><P>In general, there's no right or wrong answer, as it highly depends on your use case/architecture.</P> Fri, 12 Jul 2024 09:30:07 GMT https://community.databricks.com/t5/data-engineering/what-is-difference-between-raw-tables-and-append-raw-tables-of/m-p/78487#M35538 Witold 2024-07-12T09:30:07Z https://community.databricks.com/t5/data-engineering/what-is-difference-between-raw-tables-and-append-raw-tables-of/m-p/78497#M35539 <P>Hi <a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/107959">@Witold</a> , I updated last line of my above post, added below lines: Also above tables are created via <STRONG>Delta Live Tables</STRONG> pipeline. so they are basically DLT Tables. Hope this gives you proper idea.</P> Fri, 12 Jul 2024 10:12:48 GMT https://community.databricks.com/t5/data-engineering/what-is-difference-between-raw-tables-and-append-raw-tables-of/m-p/78497#M35539 Devsql 2024-07-12T10:12:48Z https://community.databricks.com/t5/data-engineering/what-is-difference-between-raw-tables-and-append-raw-tables-of/m-p/78506#M35541 <P>Hi <a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/9">@Retired_mod</a> , I saw your replies to other posts, so thought to ask you....would you like to help me on this...!!!</P> Fri, 12 Jul 2024 11:00:09 GMT https://community.databricks.com/t5/data-engineering/what-is-difference-between-raw-tables-and-append-raw-tables-of/m-p/78506#M35541 Devsql 2024-07-12T11:00:09Z https://community.databricks.com/t5/data-engineering/what-is-difference-between-raw-tables-and-append-raw-tables-of/m-p/78994#M35651 <P>Thank you very much <a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/9">@Retired_mod</a> for this excellent answer.</P> Tue, 16 Jul 2024 14:01:28 GMT https://community.databricks.com/t5/data-engineering/what-is-difference-between-raw-tables-and-append-raw-tables-of/m-p/78994#M35651 Devsql 2024-07-16T14:01:28Z