Create a mapping to write data to Google Cloud Spanner. Use the Google Cloud Spanner connection, and define the write operation properties to write data to Google Cloud Spanner.
You can perform insert, update, delete, and upsert operations on a Google Cloud Spanner target.
To perform a update, delete, or upsert operation, you must add an Update Strategy transformation to a mapping and flag the records in an update strategy expression.
When you run a mapping on the Spark engine, you cannot add an Update Strategy transformation. Hence, you cannot perform update, delete, or upsert operations on a Google Cloud Spanner target when you run a mapping on the Spark engine.
For more information about configuring an Update Strategy transformation, see "Update Strategy Transformation" in the