CODEWITHSUNDEEP
databricksdelta-lakedatabricks-sql
Climbs_lika_Spyder
Climbs_lika_Spyder

Reputation: 6754

How do you delete rows in a Delta table using SQL?

I am using Databricks. In my notebook, I have a table (Delta table) and I want to delete all rows where the topic is 'CICD' from my table. I want to use SQL to do it.

Upvotes: 0

Views: 1679

Answers (1)

Climbs_lika_Spyder
Climbs_lika_Spyder

Reputation: 6754

DELETE FROM databasename.my_bronze_table WHERE Topic == 'CICD'

After running the above code, it displayed the number of rows affected.

Upvotes: 1

Related Questions