Method: connect.generateEphemeralCert

SQL Server, private server access, HDD, data cache, legacy HA, serverless exports, multi-region backups, cross-region replicas are not supported.
Generates a short-lived X509 certificate containing the provided public key and signed by a private key specific to the target instance. Users may use the certificate to authenticate as themselves when connecting to the database.

HTTP request

POST https://sqladmin.s3nsapis.fr/sql/v1beta4/projects/{project}/instances/{instance}:generateEphemeralCert

The URL uses gRPC Transcoding syntax.

Path parameters

Parameters
project

string

Project ID of the project that contains the instance.

instance

string

Cloud SQL instance ID. This does not include the project ID.

Request body

The request body contains data with the following structure:

JSON representation
{
  "public_key": string,
  "access_token": string,
  "readTime": string,
  "validDuration": string
}
Fields
public_key

string

PEM encoded public key to include in the signed certificate.

access_token

string

Optional. Access token to include in the signed certificate.

readTime

string (Timestamp format)

Optional. Optional snapshot read timestamp to trade freshness for performance.

Uses RFC 3339, where generated output will always be Z-normalized and uses 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: "2014-10-02T15:01:23Z", "2014-10-02T15:01:23.045123456Z" or "2014-10-02T15:01:23+05:30".

validDuration

string (Duration format)

Optional. If set, it will contain the cert valid duration.

A duration in seconds with up to nine fractional digits, ending with 's'. Example: "3.5s".

Response body

Ephemeral certificate creation request.

If successful, the response body contains data with the following structure:

JSON representation
{
  "ephemeralCert": {
    object (SslCert)
  }
}
Fields
ephemeralCert

object (SslCert)

Generated cert

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/sqlservice.admin
  • https://www.googleapis.com/auth/cloud-platform

For more information, see the Authentication Overview.