GCP: Can we modify primary key of an existing table in spanner

Question

I want to modify Primary key of an existing Table in Spanner from Col1 to combination of Col1 and Col2. Is it possible to do it in Spanner?

This option is not available in Console. Maybe it can be done with a script!

Answer 1

GCP Team responded below:

• Only way to do it now is to recreate database using Import/Export functionality
• Feature request is raised on Spanner backlog (no ETA): https://issuetracker.google.com/135719292