Humanitec Documentation
WebsiteStatusLogin inGet started
Search…
Introduction
Welcome
How does Humanitec integrate?
What happens if you hit "Deploy"?
Getting Started
Technical Requirements
Create Sample App
Connect own Infrastructure
Work with Sample App
Migrate own App
Guides
Tutorials
Connect CI Setup
Orchestrate Infrastructure
Resource Definitions
Manage Kubernetes Clusters
Manage DNS
Manage Relational Databases
Aiven
Amazon RDS
Azure Database
Google Cloud SQL
Manage Blob Storage
Manage persistent Volumes
Manage Environment Types
Define Namespace Names
Manage Environment Variables and Secrets
Add Configuration as a File on the Container Level
Export Manifests (Humanitec and GitOps)
Manage Users & Permissions
Using Humanitec
Work with Apps
Work with Environments
Work with Workloads
Integrations
Resource Types
Resource Drivers
Create own Resource Driver
Reference
Concepts
User Interface (UI)
Command Line Interface (CLI)
Workload Profiles
Platform API
Troubleshooting
Support Channels
Powered By GitBook
Google Cloud SQL
Learn how to provision databases in instances running in Google Cloud SQL
​Google Cloud SQL is Google's managed SQL database offering.

Prerequisites

  • 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).
  • You must have the CloudSQL Admin API enabled for your project.

Add GCP Account

You can add the GCP account in the Organization Settings.
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. 1.
    Click on the Accounts tab.
  2. 2.
    Select Google Cloud Platform.
  3. 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. 4.
    Once you clicked on Authorize, you will see the account at the top of the accounts list.
New GCP Account
Our CLI is currently in closed beta. Please contact us if you want to learn more.
Accounts can be added via the Create Resource Account endpoint.

Add Resource Definition

You can easily connect Humanitec to a GCP managed database instance. The following paragraph explains how.
UI
CLI
API
  1. 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. 2.
    Below Data storages select Postgres, which opens a dialog.
  3. 3.
    Add a memorable ID for this Resource Definition and select a driver, here - postgres-cloudsql.
  4. 4.
    Below Credentials make sure your GCP account is selected.
  5. 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 Huamnitec will use to create the database.
    • Password. The password for the admin user.
  6. 6.
    Add the values and click Create.
  7. 7.
    Once created, the Resource Definition will appear at the top of the resources list.
Add Resource Definition
Our CLI is currently in closed beta. Please contact us if you want to learn more.
Resource definitions can be created via the Create Dynamic Resource endpoint.

Define Matching

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.
Our CLI is currently in closed beta. Please contact us if you want to learn more.
Matching criteria can be created via the Create new Matching Criteria endpoint.
Previous
Azure Database
Next
Manage Blob Storage
Last modified 10d ago
Copy link
Contents
Prerequisites
Add GCP Account
Add Resource Definition
Define Matching