Is there is a difference between Sql Delta table and Databricks Delta table? It looks like for SQL we use the name on a conceptual basis. The table that stores the difference of Base table is Delta. Is it the same for databricks?
4
votes
They are completely different. Can you provide a reference to your "SQL Delta Table" because that's a conceptual thing vs databricks delta which is an actual product
- Nick.McDermaid
wapshere.com/missmiis/how-to-make-a-sql-delta-table
- Blue Clouds
Same concept except that databricks delta does this automatically, but I don't think it has a insert/update/delete flag, just a "point in time" view
- Nick.McDermaid
1 Answers
2
votes
No, Databricks Delta is storage layer that provides ACID transactions & other improvements to store big amounts of data for use with Apache Spark. It used to store complete datasets, that could be updated if necessary. Delta is open source project, with some enhancements available at Databricks platform.
