jonathan rowe

08/18/2023, 1:52 PM
Hi all, I'm looking to truncate a table for unit tests What's the difference between: DeltaTable.delete() api call TRUNCATE TABLE sql DELETE FROM sql I'm guessing TRUNCATE TABLE works the same way as most RDMS and quickly deletes the table files and deletes log, DELETE ALL just deletes every row and can be seen in history or with ASOF DATE And DeltaTable.delete() deletes all rows