spannerdataupdater

Overview ¶

Provides a method for executing long-running Partitioned DML statements, as needed to perform data backfills after schema changes to Spanner tables.

Provided because the gcloud command:

gcloud spanner databases execute-sql --enable-partitioned-dml --sql="<SQL>"

does not support long running statements (beyond ~40 mins or so), regardless of the timeout paramater specified.

Example usage:

go run main.go \
 -sql='UPDATE TestResults SET <Something> WHERE <Something Else>' \
 -project=chops-weetbix-dev -instance=dev -database=chops-weetbix-dev