Database / Google Spanner Database Interview questions
How do you create a database in Google Spanner?
A database is created inside an existing instance, either through the Cloud Console, the gcloud CLI, or a client library, and it requires choosing the dialect up front.
gcloud spanner databases create orders-db \ --instance=prod-instance \ --database-dialect=GOOGLE_STANDARD_SQL
You can optionally pass an initial DDL file to create tables at the same time the database is created. After creation, further schema changes are applied as separate DDL statements, which Spanner runs online without blocking reads or writes on unrelated tables. Access to the new database is then controlled through IAM roles or, for finer granularity, database roles defined with GRANT statements.
What must be chosen when a Spanner database is created?
How are later schema changes applied to a Spanner database?
More Related questions...
