- 1983 Views
- 3 replies
- 6 kudos
Append to a record when updating Delta Table
I am updating the delta table in Databricks as follows segments_data.alias('segments_old').merge( segments_data_new.alias("updates"), "segments_old.source_url = updates.source_url", ).whenMatchedUpdate( set={"segments"...
- 1983 Views
- 3 replies
- 6 kudos
- 7284 Views
- 9 replies
- 13 kudos
Resolved! Delta table upsert - databricks community
Hello guys,I'm trying to use upsert via delta lake following the documentation, but the command doesn't update or insert newlines.scenario: my source table is separated in bronze layer and updates or inserts are in silver layer.from delta.tables impo...
- 7284 Views
- 9 replies
- 13 kudos
- 13 kudos
I managed to find the solution. In insert and update I was setting the target.tanks @Werner Stinckens​ !delta_df = DeltaTable.forPath(spark, 'dbfs:/mnt/silver/vendas/') delta_df.alias('target').m...
- 13 kudos