Spanner sink connector: updatedTimestamp Not able to set

Kafka Connect Self-Managed Connectors
1

Hi team,

I am using the Google Cloud Spanner Sink Connector.

My requirement is to automatically update the updated_time_stamp column in my Spanner table to the commit timestamp whenever the sink connector updates a row.

I have give my connector configuration insert.mode = upsert.

As per the Spanner documentation, this can be achieved by:
Commit timestamps in GoogleSQL-dialect databases | Spanner | Google Cloud

  • Using PENDING_COMMIT_TIMESTAMP() in DML statements, or

  • Setting the value to Value.COMMIT_TIMESTAMP when building mutations.

However, I do not see any configuration option in the Spanner Sink Connector that allows specifying PENDING_COMMIT_TIMESTAMP or Value.COMMIT_TIMESTAMP for a column.

Could you confirm whether this is currently supported, or suggest a recommended approach to achieve this?

Any guidance or examples would be greatly appreciated.

Thanks,
Lakshman