Spanner

Schema of the TABLE `orders`

Migrate Cloud for MySQL database to Spanner. Concept: https://cloud.google.com/solutions/migrating-mysql-to-cloudsql-concept

Leaderboard

.https://google.qwiklabs.com/focuses/1815?parent=catalog

CREATE TABLE Players (
  PlayerId INT64 NOT NULL,
  PlayerName STRING(2048) NOT NULL,
) PRIMARY KEY(PlayerId);

CREATE TABLE Scores (
  PlayerId INT64 NOT NULL,
  Score INT64 NOT NULL,
  Timestamp TIMESTAMP NOT NULL OPTIONS (
    allow_commit_timestamp = true
  ),
) PRIMARY KEY(PlayerId, Timestamp),
  INTERLEAVE IN PARENT Players ON DELETE NO ACTION

Vs

If there are multiple data stores, we prefer spanner over BigTable.