» google_sql_database
Creates a new Google SQL Database on a Google SQL Database Instance. For more information, see the official documentation, or the JSON API.
» Example Usage
Example creating a SQL Database.
resource "google_sql_database_instance" "master" {
name = "master-instance"
settings {
tier = "D0"
}
}
resource "google_sql_database" "users" {
name = "users-db"
instance = "${google_sql_database_instance.master.name}"
charset = "latin1"
collation = "latin1_swedish_ci"
}
» Argument Reference
The following arguments are supported:
-
project
- (Optional) The ID of the project in which the resource belongs. If it is not provided, the provider project is used. -
charset
- (Optional) The charset value. See MySQL's Supported Character Sets and Collations and Postgres' Character Set Support for more details and supported values. Postgres databases are in beta and have limitedcharset
support; they only support a value ofUTF8
at creation time. -
collation
- (Optional) The collation value. See MySQL's Supported Character Sets and Collations and Postgres' Collation Support for more details and supported values. Postgres databases are in beta and have limitedcollation
support; they only support a value ofen_US.UTF8
at creation time.
» Attributes Reference
In addition to the arguments listed above, the following computed attributes are exported:
-
self_link
- The URI of the created resource.
» Import
SQL databases can be imported using one of any of these accepted formats:
$ terraform import google_sql_database.database projects/{{project}}/instances/{{instance}}/databases/{{name}}
$ terraform import google_sql_database.database {{project}}/{{instance}}/{{name}}
$ terraform import google_sql_database.database instances/{{name}}/databases/{{name}}
$ terraform import google_sql_database.database {{instance}}/{{name}}
$ terraform import google_sql_database.database {{name}}