Skip to content

WriteIntoDelta Command

WriteIntoDelta is a Delta command that can write data(frame) transactionally into a delta table.

WriteIntoDelta is a RunnableCommand (Spark SQL).

Creating Instance

WriteIntoDelta takes the following to be created:

WriteIntoDelta is created when:


WriteIntoDelta is an operation that can update metadata (schema and partitioning) of the delta table.

Executing Command

  sparkSession: SparkSession): Seq[Row]

run is part of the RunnableCommand (Spark SQL) abstraction.

run requests the DeltaLog to start a new transaction.

run writes and requests the OptimisticTransaction to commit (with DeltaOperations.Write operation with the SaveMode, partition columns, replaceWhere and userMetadata).


  txn: OptimisticTransaction,
  sparkSession: SparkSession): Seq[Action]

write checks out whether the write operation is to a delta table that already exists. If so (i.e. the readVersion of the transaction is above -1), write branches per the SaveMode:

  • For ErrorIfExists, write throws an AnalysisException.

    [path] already exists.
  • For Ignore, write does nothing and returns back with no Actions.

  • For Overwrite, write requests the DeltaLog to assert being removable

write updateMetadata (with rearrangeOnly option).


write is used when:


import org.apache.spark.sql.SaveMode
val tableName = "/tmp/delta/t1"
val data = spark.range(5).toDF
val writeCmd = WriteIntoDelta(
  deltaLog = DeltaLog.forTable(spark, tableName),
  mode = SaveMode.Overwrite,
  options = new DeltaOptions(Map.empty[String, String], spark.sessionState.conf),
  partitionColumns = Seq.empty[String],
  configuration = Map.empty[String, String],

// Review web UI @ http://localhost:4040

Last update: 2021-03-26