Google Cloud Spanner Database

google_spanner_database (Terraform)

The Database in Cloud Spanner can be configured in Terraform with the resource name google_spanner_database. The following sections describe 5 examples of how to use the resource and its parameters.

Example Usage from GitHub

ankit25587/course-material

resource "google_spanner_database" "db1"{
    name = "db1"
    instance =  google_spanner_instance.spanner_tf.name

farrukh90/gcp

resource "google_spanner_database" "database" {
  instance            = google_spanner_instance.main.name
  name                = var.config["name"]
  ddl                 = var.databases
  deletion_protection = false
}

bhupeshdavesar/kpmg

resource "google_spanner_database" "database" {
  project  = var.project_id
  instance = var.spanner_instance_name
  name     = var.name
  ddl      = var.ddl

Mirlan777/terraform-google

resource "google_spanner_database" "database" {
    instance = google_spanner_instance.main.name
    name = var.config["name"]
    ddl = var.databases
    deletion_protection = false
}

Taherasharifi/terraform-google

resource "google_spanner_database" "database" {
    instance = google_spanner_instance.main.name
    name = var.config["name"]
    ddl = var.databases
    deletion_protection = false
}

Parameters

• ddl optional - list of string

An optional list of DDL statements to run inside the newly created database. Statements can create tables, indexes, etc. These statements execute atomically with the creation of the database: if there is an error in any statement, the database is not created.

• deletion_protection optional - bool
• id optional computed - string
• instance required - string

The instance to create the database on.

• name required - string

A unique identifier for the database, which cannot be changed after the instance is created. Values are of the form [a-z][-a-z0-9]*[a-z0-9].

• project optional computed - string
• state optional computed - string

An explanation of the status of the database.

• timeouts single block
  • create optional - string
  • delete optional - string
  • update optional - string

Explanation in Terraform Registry

A Cloud Spanner Database which is hosted on a Spanner instance. To get more information about Database, see:

• API documentation
• How-to Guides
  • Official Documentation

    Warning: On newer versions of the provider, you must explicitly set deletion_protection=false (and run terraform apply to write the field to state) in order to destroy an instance. It is recommended to not set this field (or set it to true) until you're ready to destroy. On older versions, it is strongly recommended to set lifecycle { prevent_destroy = true } on databases in order to prevent accidental data loss. See Terraform docs for more information on lifecycle parameters.