Google Cloud SQL
Learn how to provision databases in instances running in Google Cloud SQL
- You must have a Service Account with the Cloud SQL Client role.
- You must create a key for this service account in JSON form. See Google's account keys documentation for more information. The access key must use the GCP Console/gcloud format (i.e., the first example in the linked documentation).
This guide explains how to connect PostgreSQL via the Google Cloud Platform account. If you need to connect it using a different cloud provider, contact us at [email protected].
UI
CLI
API
- 1.Click on the Accounts tab.
- 2.Select Google Cloud Platform.
- 3.Humanitec will ask you to provide an Account Name (a memorable name that will be displayed for this account) and a Service Account Access Key JSON (see prerequisites).
- 4.Once you clicked on Authorize, you will see the account at the top of the accounts list.
New GCP Account
You can easily connect Humanitec to a GCP managed database instance. The following paragraph explains how.
UI
CLI
API
- 1.Start on the Resources Management screen and click on the Show all resources button. An overlay with all available resource categories and types will be presented to you.
- 2.Below Data storages select Postgres, which opens a dialog.
- 3.Add a memorable ID for this Resource Definition and select a driver, here - postgres-cloudsql.
- 4.
- 5.You will need to supply the following parameters:
- Cloud SQL Instance ID e.g.
my-project:us-central-1:my-instance - Maintenance DB name. This is normally
postgres. It should be a database that the admin user can connect to. - User / Role. This is the username of the admin user that Humanitec will use to create the database.
- Password. The password for the admin user.
- 6.Add the values and click Create.
- 7.Once created, the Resource Definition will appear at the top of the resources list.
Add Resource Definition
Next, you can configure matching criteria for your postgres database. This enables you to define specific environments or applications to be deployed to this resource.
UI
CLI
API
By clicking on your postgres database in the list of resources, the Matching row will expand and allow you to add or remove matching criteria. Each resource can be matched to specific Environment Types, App IDs, Environment IDs or Resource IDs. Empty fields are automatically resolved to match all values of the given category.
Define Matching
Based on this Resource Definition, during the deployment on any of the matching environments, an Active Resource will be provisioned if required.
Last modified 3mo ago