Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Google Cloud (GCP) Classic
  3. API Docs
  4. sql
  5. getDatabaseInstances
Google Cloud v8.27.0 published on Thursday, Apr 17, 2025 by Pulumi
pulumi/pulumi-gcp

gcp.sql.getDatabaseInstances

Explore with Pulumi AI

gcp logo
Google Cloud v8.27.0 published on Thursday, Apr 17, 2025 by Pulumi
pulumi/pulumi-gcp

    Use this data source to get information about a list of Cloud SQL instances in a project. You can also apply some filters over this list to get a more filtered list of Cloud SQL instances.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as gcp from "@pulumi/gcp";

const qa = gcp.sql.getDatabaseInstances({
    project: "test-project",
});

    import pulumi
import pulumi_gcp as gcp

qa = gcp.sql.get_database_instances(project="test-project")

    package main

import (
	"github.com/pulumi/pulumi-gcp/sdk/v8/go/gcp/sql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.GetDatabaseInstances(ctx, &sql.GetDatabaseInstancesArgs{
			Project: pulumi.StringRef("test-project"),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Gcp = Pulumi.Gcp;

return await Deployment.RunAsync(() => 
{
    var qa = Gcp.Sql.GetDatabaseInstances.Invoke(new()
    {
        Project = "test-project",
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.sql.SqlFunctions;
import com.pulumi.gcp.sql.inputs.GetDatabaseInstancesArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var qa = SqlFunctions.getDatabaseInstances(GetDatabaseInstancesArgs.builder()
            .project("test-project")
            .build());

    }
}

    variables:
  qa:
    fn::invoke:
      function: gcp:sql:getDatabaseInstances
      arguments:
        project: test-project

    Using getDatabaseInstances

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getDatabaseInstances(args: GetDatabaseInstancesArgs, opts?: InvokeOptions): Promise<GetDatabaseInstancesResult>
function getDatabaseInstancesOutput(args: GetDatabaseInstancesOutputArgs, opts?: InvokeOptions): Output<GetDatabaseInstancesResult>
    def get_database_instances(database_version: Optional[str] = None,
                           project: Optional[str] = None,
                           region: Optional[str] = None,
                           state: Optional[str] = None,
                           tier: Optional[str] = None,
                           zone: Optional[str] = None,
                           opts: Optional[InvokeOptions] = None) -> GetDatabaseInstancesResult
def get_database_instances_output(database_version: Optional[pulumi.Input[str]] = None,
                           project: Optional[pulumi.Input[str]] = None,
                           region: Optional[pulumi.Input[str]] = None,
                           state: Optional[pulumi.Input[str]] = None,
                           tier: Optional[pulumi.Input[str]] = None,
                           zone: Optional[pulumi.Input[str]] = None,
                           opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseInstancesResult]
    func GetDatabaseInstances(ctx *Context, args *GetDatabaseInstancesArgs, opts ...InvokeOption) (*GetDatabaseInstancesResult, error)
func GetDatabaseInstancesOutput(ctx *Context, args *GetDatabaseInstancesOutputArgs, opts ...InvokeOption) GetDatabaseInstancesResultOutput

    > Note: This function is named GetDatabaseInstances in the Go SDK.

    public static class GetDatabaseInstances 
{
    public static Task<GetDatabaseInstancesResult> InvokeAsync(GetDatabaseInstancesArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabaseInstancesResult> Invoke(GetDatabaseInstancesInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetDatabaseInstancesResult> getDatabaseInstances(GetDatabaseInstancesArgs args, InvokeOptions options)
public static Output<GetDatabaseInstancesResult> getDatabaseInstances(GetDatabaseInstancesArgs args, InvokeOptions options)

    fn::invoke:
  function: gcp:sql/getDatabaseInstances:getDatabaseInstances
  arguments:
    # arguments dictionary

    The following arguments are supported:

    DatabaseVersion string
    To filter out the Cloud SQL instances which are of the specified database version.
    Project string
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    Region string
    To filter out the Cloud SQL instances which are located in the specified region.
    State string
    To filter out the Cloud SQL instances based on the current serving state of the database instance. Supported values include SQL_INSTANCE_STATE_UNSPECIFIED, RUNNABLE, SUSPENDED, PENDING_DELETE, PENDING_CREATE, MAINTENANCE, FAILED.
    Tier string
    To filter out the Cloud SQL instances based on the tier(or machine type) of the database instances.
    Zone string
    To filter out the Cloud SQL instances which are located in the specified zone. This zone refers to the Compute Engine zone that the instance is currently serving from.
    DatabaseVersion string
    To filter out the Cloud SQL instances which are of the specified database version.
    Project string
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    Region string
    To filter out the Cloud SQL instances which are located in the specified region.
    State string
    To filter out the Cloud SQL instances based on the current serving state of the database instance. Supported values include SQL_INSTANCE_STATE_UNSPECIFIED, RUNNABLE, SUSPENDED, PENDING_DELETE, PENDING_CREATE, MAINTENANCE, FAILED.
    Tier string
    To filter out the Cloud SQL instances based on the tier(or machine type) of the database instances.
    Zone string
    To filter out the Cloud SQL instances which are located in the specified zone. This zone refers to the Compute Engine zone that the instance is currently serving from.
    databaseVersion String
    To filter out the Cloud SQL instances which are of the specified database version.
    project String
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    region String
    To filter out the Cloud SQL instances which are located in the specified region.
    state String
    To filter out the Cloud SQL instances based on the current serving state of the database instance. Supported values include SQL_INSTANCE_STATE_UNSPECIFIED, RUNNABLE, SUSPENDED, PENDING_DELETE, PENDING_CREATE, MAINTENANCE, FAILED.
    tier String
    To filter out the Cloud SQL instances based on the tier(or machine type) of the database instances.
    zone String
    To filter out the Cloud SQL instances which are located in the specified zone. This zone refers to the Compute Engine zone that the instance is currently serving from.
    databaseVersion string
    To filter out the Cloud SQL instances which are of the specified database version.
    project string
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    region string
    To filter out the Cloud SQL instances which are located in the specified region.
    state string
    To filter out the Cloud SQL instances based on the current serving state of the database instance. Supported values include SQL_INSTANCE_STATE_UNSPECIFIED, RUNNABLE, SUSPENDED, PENDING_DELETE, PENDING_CREATE, MAINTENANCE, FAILED.
    tier string
    To filter out the Cloud SQL instances based on the tier(or machine type) of the database instances.
    zone string
    To filter out the Cloud SQL instances which are located in the specified zone. This zone refers to the Compute Engine zone that the instance is currently serving from.
    database_version str
    To filter out the Cloud SQL instances which are of the specified database version.
    project str
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    region str
    To filter out the Cloud SQL instances which are located in the specified region.
    state str
    To filter out the Cloud SQL instances based on the current serving state of the database instance. Supported values include SQL_INSTANCE_STATE_UNSPECIFIED, RUNNABLE, SUSPENDED, PENDING_DELETE, PENDING_CREATE, MAINTENANCE, FAILED.
    tier str
    To filter out the Cloud SQL instances based on the tier(or machine type) of the database instances.
    zone str
    To filter out the Cloud SQL instances which are located in the specified zone. This zone refers to the Compute Engine zone that the instance is currently serving from.
    databaseVersion String
    To filter out the Cloud SQL instances which are of the specified database version.
    project String
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    region String
    To filter out the Cloud SQL instances which are located in the specified region.
    state String
    To filter out the Cloud SQL instances based on the current serving state of the database instance. Supported values include SQL_INSTANCE_STATE_UNSPECIFIED, RUNNABLE, SUSPENDED, PENDING_DELETE, PENDING_CREATE, MAINTENANCE, FAILED.
    tier String
    To filter out the Cloud SQL instances based on the tier(or machine type) of the database instances.
    zone String
    To filter out the Cloud SQL instances which are located in the specified zone. This zone refers to the Compute Engine zone that the instance is currently serving from.

    getDatabaseInstances Result

    The following output properties are available:

    Id string
    The provider-assigned unique ID for this managed resource.
    Instances List<GetDatabaseInstancesInstance>
    DatabaseVersion string
    Project string
    Region string
    State string
    Tier string
    Zone string
    Id string
    The provider-assigned unique ID for this managed resource.
    Instances []GetDatabaseInstancesInstance
    DatabaseVersion string
    Project string
    Region string
    State string
    Tier string
    Zone string
    id String
    The provider-assigned unique ID for this managed resource.
    instances List<GetDatabaseInstancesInstance>
    databaseVersion String
    project String
    region String
    state String
    tier String
    zone String
    id string
    The provider-assigned unique ID for this managed resource.
    instances GetDatabaseInstancesInstance[]
    databaseVersion string
    project string
    region string
    state string
    tier string
    zone string
    id str
    The provider-assigned unique ID for this managed resource.
    instances Sequence[GetDatabaseInstancesInstance]
    database_version str
    project str
    region str
    state str
    tier str
    zone str
    id String
    The provider-assigned unique ID for this managed resource.
    instances List<Property Map>
    databaseVersion String
    project String
    region String
    state String
    tier String
    zone String

    Supporting Types

    GetDatabaseInstancesInstance

    AvailableMaintenanceVersions List<string>
    Available Maintenance versions.
    Clones List<GetDatabaseInstancesInstanceClone>
    Configuration for creating a new instance as a clone of another instance.
    ConnectionName string
    The connection name of the instance to be used in connection strings. For example, when connecting with Cloud SQL Proxy.
    DatabaseVersion string
    To filter out the Cloud SQL instances which are of the specified database version.
    DeletionProtection bool
    DnsName string
    The dns name of the instance.
    EncryptionKeyName string
    FirstIpAddress string
    InstanceType string
    The type of the instance. The valid values are:- 'SQL_INSTANCE_TYPE_UNSPECIFIED', 'CLOUD_SQL_INSTANCE', 'ON_PREMISES_INSTANCE' and 'READ_REPLICA_INSTANCE'.
    IpAddresses List<GetDatabaseInstancesInstanceIpAddress>
    MaintenanceVersion string
    Maintenance version.
    MasterInstanceName string
    The name of the instance that will act as the master in the replication setup. Note, this requires the master to have binary_log_enabled set, as well as existing backups.
    Name string
    PrivateIpAddress string
    Project string
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    PscServiceAttachmentLink string
    The link to service attachment of PSC instance.
    PublicIpAddress string
    Region string
    To filter out the Cloud SQL instances which are located in the specified region.
    ReplicaConfigurations List<GetDatabaseInstancesInstanceReplicaConfiguration>
    The configuration for replication.
    ReplicaNames List<string>
    The replicas of the instance.
    ReplicationClusters List<GetDatabaseInstancesInstanceReplicationCluster>
    A primary instance and disaster recovery replica pair. Applicable to MySQL and PostgreSQL. This field can be set only after both the primary and replica are created.
    RestoreBackupContexts List<GetDatabaseInstancesInstanceRestoreBackupContext>
    RootPassword string
    Initial root password. Required for MS SQL Server.
    SelfLink string
    The URI of the created resource.
    ServerCaCerts List<GetDatabaseInstancesInstanceServerCaCert>
    ServiceAccountEmailAddress string
    The service account email address assigned to the instance.
    Settings List<GetDatabaseInstancesInstanceSetting>
    The settings to use for the database. The configuration is detailed below.
    AvailableMaintenanceVersions []string
    Available Maintenance versions.
    Clones []GetDatabaseInstancesInstanceClone
    Configuration for creating a new instance as a clone of another instance.
    ConnectionName string
    The connection name of the instance to be used in connection strings. For example, when connecting with Cloud SQL Proxy.
    DatabaseVersion string
    To filter out the Cloud SQL instances which are of the specified database version.
    DeletionProtection bool
    DnsName string
    The dns name of the instance.
    EncryptionKeyName string
    FirstIpAddress string
    InstanceType string
    The type of the instance. The valid values are:- 'SQL_INSTANCE_TYPE_UNSPECIFIED', 'CLOUD_SQL_INSTANCE', 'ON_PREMISES_INSTANCE' and 'READ_REPLICA_INSTANCE'.
    IpAddresses []GetDatabaseInstancesInstanceIpAddress
    MaintenanceVersion string
    Maintenance version.
    MasterInstanceName string
    The name of the instance that will act as the master in the replication setup. Note, this requires the master to have binary_log_enabled set, as well as existing backups.
    Name string
    PrivateIpAddress string
    Project string
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    PscServiceAttachmentLink string
    The link to service attachment of PSC instance.
    PublicIpAddress string
    Region string
    To filter out the Cloud SQL instances which are located in the specified region.
    ReplicaConfigurations []GetDatabaseInstancesInstanceReplicaConfiguration
    The configuration for replication.
    ReplicaNames []string
    The replicas of the instance.
    ReplicationClusters []GetDatabaseInstancesInstanceReplicationCluster
    A primary instance and disaster recovery replica pair. Applicable to MySQL and PostgreSQL. This field can be set only after both the primary and replica are created.
    RestoreBackupContexts []GetDatabaseInstancesInstanceRestoreBackupContext
    RootPassword string
    Initial root password. Required for MS SQL Server.
    SelfLink string
    The URI of the created resource.
    ServerCaCerts []GetDatabaseInstancesInstanceServerCaCert
    ServiceAccountEmailAddress string
    The service account email address assigned to the instance.
    Settings []GetDatabaseInstancesInstanceSetting
    The settings to use for the database. The configuration is detailed below.
    availableMaintenanceVersions List<String>
    Available Maintenance versions.
    clones List<GetDatabaseInstancesInstanceClone>
    Configuration for creating a new instance as a clone of another instance.
    connectionName String
    The connection name of the instance to be used in connection strings. For example, when connecting with Cloud SQL Proxy.
    databaseVersion String
    To filter out the Cloud SQL instances which are of the specified database version.
    deletionProtection Boolean
    dnsName String
    The dns name of the instance.
    encryptionKeyName String
    firstIpAddress String
    instanceType String
    The type of the instance. The valid values are:- 'SQL_INSTANCE_TYPE_UNSPECIFIED', 'CLOUD_SQL_INSTANCE', 'ON_PREMISES_INSTANCE' and 'READ_REPLICA_INSTANCE'.
    ipAddresses List<GetDatabaseInstancesInstanceIpAddress>
    maintenanceVersion String
    Maintenance version.
    masterInstanceName String
    The name of the instance that will act as the master in the replication setup. Note, this requires the master to have binary_log_enabled set, as well as existing backups.
    name String
    privateIpAddress String
    project String
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    pscServiceAttachmentLink String
    The link to service attachment of PSC instance.
    publicIpAddress String
    region String
    To filter out the Cloud SQL instances which are located in the specified region.
    replicaConfigurations List<GetDatabaseInstancesInstanceReplicaConfiguration>
    The configuration for replication.
    replicaNames List<String>
    The replicas of the instance.
    replicationClusters List<GetDatabaseInstancesInstanceReplicationCluster>
    A primary instance and disaster recovery replica pair. Applicable to MySQL and PostgreSQL. This field can be set only after both the primary and replica are created.
    restoreBackupContexts List<GetDatabaseInstancesInstanceRestoreBackupContext>
    rootPassword String
    Initial root password. Required for MS SQL Server.
    selfLink String
    The URI of the created resource.
    serverCaCerts List<GetDatabaseInstancesInstanceServerCaCert>
    serviceAccountEmailAddress String
    The service account email address assigned to the instance.
    settings List<GetDatabaseInstancesInstanceSetting>
    The settings to use for the database. The configuration is detailed below.
    availableMaintenanceVersions string[]
    Available Maintenance versions.
    clones GetDatabaseInstancesInstanceClone[]
    Configuration for creating a new instance as a clone of another instance.
    connectionName string
    The connection name of the instance to be used in connection strings. For example, when connecting with Cloud SQL Proxy.
    databaseVersion string
    To filter out the Cloud SQL instances which are of the specified database version.
    deletionProtection boolean
    dnsName string
    The dns name of the instance.
    encryptionKeyName string
    firstIpAddress string
    instanceType string
    The type of the instance. The valid values are:- 'SQL_INSTANCE_TYPE_UNSPECIFIED', 'CLOUD_SQL_INSTANCE', 'ON_PREMISES_INSTANCE' and 'READ_REPLICA_INSTANCE'.
    ipAddresses GetDatabaseInstancesInstanceIpAddress[]
    maintenanceVersion string
    Maintenance version.
    masterInstanceName string
    The name of the instance that will act as the master in the replication setup. Note, this requires the master to have binary_log_enabled set, as well as existing backups.
    name string
    privateIpAddress string
    project string
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    pscServiceAttachmentLink string
    The link to service attachment of PSC instance.
    publicIpAddress string
    region string
    To filter out the Cloud SQL instances which are located in the specified region.
    replicaConfigurations GetDatabaseInstancesInstanceReplicaConfiguration[]
    The configuration for replication.
    replicaNames string[]
    The replicas of the instance.
    replicationClusters GetDatabaseInstancesInstanceReplicationCluster[]
    A primary instance and disaster recovery replica pair. Applicable to MySQL and PostgreSQL. This field can be set only after both the primary and replica are created.
    restoreBackupContexts GetDatabaseInstancesInstanceRestoreBackupContext[]
    rootPassword string
    Initial root password. Required for MS SQL Server.
    selfLink string
    The URI of the created resource.
    serverCaCerts GetDatabaseInstancesInstanceServerCaCert[]
    serviceAccountEmailAddress string
    The service account email address assigned to the instance.
    settings GetDatabaseInstancesInstanceSetting[]
    The settings to use for the database. The configuration is detailed below.
    available_maintenance_versions Sequence[str]
    Available Maintenance versions.
    clones Sequence[GetDatabaseInstancesInstanceClone]
    Configuration for creating a new instance as a clone of another instance.
    connection_name str
    The connection name of the instance to be used in connection strings. For example, when connecting with Cloud SQL Proxy.
    database_version str
    To filter out the Cloud SQL instances which are of the specified database version.
    deletion_protection bool
    dns_name str
    The dns name of the instance.
    encryption_key_name str
    first_ip_address str
    instance_type str
    The type of the instance. The valid values are:- 'SQL_INSTANCE_TYPE_UNSPECIFIED', 'CLOUD_SQL_INSTANCE', 'ON_PREMISES_INSTANCE' and 'READ_REPLICA_INSTANCE'.
    ip_addresses Sequence[GetDatabaseInstancesInstanceIpAddress]
    maintenance_version str
    Maintenance version.
    master_instance_name str
    The name of the instance that will act as the master in the replication setup. Note, this requires the master to have binary_log_enabled set, as well as existing backups.
    name str
    private_ip_address str
    project str
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    psc_service_attachment_link str
    The link to service attachment of PSC instance.
    public_ip_address str
    region str
    To filter out the Cloud SQL instances which are located in the specified region.
    replica_configurations Sequence[GetDatabaseInstancesInstanceReplicaConfiguration]
    The configuration for replication.
    replica_names Sequence[str]
    The replicas of the instance.
    replication_clusters Sequence[GetDatabaseInstancesInstanceReplicationCluster]
    A primary instance and disaster recovery replica pair. Applicable to MySQL and PostgreSQL. This field can be set only after both the primary and replica are created.
    restore_backup_contexts Sequence[GetDatabaseInstancesInstanceRestoreBackupContext]
    root_password str
    Initial root password. Required for MS SQL Server.
    self_link str
    The URI of the created resource.
    server_ca_certs Sequence[GetDatabaseInstancesInstanceServerCaCert]
    service_account_email_address str
    The service account email address assigned to the instance.
    settings Sequence[GetDatabaseInstancesInstanceSetting]
    The settings to use for the database. The configuration is detailed below.
    availableMaintenanceVersions List<String>
    Available Maintenance versions.
    clones List<Property Map>
    Configuration for creating a new instance as a clone of another instance.
    connectionName String
    The connection name of the instance to be used in connection strings. For example, when connecting with Cloud SQL Proxy.
    databaseVersion String
    To filter out the Cloud SQL instances which are of the specified database version.
    deletionProtection Boolean
    dnsName String
    The dns name of the instance.
    encryptionKeyName String
    firstIpAddress String
    instanceType String
    The type of the instance. The valid values are:- 'SQL_INSTANCE_TYPE_UNSPECIFIED', 'CLOUD_SQL_INSTANCE', 'ON_PREMISES_INSTANCE' and 'READ_REPLICA_INSTANCE'.
    ipAddresses List<Property Map>
    maintenanceVersion String
    Maintenance version.
    masterInstanceName String
    The name of the instance that will act as the master in the replication setup. Note, this requires the master to have binary_log_enabled set, as well as existing backups.
    name String
    privateIpAddress String
    project String
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    pscServiceAttachmentLink String
    The link to service attachment of PSC instance.
    publicIpAddress String
    region String
    To filter out the Cloud SQL instances which are located in the specified region.
    replicaConfigurations List<Property Map>
    The configuration for replication.
    replicaNames List<String>
    The replicas of the instance.
    replicationClusters List<Property Map>
    A primary instance and disaster recovery replica pair. Applicable to MySQL and PostgreSQL. This field can be set only after both the primary and replica are created.
    restoreBackupContexts List<Property Map>
    rootPassword String
    Initial root password. Required for MS SQL Server.
    selfLink String
    The URI of the created resource.
    serverCaCerts List<Property Map>
    serviceAccountEmailAddress String
    The service account email address assigned to the instance.
    settings List<Property Map>
    The settings to use for the database. The configuration is detailed below.

    GetDatabaseInstancesInstanceClone

    AllocatedIpRange string
    The name of the allocated ip range for the private ip CloudSQL instance. For example: "google-managed-services-default". If set, the cloned instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression a-z?.
    DatabaseNames List<string>
    (SQL Server only, use with point_in_time) clone only the specified databases from the source instance. Clone all databases if empty.
    PointInTime string
    The timestamp of the point in time that should be restored.
    PreferredZone string
    (Point-in-time recovery for PostgreSQL only) Clone to an instance in the specified zone. If no zone is specified, clone to the same zone as the source instance.
    SourceInstanceName string
    The name of the instance from which the point in time should be restored.
    AllocatedIpRange string
    The name of the allocated ip range for the private ip CloudSQL instance. For example: "google-managed-services-default". If set, the cloned instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression a-z?.
    DatabaseNames []string
    (SQL Server only, use with point_in_time) clone only the specified databases from the source instance. Clone all databases if empty.
    PointInTime string
    The timestamp of the point in time that should be restored.
    PreferredZone string
    (Point-in-time recovery for PostgreSQL only) Clone to an instance in the specified zone. If no zone is specified, clone to the same zone as the source instance.
    SourceInstanceName string
    The name of the instance from which the point in time should be restored.
    allocatedIpRange String
    The name of the allocated ip range for the private ip CloudSQL instance. For example: "google-managed-services-default". If set, the cloned instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression a-z?.
    databaseNames List<String>
    (SQL Server only, use with point_in_time) clone only the specified databases from the source instance. Clone all databases if empty.
    pointInTime String
    The timestamp of the point in time that should be restored.
    preferredZone String
    (Point-in-time recovery for PostgreSQL only) Clone to an instance in the specified zone. If no zone is specified, clone to the same zone as the source instance.
    sourceInstanceName String
    The name of the instance from which the point in time should be restored.
    allocatedIpRange string
    The name of the allocated ip range for the private ip CloudSQL instance. For example: "google-managed-services-default". If set, the cloned instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression a-z?.
    databaseNames string[]
    (SQL Server only, use with point_in_time) clone only the specified databases from the source instance. Clone all databases if empty.
    pointInTime string
    The timestamp of the point in time that should be restored.
    preferredZone string
    (Point-in-time recovery for PostgreSQL only) Clone to an instance in the specified zone. If no zone is specified, clone to the same zone as the source instance.
    sourceInstanceName string
    The name of the instance from which the point in time should be restored.
    allocated_ip_range str
    The name of the allocated ip range for the private ip CloudSQL instance. For example: "google-managed-services-default". If set, the cloned instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression a-z?.
    database_names Sequence[str]
    (SQL Server only, use with point_in_time) clone only the specified databases from the source instance. Clone all databases if empty.
    point_in_time str
    The timestamp of the point in time that should be restored.
    preferred_zone str
    (Point-in-time recovery for PostgreSQL only) Clone to an instance in the specified zone. If no zone is specified, clone to the same zone as the source instance.
    source_instance_name str
    The name of the instance from which the point in time should be restored.
    allocatedIpRange String
    The name of the allocated ip range for the private ip CloudSQL instance. For example: "google-managed-services-default". If set, the cloned instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression a-z?.
    databaseNames List<String>
    (SQL Server only, use with point_in_time) clone only the specified databases from the source instance. Clone all databases if empty.
    pointInTime String
    The timestamp of the point in time that should be restored.
    preferredZone String
    (Point-in-time recovery for PostgreSQL only) Clone to an instance in the specified zone. If no zone is specified, clone to the same zone as the source instance.
    sourceInstanceName String
    The name of the instance from which the point in time should be restored.

    GetDatabaseInstancesInstanceIpAddress

    IpAddress string
    TimeToRetire string
    Type string
    IpAddress string
    TimeToRetire string
    Type string
    ipAddress String
    timeToRetire String
    type String
    ipAddress string
    timeToRetire string
    type string
    ipAddress String
    timeToRetire String
    type String

    GetDatabaseInstancesInstanceReplicaConfiguration

    CaCertificate string
    PEM representation of the trusted CA's x509 certificate.
    CascadableReplica bool
    Specifies if a SQL Server replica is a cascadable replica. A cascadable replica is a SQL Server cross region replica that supports replica(s) under it.
    ClientCertificate string
    PEM representation of the replica's x509 certificate.
    ClientKey string
    PEM representation of the replica's private key. The corresponding public key in encoded in the client_certificate.
    ConnectRetryInterval int
    The number of seconds between connect retries. MySQL's default is 60 seconds.
    DumpFilePath string
    Path to a SQL file in Google Cloud Storage from which replica instances are created. Format is gs://bucket/filename.
    FailoverTarget bool
    Specifies if the replica is the failover target. If the field is set to true the replica will be designated as a failover replica. If the master instance fails, the replica instance will be promoted as the new master instance. Not supported for Postgres
    MasterHeartbeatPeriod int
    Time in ms between replication heartbeats.
    Password string
    Password for the replication connection.
    SslCipher string
    Permissible ciphers for use in SSL encryption.
    Username string
    Username for replication connection.
    VerifyServerCertificate bool
    True if the master's common name value is checked during the SSL handshake.
    CaCertificate string
    PEM representation of the trusted CA's x509 certificate.
    CascadableReplica bool
    Specifies if a SQL Server replica is a cascadable replica. A cascadable replica is a SQL Server cross region replica that supports replica(s) under it.
    ClientCertificate string
    PEM representation of the replica's x509 certificate.
    ClientKey string
    PEM representation of the replica's private key. The corresponding public key in encoded in the client_certificate.
    ConnectRetryInterval int
    The number of seconds between connect retries. MySQL's default is 60 seconds.
    DumpFilePath string
    Path to a SQL file in Google Cloud Storage from which replica instances are created. Format is gs://bucket/filename.
    FailoverTarget bool
    Specifies if the replica is the failover target. If the field is set to true the replica will be designated as a failover replica. If the master instance fails, the replica instance will be promoted as the new master instance. Not supported for Postgres
    MasterHeartbeatPeriod int
    Time in ms between replication heartbeats.
    Password string
    Password for the replication connection.
    SslCipher string
    Permissible ciphers for use in SSL encryption.
    Username string
    Username for replication connection.
    VerifyServerCertificate bool
    True if the master's common name value is checked during the SSL handshake.
    caCertificate String
    PEM representation of the trusted CA's x509 certificate.
    cascadableReplica Boolean
    Specifies if a SQL Server replica is a cascadable replica. A cascadable replica is a SQL Server cross region replica that supports replica(s) under it.
    clientCertificate String
    PEM representation of the replica's x509 certificate.
    clientKey String
    PEM representation of the replica's private key. The corresponding public key in encoded in the client_certificate.
    connectRetryInterval Integer
    The number of seconds between connect retries. MySQL's default is 60 seconds.
    dumpFilePath String
    Path to a SQL file in Google Cloud Storage from which replica instances are created. Format is gs://bucket/filename.
    failoverTarget Boolean
    Specifies if the replica is the failover target. If the field is set to true the replica will be designated as a failover replica. If the master instance fails, the replica instance will be promoted as the new master instance. Not supported for Postgres
    masterHeartbeatPeriod Integer
    Time in ms between replication heartbeats.
    password String
    Password for the replication connection.
    sslCipher String
    Permissible ciphers for use in SSL encryption.
    username String
    Username for replication connection.
    verifyServerCertificate Boolean
    True if the master's common name value is checked during the SSL handshake.
    caCertificate string
    PEM representation of the trusted CA's x509 certificate.
    cascadableReplica boolean
    Specifies if a SQL Server replica is a cascadable replica. A cascadable replica is a SQL Server cross region replica that supports replica(s) under it.
    clientCertificate string
    PEM representation of the replica's x509 certificate.
    clientKey string
    PEM representation of the replica's private key. The corresponding public key in encoded in the client_certificate.
    connectRetryInterval number
    The number of seconds between connect retries. MySQL's default is 60 seconds.
    dumpFilePath string
    Path to a SQL file in Google Cloud Storage from which replica instances are created. Format is gs://bucket/filename.
    failoverTarget boolean
    Specifies if the replica is the failover target. If the field is set to true the replica will be designated as a failover replica. If the master instance fails, the replica instance will be promoted as the new master instance. Not supported for Postgres
    masterHeartbeatPeriod number
    Time in ms between replication heartbeats.
    password string
    Password for the replication connection.
    sslCipher string
    Permissible ciphers for use in SSL encryption.
    username string
    Username for replication connection.
    verifyServerCertificate boolean
    True if the master's common name value is checked during the SSL handshake.
    ca_certificate str
    PEM representation of the trusted CA's x509 certificate.
    cascadable_replica bool
    Specifies if a SQL Server replica is a cascadable replica. A cascadable replica is a SQL Server cross region replica that supports replica(s) under it.
    client_certificate str
    PEM representation of the replica's x509 certificate.
    client_key str
    PEM representation of the replica's private key. The corresponding public key in encoded in the client_certificate.
    connect_retry_interval int
    The number of seconds between connect retries. MySQL's default is 60 seconds.
    dump_file_path str
    Path to a SQL file in Google Cloud Storage from which replica instances are created. Format is gs://bucket/filename.
    failover_target bool
    Specifies if the replica is the failover target. If the field is set to true the replica will be designated as a failover replica. If the master instance fails, the replica instance will be promoted as the new master instance. Not supported for Postgres
    master_heartbeat_period int
    Time in ms between replication heartbeats.
    password str
    Password for the replication connection.
    ssl_cipher str
    Permissible ciphers for use in SSL encryption.
    username str
    Username for replication connection.
    verify_server_certificate bool
    True if the master's common name value is checked during the SSL handshake.
    caCertificate String
    PEM representation of the trusted CA's x509 certificate.
    cascadableReplica Boolean
    Specifies if a SQL Server replica is a cascadable replica. A cascadable replica is a SQL Server cross region replica that supports replica(s) under it.
    clientCertificate String
    PEM representation of the replica's x509 certificate.
    clientKey String
    PEM representation of the replica's private key. The corresponding public key in encoded in the client_certificate.
    connectRetryInterval Number
    The number of seconds between connect retries. MySQL's default is 60 seconds.
    dumpFilePath String
    Path to a SQL file in Google Cloud Storage from which replica instances are created. Format is gs://bucket/filename.
    failoverTarget Boolean
    Specifies if the replica is the failover target. If the field is set to true the replica will be designated as a failover replica. If the master instance fails, the replica instance will be promoted as the new master instance. Not supported for Postgres
    masterHeartbeatPeriod Number
    Time in ms between replication heartbeats.
    password String
    Password for the replication connection.
    sslCipher String
    Permissible ciphers for use in SSL encryption.
    username String
    Username for replication connection.
    verifyServerCertificate Boolean
    True if the master's common name value is checked during the SSL handshake.

    GetDatabaseInstancesInstanceReplicationCluster

    DrReplica bool
    Read-only field that indicates whether the replica is a DR replica.
    FailoverDrReplicaName string
    If the instance is a primary instance, then this field identifies the disaster recovery (DR) replica. The standard format of this field is "your-project:your-instance". You can also set this field to "your-instance", but cloud SQL backend will convert it to the aforementioned standard format.
    DrReplica bool
    Read-only field that indicates whether the replica is a DR replica.
    FailoverDrReplicaName string
    If the instance is a primary instance, then this field identifies the disaster recovery (DR) replica. The standard format of this field is "your-project:your-instance". You can also set this field to "your-instance", but cloud SQL backend will convert it to the aforementioned standard format.
    drReplica Boolean
    Read-only field that indicates whether the replica is a DR replica.
    failoverDrReplicaName String
    If the instance is a primary instance, then this field identifies the disaster recovery (DR) replica. The standard format of this field is "your-project:your-instance". You can also set this field to "your-instance", but cloud SQL backend will convert it to the aforementioned standard format.
    drReplica boolean
    Read-only field that indicates whether the replica is a DR replica.
    failoverDrReplicaName string
    If the instance is a primary instance, then this field identifies the disaster recovery (DR) replica. The standard format of this field is "your-project:your-instance". You can also set this field to "your-instance", but cloud SQL backend will convert it to the aforementioned standard format.
    dr_replica bool
    Read-only field that indicates whether the replica is a DR replica.
    failover_dr_replica_name str
    If the instance is a primary instance, then this field identifies the disaster recovery (DR) replica. The standard format of this field is "your-project:your-instance". You can also set this field to "your-instance", but cloud SQL backend will convert it to the aforementioned standard format.
    drReplica Boolean
    Read-only field that indicates whether the replica is a DR replica.
    failoverDrReplicaName String
    If the instance is a primary instance, then this field identifies the disaster recovery (DR) replica. The standard format of this field is "your-project:your-instance". You can also set this field to "your-instance", but cloud SQL backend will convert it to the aforementioned standard format.

    GetDatabaseInstancesInstanceRestoreBackupContext

    BackupRunId int
    The ID of the backup run to restore from.
    InstanceId string
    The ID of the instance that the backup was taken from.
    Project string
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    BackupRunId int
    The ID of the backup run to restore from.
    InstanceId string
    The ID of the instance that the backup was taken from.
    Project string
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    backupRunId Integer
    The ID of the backup run to restore from.
    instanceId String
    The ID of the instance that the backup was taken from.
    project String
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    backupRunId number
    The ID of the backup run to restore from.
    instanceId string
    The ID of the instance that the backup was taken from.
    project string
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    backup_run_id int
    The ID of the backup run to restore from.
    instance_id str
    The ID of the instance that the backup was taken from.
    project str
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.
    backupRunId Number
    The ID of the backup run to restore from.
    instanceId String
    The ID of the instance that the backup was taken from.
    project String
    The ID of the project in which the resources belong. If it is not provided, the provider project is used.

    GetDatabaseInstancesInstanceServerCaCert

    Cert string
    The CA Certificate used to connect to the SQL Instance via SSL.
    CommonName string
    The CN valid for the CA Cert.
    CreateTime string
    Creation time of the CA Cert.
    ExpirationTime string
    Expiration time of the CA Cert.
    Sha1Fingerprint string
    SHA Fingerprint of the CA Cert.
    Cert string
    The CA Certificate used to connect to the SQL Instance via SSL.
    CommonName string
    The CN valid for the CA Cert.
    CreateTime string
    Creation time of the CA Cert.
    ExpirationTime string
    Expiration time of the CA Cert.
    Sha1Fingerprint string
    SHA Fingerprint of the CA Cert.
    cert String
    The CA Certificate used to connect to the SQL Instance via SSL.
    commonName String
    The CN valid for the CA Cert.
    createTime String
    Creation time of the CA Cert.
    expirationTime String
    Expiration time of the CA Cert.
    sha1Fingerprint String
    SHA Fingerprint of the CA Cert.
    cert string
    The CA Certificate used to connect to the SQL Instance via SSL.
    commonName string
    The CN valid for the CA Cert.
    createTime string
    Creation time of the CA Cert.
    expirationTime string
    Expiration time of the CA Cert.
    sha1Fingerprint string
    SHA Fingerprint of the CA Cert.
    cert str
    The CA Certificate used to connect to the SQL Instance via SSL.
    common_name str
    The CN valid for the CA Cert.
    create_time str
    Creation time of the CA Cert.
    expiration_time str
    Expiration time of the CA Cert.
    sha1_fingerprint str
    SHA Fingerprint of the CA Cert.
    cert String
    The CA Certificate used to connect to the SQL Instance via SSL.
    commonName String
    The CN valid for the CA Cert.
    createTime String
    Creation time of the CA Cert.
    expirationTime String
    Expiration time of the CA Cert.
    sha1Fingerprint String
    SHA Fingerprint of the CA Cert.

    GetDatabaseInstancesInstanceSetting

    ActivationPolicy string
    This specifies when the instance should be active. Can be either ALWAYS, NEVER or ON_DEMAND.
    ActiveDirectoryConfigs List<GetDatabaseInstancesInstanceSettingActiveDirectoryConfig>
    AdvancedMachineFeatures List<GetDatabaseInstancesInstanceSettingAdvancedMachineFeature>
    AvailabilityType string
    The availability type of the Cloud SQL instance, high availability (REGIONAL) or single zone (ZONAL). For all instances, ensure that settings.backup_configuration.enabled is set to true. For MySQL instances, ensure that settings.backup_configuration.binary_log_enabled is set to true. For Postgres instances, ensure that settings.backup_configuration.point_in_time_recovery_enabled is set to true. Defaults to ZONAL.
    BackupConfigurations List<GetDatabaseInstancesInstanceSettingBackupConfiguration>
    Collation string
    The name of server instance collation.
    ConnectorEnforcement string
    Enables the enforcement of Cloud SQL Auth Proxy or Cloud SQL connectors for all the connections. If enabled, all the direct connections are rejected.
    DataCacheConfigs List<GetDatabaseInstancesInstanceSettingDataCacheConfig>
    Data cache configurations.
    DatabaseFlags List<GetDatabaseInstancesInstanceSettingDatabaseFlag>
    DeletionProtectionEnabled bool
    Configuration to protect against accidental instance deletion.
    DenyMaintenancePeriods List<GetDatabaseInstancesInstanceSettingDenyMaintenancePeriod>
    DiskAutoresize bool
    Enables auto-resizing of the storage size. Defaults to true.
    DiskAutoresizeLimit int
    The maximum size, in GB, to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.
    DiskSize int
    The size of data disk, in GB. Size of a running instance cannot be reduced but can be increased. The minimum value is 10GB.
    DiskType string
    The type of data disk: PD_SSD or PD_HDD. Defaults to PD_SSD.
    Edition string
    The edition of the instance, can be ENTERPRISE or ENTERPRISE_PLUS.
    EnableDataplexIntegration bool
    Enables Dataplex Integration.
    EnableGoogleMlIntegration bool
    Enables Vertex AI Integration.
    InsightsConfigs List<GetDatabaseInstancesInstanceSettingInsightsConfig>
    Configuration of Query Insights.
    IpConfigurations List<GetDatabaseInstancesInstanceSettingIpConfiguration>
    LocationPreferences List<GetDatabaseInstancesInstanceSettingLocationPreference>
    MaintenanceWindows List<GetDatabaseInstancesInstanceSettingMaintenanceWindow>
    Declares a one-hour maintenance window when an Instance can automatically restart to apply updates. The maintenance window is specified in UTC time.
    PasswordValidationPolicies List<GetDatabaseInstancesInstanceSettingPasswordValidationPolicy>
    PricingPlan string
    Pricing plan for this instance, can only be PER_USE.
    SqlServerAuditConfigs List<GetDatabaseInstancesInstanceSettingSqlServerAuditConfig>
    Tier string
    To filter out the Cloud SQL instances based on the tier(or machine type) of the database instances.
    TimeZone string
    The time_zone to be used by the database engine (supported only for SQL Server), in SQL Server timezone format.
    UserLabels Dictionary<string, string>
    A set of key/value user label pairs to assign to the instance.
    Version int
    Used to make sure changes to the settings block are atomic.
    ActivationPolicy string
    This specifies when the instance should be active. Can be either ALWAYS, NEVER or ON_DEMAND.
    ActiveDirectoryConfigs []GetDatabaseInstancesInstanceSettingActiveDirectoryConfig
    AdvancedMachineFeatures []GetDatabaseInstancesInstanceSettingAdvancedMachineFeature
    AvailabilityType string
    The availability type of the Cloud SQL instance, high availability (REGIONAL) or single zone (ZONAL). For all instances, ensure that settings.backup_configuration.enabled is set to true. For MySQL instances, ensure that settings.backup_configuration.binary_log_enabled is set to true. For Postgres instances, ensure that settings.backup_configuration.point_in_time_recovery_enabled is set to true. Defaults to ZONAL.
    BackupConfigurations []GetDatabaseInstancesInstanceSettingBackupConfiguration
    Collation string
    The name of server instance collation.
    ConnectorEnforcement string
    Enables the enforcement of Cloud SQL Auth Proxy or Cloud SQL connectors for all the connections. If enabled, all the direct connections are rejected.
    DataCacheConfigs []GetDatabaseInstancesInstanceSettingDataCacheConfig
    Data cache configurations.
    DatabaseFlags []GetDatabaseInstancesInstanceSettingDatabaseFlag
    DeletionProtectionEnabled bool
    Configuration to protect against accidental instance deletion.
    DenyMaintenancePeriods []GetDatabaseInstancesInstanceSettingDenyMaintenancePeriod
    DiskAutoresize bool
    Enables auto-resizing of the storage size. Defaults to true.
    DiskAutoresizeLimit int
    The maximum size, in GB, to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.
    DiskSize int
    The size of data disk, in GB. Size of a running instance cannot be reduced but can be increased. The minimum value is 10GB.
    DiskType string
    The type of data disk: PD_SSD or PD_HDD. Defaults to PD_SSD.
    Edition string
    The edition of the instance, can be ENTERPRISE or ENTERPRISE_PLUS.
    EnableDataplexIntegration bool
    Enables Dataplex Integration.
    EnableGoogleMlIntegration bool
    Enables Vertex AI Integration.
    InsightsConfigs []GetDatabaseInstancesInstanceSettingInsightsConfig
    Configuration of Query Insights.
    IpConfigurations []GetDatabaseInstancesInstanceSettingIpConfiguration
    LocationPreferences []GetDatabaseInstancesInstanceSettingLocationPreference
    MaintenanceWindows []GetDatabaseInstancesInstanceSettingMaintenanceWindow
    Declares a one-hour maintenance window when an Instance can automatically restart to apply updates. The maintenance window is specified in UTC time.
    PasswordValidationPolicies []GetDatabaseInstancesInstanceSettingPasswordValidationPolicy
    PricingPlan string
    Pricing plan for this instance, can only be PER_USE.
    SqlServerAuditConfigs []GetDatabaseInstancesInstanceSettingSqlServerAuditConfig
    Tier string
    To filter out the Cloud SQL instances based on the tier(or machine type) of the database instances.
    TimeZone string
    The time_zone to be used by the database engine (supported only for SQL Server), in SQL Server timezone format.
    UserLabels map[string]string
    A set of key/value user label pairs to assign to the instance.
    Version int
    Used to make sure changes to the settings block are atomic.
    activationPolicy String
    This specifies when the instance should be active. Can be either ALWAYS, NEVER or ON_DEMAND.
    activeDirectoryConfigs List<GetDatabaseInstancesInstanceSettingActiveDirectoryConfig>
    advancedMachineFeatures List<GetDatabaseInstancesInstanceSettingAdvancedMachineFeature>
    availabilityType String
    The availability type of the Cloud SQL instance, high availability (REGIONAL) or single zone (ZONAL). For all instances, ensure that settings.backup_configuration.enabled is set to true. For MySQL instances, ensure that settings.backup_configuration.binary_log_enabled is set to true. For Postgres instances, ensure that settings.backup_configuration.point_in_time_recovery_enabled is set to true. Defaults to ZONAL.
    backupConfigurations List<GetDatabaseInstancesInstanceSettingBackupConfiguration>
    collation String
    The name of server instance collation.
    connectorEnforcement String
    Enables the enforcement of Cloud SQL Auth Proxy or Cloud SQL connectors for all the connections. If enabled, all the direct connections are rejected.
    dataCacheConfigs List<GetDatabaseInstancesInstanceSettingDataCacheConfig>
    Data cache configurations.
    databaseFlags List<GetDatabaseInstancesInstanceSettingDatabaseFlag>
    deletionProtectionEnabled Boolean
    Configuration to protect against accidental instance deletion.
    denyMaintenancePeriods List<GetDatabaseInstancesInstanceSettingDenyMaintenancePeriod>
    diskAutoresize Boolean
    Enables auto-resizing of the storage size. Defaults to true.
    diskAutoresizeLimit Integer
    The maximum size, in GB, to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.
    diskSize Integer
    The size of data disk, in GB. Size of a running instance cannot be reduced but can be increased. The minimum value is 10GB.
    diskType String
    The type of data disk: PD_SSD or PD_HDD. Defaults to PD_SSD.
    edition String
    The edition of the instance, can be ENTERPRISE or ENTERPRISE_PLUS.
    enableDataplexIntegration Boolean
    Enables Dataplex Integration.
    enableGoogleMlIntegration Boolean
    Enables Vertex AI Integration.
    insightsConfigs List<GetDatabaseInstancesInstanceSettingInsightsConfig>
    Configuration of Query Insights.
    ipConfigurations List<GetDatabaseInstancesInstanceSettingIpConfiguration>
    locationPreferences List<GetDatabaseInstancesInstanceSettingLocationPreference>
    maintenanceWindows List<GetDatabaseInstancesInstanceSettingMaintenanceWindow>
    Declares a one-hour maintenance window when an Instance can automatically restart to apply updates. The maintenance window is specified in UTC time.
    passwordValidationPolicies List<GetDatabaseInstancesInstanceSettingPasswordValidationPolicy>
    pricingPlan String
    Pricing plan for this instance, can only be PER_USE.
    sqlServerAuditConfigs List<GetDatabaseInstancesInstanceSettingSqlServerAuditConfig>
    tier String
    To filter out the Cloud SQL instances based on the tier(or machine type) of the database instances.
    timeZone String
    The time_zone to be used by the database engine (supported only for SQL Server), in SQL Server timezone format.
    userLabels Map<String,String>
    A set of key/value user label pairs to assign to the instance.
    version Integer
    Used to make sure changes to the settings block are atomic.
    activationPolicy string
    This specifies when the instance should be active. Can be either ALWAYS, NEVER or ON_DEMAND.
    activeDirectoryConfigs GetDatabaseInstancesInstanceSettingActiveDirectoryConfig[]
    advancedMachineFeatures GetDatabaseInstancesInstanceSettingAdvancedMachineFeature[]
    availabilityType string
    The availability type of the Cloud SQL instance, high availability (REGIONAL) or single zone (ZONAL). For all instances, ensure that settings.backup_configuration.enabled is set to true. For MySQL instances, ensure that settings.backup_configuration.binary_log_enabled is set to true. For Postgres instances, ensure that settings.backup_configuration.point_in_time_recovery_enabled is set to true. Defaults to ZONAL.
    backupConfigurations GetDatabaseInstancesInstanceSettingBackupConfiguration[]
    collation string
    The name of server instance collation.
    connectorEnforcement string
    Enables the enforcement of Cloud SQL Auth Proxy or Cloud SQL connectors for all the connections. If enabled, all the direct connections are rejected.
    dataCacheConfigs GetDatabaseInstancesInstanceSettingDataCacheConfig[]
    Data cache configurations.
    databaseFlags GetDatabaseInstancesInstanceSettingDatabaseFlag[]
    deletionProtectionEnabled boolean
    Configuration to protect against accidental instance deletion.
    denyMaintenancePeriods GetDatabaseInstancesInstanceSettingDenyMaintenancePeriod[]
    diskAutoresize boolean
    Enables auto-resizing of the storage size. Defaults to true.
    diskAutoresizeLimit number
    The maximum size, in GB, to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.
    diskSize number
    The size of data disk, in GB. Size of a running instance cannot be reduced but can be increased. The minimum value is 10GB.
    diskType string
    The type of data disk: PD_SSD or PD_HDD. Defaults to PD_SSD.
    edition string
    The edition of the instance, can be ENTERPRISE or ENTERPRISE_PLUS.
    enableDataplexIntegration boolean
    Enables Dataplex Integration.
    enableGoogleMlIntegration boolean
    Enables Vertex AI Integration.
    insightsConfigs GetDatabaseInstancesInstanceSettingInsightsConfig[]
    Configuration of Query Insights.
    ipConfigurations GetDatabaseInstancesInstanceSettingIpConfiguration[]
    locationPreferences GetDatabaseInstancesInstanceSettingLocationPreference[]
    maintenanceWindows GetDatabaseInstancesInstanceSettingMaintenanceWindow[]
    Declares a one-hour maintenance window when an Instance can automatically restart to apply updates. The maintenance window is specified in UTC time.
    passwordValidationPolicies GetDatabaseInstancesInstanceSettingPasswordValidationPolicy[]
    pricingPlan string
    Pricing plan for this instance, can only be PER_USE.
    sqlServerAuditConfigs GetDatabaseInstancesInstanceSettingSqlServerAuditConfig[]
    tier string
    To filter out the Cloud SQL instances based on the tier(or machine type) of the database instances.
    timeZone string
    The time_zone to be used by the database engine (supported only for SQL Server), in SQL Server timezone format.
    userLabels {[key: string]: string}
    A set of key/value user label pairs to assign to the instance.
    version number
    Used to make sure changes to the settings block are atomic.
    activation_policy str
    This specifies when the instance should be active. Can be either ALWAYS, NEVER or ON_DEMAND.
    active_directory_configs Sequence[GetDatabaseInstancesInstanceSettingActiveDirectoryConfig]
    advanced_machine_features Sequence[GetDatabaseInstancesInstanceSettingAdvancedMachineFeature]
    availability_type str
    The availability type of the Cloud SQL instance, high availability (REGIONAL) or single zone (ZONAL). For all instances, ensure that settings.backup_configuration.enabled is set to true. For MySQL instances, ensure that settings.backup_configuration.binary_log_enabled is set to true. For Postgres instances, ensure that settings.backup_configuration.point_in_time_recovery_enabled is set to true. Defaults to ZONAL.
    backup_configurations Sequence[GetDatabaseInstancesInstanceSettingBackupConfiguration]
    collation str
    The name of server instance collation.
    connector_enforcement str
    Enables the enforcement of Cloud SQL Auth Proxy or Cloud SQL connectors for all the connections. If enabled, all the direct connections are rejected.
    data_cache_configs Sequence[GetDatabaseInstancesInstanceSettingDataCacheConfig]
    Data cache configurations.
    database_flags Sequence[GetDatabaseInstancesInstanceSettingDatabaseFlag]
    deletion_protection_enabled bool
    Configuration to protect against accidental instance deletion.
    deny_maintenance_periods Sequence[GetDatabaseInstancesInstanceSettingDenyMaintenancePeriod]
    disk_autoresize bool
    Enables auto-resizing of the storage size. Defaults to true.
    disk_autoresize_limit int
    The maximum size, in GB, to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.
    disk_size int
    The size of data disk, in GB. Size of a running instance cannot be reduced but can be increased. The minimum value is 10GB.
    disk_type str
    The type of data disk: PD_SSD or PD_HDD. Defaults to PD_SSD.
    edition str
    The edition of the instance, can be ENTERPRISE or ENTERPRISE_PLUS.
    enable_dataplex_integration bool
    Enables Dataplex Integration.
    enable_google_ml_integration bool
    Enables Vertex AI Integration.
    insights_configs Sequence[GetDatabaseInstancesInstanceSettingInsightsConfig]
    Configuration of Query Insights.
    ip_configurations Sequence[GetDatabaseInstancesInstanceSettingIpConfiguration]
    location_preferences Sequence[GetDatabaseInstancesInstanceSettingLocationPreference]
    maintenance_windows Sequence[GetDatabaseInstancesInstanceSettingMaintenanceWindow]
    Declares a one-hour maintenance window when an Instance can automatically restart to apply updates. The maintenance window is specified in UTC time.
    password_validation_policies Sequence[GetDatabaseInstancesInstanceSettingPasswordValidationPolicy]
    pricing_plan str
    Pricing plan for this instance, can only be PER_USE.
    sql_server_audit_configs Sequence[GetDatabaseInstancesInstanceSettingSqlServerAuditConfig]
    tier str
    To filter out the Cloud SQL instances based on the tier(or machine type) of the database instances.
    time_zone str
    The time_zone to be used by the database engine (supported only for SQL Server), in SQL Server timezone format.
    user_labels Mapping[str, str]
    A set of key/value user label pairs to assign to the instance.
    version int
    Used to make sure changes to the settings block are atomic.
    activationPolicy String
    This specifies when the instance should be active. Can be either ALWAYS, NEVER or ON_DEMAND.
    activeDirectoryConfigs List<Property Map>
    advancedMachineFeatures List<Property Map>
    availabilityType String
    The availability type of the Cloud SQL instance, high availability (REGIONAL) or single zone (ZONAL). For all instances, ensure that settings.backup_configuration.enabled is set to true. For MySQL instances, ensure that settings.backup_configuration.binary_log_enabled is set to true. For Postgres instances, ensure that settings.backup_configuration.point_in_time_recovery_enabled is set to true. Defaults to ZONAL.
    backupConfigurations List<Property Map>
    collation String
    The name of server instance collation.
    connectorEnforcement String
    Enables the enforcement of Cloud SQL Auth Proxy or Cloud SQL connectors for all the connections. If enabled, all the direct connections are rejected.
    dataCacheConfigs List<Property Map>
    Data cache configurations.
    databaseFlags List<Property Map>
    deletionProtectionEnabled Boolean
    Configuration to protect against accidental instance deletion.
    denyMaintenancePeriods List<Property Map>
    diskAutoresize Boolean
    Enables auto-resizing of the storage size. Defaults to true.
    diskAutoresizeLimit Number
    The maximum size, in GB, to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.
    diskSize Number
    The size of data disk, in GB. Size of a running instance cannot be reduced but can be increased. The minimum value is 10GB.
    diskType String
    The type of data disk: PD_SSD or PD_HDD. Defaults to PD_SSD.
    edition String
    The edition of the instance, can be ENTERPRISE or ENTERPRISE_PLUS.
    enableDataplexIntegration Boolean
    Enables Dataplex Integration.
    enableGoogleMlIntegration Boolean
    Enables Vertex AI Integration.
    insightsConfigs List<Property Map>
    Configuration of Query Insights.
    ipConfigurations List<Property Map>
    locationPreferences List<Property Map>
    maintenanceWindows List<Property Map>
    Declares a one-hour maintenance window when an Instance can automatically restart to apply updates. The maintenance window is specified in UTC time.
    passwordValidationPolicies List<Property Map>
    pricingPlan String
    Pricing plan for this instance, can only be PER_USE.
    sqlServerAuditConfigs List<Property Map>
    tier String
    To filter out the Cloud SQL instances based on the tier(or machine type) of the database instances.
    timeZone String
    The time_zone to be used by the database engine (supported only for SQL Server), in SQL Server timezone format.
    userLabels Map<String>
    A set of key/value user label pairs to assign to the instance.
    version Number
    Used to make sure changes to the settings block are atomic.

    GetDatabaseInstancesInstanceSettingActiveDirectoryConfig

    Domain string
    Domain name of the Active Directory for SQL Server (e.g., mydomain.com).
    Domain string
    Domain name of the Active Directory for SQL Server (e.g., mydomain.com).
    domain String
    Domain name of the Active Directory for SQL Server (e.g., mydomain.com).
    domain string
    Domain name of the Active Directory for SQL Server (e.g., mydomain.com).
    domain str
    Domain name of the Active Directory for SQL Server (e.g., mydomain.com).
    domain String
    Domain name of the Active Directory for SQL Server (e.g., mydomain.com).

    GetDatabaseInstancesInstanceSettingAdvancedMachineFeature

    ThreadsPerCore int
    The number of threads per physical core. Can be 1 or 2.
    ThreadsPerCore int
    The number of threads per physical core. Can be 1 or 2.
    threadsPerCore Integer
    The number of threads per physical core. Can be 1 or 2.
    threadsPerCore number
    The number of threads per physical core. Can be 1 or 2.
    threads_per_core int
    The number of threads per physical core. Can be 1 or 2.
    threadsPerCore Number
    The number of threads per physical core. Can be 1 or 2.

    GetDatabaseInstancesInstanceSettingBackupConfiguration

    BackupRetentionSettings List<GetDatabaseInstancesInstanceSettingBackupConfigurationBackupRetentionSetting>
    BinaryLogEnabled bool
    True if binary logging is enabled. If settings.backup_configuration.enabled is false, this must be as well. Can only be used with MySQL.
    Enabled bool
    True if backup configuration is enabled.
    Location string
    Location of the backup configuration.
    PointInTimeRecoveryEnabled bool
    True if Point-in-time recovery is enabled.
    StartTime string
    HH:MM format time indicating when backup configuration starts.
    TransactionLogRetentionDays int
    The number of days of transaction logs we retain for point in time restore, from 1-7. (For PostgreSQL Enterprise Plus instances, from 1 to 35.)
    BackupRetentionSettings []GetDatabaseInstancesInstanceSettingBackupConfigurationBackupRetentionSetting
    BinaryLogEnabled bool
    True if binary logging is enabled. If settings.backup_configuration.enabled is false, this must be as well. Can only be used with MySQL.
    Enabled bool
    True if backup configuration is enabled.
    Location string
    Location of the backup configuration.
    PointInTimeRecoveryEnabled bool
    True if Point-in-time recovery is enabled.
    StartTime string
    HH:MM format time indicating when backup configuration starts.
    TransactionLogRetentionDays int
    The number of days of transaction logs we retain for point in time restore, from 1-7. (For PostgreSQL Enterprise Plus instances, from 1 to 35.)
    backupRetentionSettings List<GetDatabaseInstancesInstanceSettingBackupConfigurationBackupRetentionSetting>
    binaryLogEnabled Boolean
    True if binary logging is enabled. If settings.backup_configuration.enabled is false, this must be as well. Can only be used with MySQL.
    enabled Boolean
    True if backup configuration is enabled.
    location String
    Location of the backup configuration.
    pointInTimeRecoveryEnabled Boolean
    True if Point-in-time recovery is enabled.
    startTime String
    HH:MM format time indicating when backup configuration starts.
    transactionLogRetentionDays Integer
    The number of days of transaction logs we retain for point in time restore, from 1-7. (For PostgreSQL Enterprise Plus instances, from 1 to 35.)
    backupRetentionSettings GetDatabaseInstancesInstanceSettingBackupConfigurationBackupRetentionSetting[]
    binaryLogEnabled boolean
    True if binary logging is enabled. If settings.backup_configuration.enabled is false, this must be as well. Can only be used with MySQL.
    enabled boolean
    True if backup configuration is enabled.
    location string
    Location of the backup configuration.
    pointInTimeRecoveryEnabled boolean
    True if Point-in-time recovery is enabled.
    startTime string
    HH:MM format time indicating when backup configuration starts.
    transactionLogRetentionDays number
    The number of days of transaction logs we retain for point in time restore, from 1-7. (For PostgreSQL Enterprise Plus instances, from 1 to 35.)
    backup_retention_settings Sequence[GetDatabaseInstancesInstanceSettingBackupConfigurationBackupRetentionSetting]
    binary_log_enabled bool
    True if binary logging is enabled. If settings.backup_configuration.enabled is false, this must be as well. Can only be used with MySQL.
    enabled bool
    True if backup configuration is enabled.
    location str
    Location of the backup configuration.
    point_in_time_recovery_enabled bool
    True if Point-in-time recovery is enabled.
    start_time str
    HH:MM format time indicating when backup configuration starts.
    transaction_log_retention_days int
    The number of days of transaction logs we retain for point in time restore, from 1-7. (For PostgreSQL Enterprise Plus instances, from 1 to 35.)
    backupRetentionSettings List<Property Map>
    binaryLogEnabled Boolean
    True if binary logging is enabled. If settings.backup_configuration.enabled is false, this must be as well. Can only be used with MySQL.
    enabled Boolean
    True if backup configuration is enabled.
    location String
    Location of the backup configuration.
    pointInTimeRecoveryEnabled Boolean
    True if Point-in-time recovery is enabled.
    startTime String
    HH:MM format time indicating when backup configuration starts.
    transactionLogRetentionDays Number
    The number of days of transaction logs we retain for point in time restore, from 1-7. (For PostgreSQL Enterprise Plus instances, from 1 to 35.)

    GetDatabaseInstancesInstanceSettingBackupConfigurationBackupRetentionSetting

    RetainedBackups int
    Number of backups to retain.
    RetentionUnit string
    The unit that 'retainedBackups' represents. Defaults to COUNT
    RetainedBackups int
    Number of backups to retain.
    RetentionUnit string
    The unit that 'retainedBackups' represents. Defaults to COUNT
    retainedBackups Integer
    Number of backups to retain.
    retentionUnit String
    The unit that 'retainedBackups' represents. Defaults to COUNT
    retainedBackups number
    Number of backups to retain.
    retentionUnit string
    The unit that 'retainedBackups' represents. Defaults to COUNT
    retained_backups int
    Number of backups to retain.
    retention_unit str
    The unit that 'retainedBackups' represents. Defaults to COUNT
    retainedBackups Number
    Number of backups to retain.
    retentionUnit String
    The unit that 'retainedBackups' represents. Defaults to COUNT

    GetDatabaseInstancesInstanceSettingDataCacheConfig

    DataCacheEnabled bool
    Whether data cache is enabled for the instance.
    DataCacheEnabled bool
    Whether data cache is enabled for the instance.
    dataCacheEnabled Boolean
    Whether data cache is enabled for the instance.
    dataCacheEnabled boolean
    Whether data cache is enabled for the instance.
    data_cache_enabled bool
    Whether data cache is enabled for the instance.
    dataCacheEnabled Boolean
    Whether data cache is enabled for the instance.

    GetDatabaseInstancesInstanceSettingDatabaseFlag

    Name string
    Name of the flag.
    Value string
    Value of the flag.
    Name string
    Name of the flag.
    Value string
    Value of the flag.
    name String
    Name of the flag.
    value String
    Value of the flag.
    name string
    Name of the flag.
    value string
    Value of the flag.
    name str
    Name of the flag.
    value str
    Value of the flag.
    name String
    Name of the flag.
    value String
    Value of the flag.

    GetDatabaseInstancesInstanceSettingDenyMaintenancePeriod

    EndDate string
    End date before which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
    StartDate string
    Start date after which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
    Time string
    Time in UTC when the "deny maintenance period" starts on start_date and ends on end_date. The time is in format: HH:mm:SS, i.e., 00:00:00
    EndDate string
    End date before which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
    StartDate string
    Start date after which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
    Time string
    Time in UTC when the "deny maintenance period" starts on start_date and ends on end_date. The time is in format: HH:mm:SS, i.e., 00:00:00
    endDate String
    End date before which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
    startDate String
    Start date after which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
    time String
    Time in UTC when the "deny maintenance period" starts on start_date and ends on end_date. The time is in format: HH:mm:SS, i.e., 00:00:00
    endDate string
    End date before which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
    startDate string
    Start date after which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
    time string
    Time in UTC when the "deny maintenance period" starts on start_date and ends on end_date. The time is in format: HH:mm:SS, i.e., 00:00:00
    end_date str
    End date before which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
    start_date str
    Start date after which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
    time str
    Time in UTC when the "deny maintenance period" starts on start_date and ends on end_date. The time is in format: HH:mm:SS, i.e., 00:00:00
    endDate String
    End date before which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
    startDate String
    Start date after which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
    time String
    Time in UTC when the "deny maintenance period" starts on start_date and ends on end_date. The time is in format: HH:mm:SS, i.e., 00:00:00

    GetDatabaseInstancesInstanceSettingInsightsConfig

    QueryInsightsEnabled bool
    True if Query Insights feature is enabled.
    QueryPlansPerMinute int
    Number of query execution plans captured by Insights per minute for all queries combined. Between 0 and 20. Default to 5. For Enterprise Plus instances, from 0 to 200.
    QueryStringLength int
    Maximum query length stored in bytes. Between 256 and 4500. Default to 1024. For Enterprise Plus instances, from 1 to 1048576.
    RecordApplicationTags bool
    True if Query Insights will record application tags from query when enabled.
    RecordClientAddress bool
    True if Query Insights will record client address when enabled.
    QueryInsightsEnabled bool
    True if Query Insights feature is enabled.
    QueryPlansPerMinute int
    Number of query execution plans captured by Insights per minute for all queries combined. Between 0 and 20. Default to 5. For Enterprise Plus instances, from 0 to 200.
    QueryStringLength int
    Maximum query length stored in bytes. Between 256 and 4500. Default to 1024. For Enterprise Plus instances, from 1 to 1048576.
    RecordApplicationTags bool
    True if Query Insights will record application tags from query when enabled.
    RecordClientAddress bool
    True if Query Insights will record client address when enabled.
    queryInsightsEnabled Boolean
    True if Query Insights feature is enabled.
    queryPlansPerMinute Integer
    Number of query execution plans captured by Insights per minute for all queries combined. Between 0 and 20. Default to 5. For Enterprise Plus instances, from 0 to 200.
    queryStringLength Integer
    Maximum query length stored in bytes. Between 256 and 4500. Default to 1024. For Enterprise Plus instances, from 1 to 1048576.
    recordApplicationTags Boolean
    True if Query Insights will record application tags from query when enabled.
    recordClientAddress Boolean
    True if Query Insights will record client address when enabled.
    queryInsightsEnabled boolean
    True if Query Insights feature is enabled.
    queryPlansPerMinute number
    Number of query execution plans captured by Insights per minute for all queries combined. Between 0 and 20. Default to 5. For Enterprise Plus instances, from 0 to 200.
    queryStringLength number
    Maximum query length stored in bytes. Between 256 and 4500. Default to 1024. For Enterprise Plus instances, from 1 to 1048576.
    recordApplicationTags boolean
    True if Query Insights will record application tags from query when enabled.
    recordClientAddress boolean
    True if Query Insights will record client address when enabled.
    query_insights_enabled bool
    True if Query Insights feature is enabled.
    query_plans_per_minute int
    Number of query execution plans captured by Insights per minute for all queries combined. Between 0 and 20. Default to 5. For Enterprise Plus instances, from 0 to 200.
    query_string_length int
    Maximum query length stored in bytes. Between 256 and 4500. Default to 1024. For Enterprise Plus instances, from 1 to 1048576.
    record_application_tags bool
    True if Query Insights will record application tags from query when enabled.
    record_client_address bool
    True if Query Insights will record client address when enabled.
    queryInsightsEnabled Boolean
    True if Query Insights feature is enabled.
    queryPlansPerMinute Number
    Number of query execution plans captured by Insights per minute for all queries combined. Between 0 and 20. Default to 5. For Enterprise Plus instances, from 0 to 200.
    queryStringLength Number
    Maximum query length stored in bytes. Between 256 and 4500. Default to 1024. For Enterprise Plus instances, from 1 to 1048576.
    recordApplicationTags Boolean
    True if Query Insights will record application tags from query when enabled.
    recordClientAddress Boolean
    True if Query Insights will record client address when enabled.

    GetDatabaseInstancesInstanceSettingIpConfiguration

    AllocatedIpRange string
    The name of the allocated ip range for the private ip CloudSQL instance. For example: "google-managed-services-default". If set, the instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression a-z?.
    AuthorizedNetworks List<GetDatabaseInstancesInstanceSettingIpConfigurationAuthorizedNetwork>
    EnablePrivatePathForGoogleCloudServices bool
    Whether Google Cloud services such as BigQuery are allowed to access data in this Cloud SQL instance over a private IP connection. SQLSERVER database type is not supported.
    Ipv4Enabled bool
    Whether this Cloud SQL instance should be assigned a public IPV4 address. At least ipv4_enabled must be enabled or a private_network must be configured.
    PrivateNetwork string
    The VPC network from which the Cloud SQL instance is accessible for private IP. For example, projects/myProject/global/networks/default. Specifying a network enables private IP. At least ipv4_enabled must be enabled or a private_network must be configured. This setting can be updated, but it cannot be removed after it is set.
    PscConfigs List<GetDatabaseInstancesInstanceSettingIpConfigurationPscConfig>
    PSC settings for a Cloud SQL instance.
    ServerCaMode string
    Specify how the server certificate's Certificate Authority is hosted.
    ServerCaPool string
    The resource name of the server CA pool for an instance with "CUSTOMER_MANAGED_CAS_CA" as the "server_ca_mode".
    SslMode string
    Specify how SSL connection should be enforced in DB connections.
    AllocatedIpRange string
    The name of the allocated ip range for the private ip CloudSQL instance. For example: "google-managed-services-default". If set, the instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression a-z?.
    AuthorizedNetworks []GetDatabaseInstancesInstanceSettingIpConfigurationAuthorizedNetwork
    EnablePrivatePathForGoogleCloudServices bool
    Whether Google Cloud services such as BigQuery are allowed to access data in this Cloud SQL instance over a private IP connection. SQLSERVER database type is not supported.
    Ipv4Enabled bool
    Whether this Cloud SQL instance should be assigned a public IPV4 address. At least ipv4_enabled must be enabled or a private_network must be configured.
    PrivateNetwork string
    The VPC network from which the Cloud SQL instance is accessible for private IP. For example, projects/myProject/global/networks/default. Specifying a network enables private IP. At least ipv4_enabled must be enabled or a private_network must be configured. This setting can be updated, but it cannot be removed after it is set.
    PscConfigs []GetDatabaseInstancesInstanceSettingIpConfigurationPscConfig
    PSC settings for a Cloud SQL instance.
    ServerCaMode string
    Specify how the server certificate's Certificate Authority is hosted.
    ServerCaPool string
    The resource name of the server CA pool for an instance with "CUSTOMER_MANAGED_CAS_CA" as the "server_ca_mode".
    SslMode string
    Specify how SSL connection should be enforced in DB connections.
    allocatedIpRange String
    The name of the allocated ip range for the private ip CloudSQL instance. For example: "google-managed-services-default". If set, the instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression a-z?.
    authorizedNetworks List<GetDatabaseInstancesInstanceSettingIpConfigurationAuthorizedNetwork>
    enablePrivatePathForGoogleCloudServices Boolean
    Whether Google Cloud services such as BigQuery are allowed to access data in this Cloud SQL instance over a private IP connection. SQLSERVER database type is not supported.
    ipv4Enabled Boolean
    Whether this Cloud SQL instance should be assigned a public IPV4 address. At least ipv4_enabled must be enabled or a private_network must be configured.
    privateNetwork String
    The VPC network from which the Cloud SQL instance is accessible for private IP. For example, projects/myProject/global/networks/default. Specifying a network enables private IP. At least ipv4_enabled must be enabled or a private_network must be configured. This setting can be updated, but it cannot be removed after it is set.
    pscConfigs List<GetDatabaseInstancesInstanceSettingIpConfigurationPscConfig>
    PSC settings for a Cloud SQL instance.
    serverCaMode String
    Specify how the server certificate's Certificate Authority is hosted.
    serverCaPool String
    The resource name of the server CA pool for an instance with "CUSTOMER_MANAGED_CAS_CA" as the "server_ca_mode".
    sslMode String
    Specify how SSL connection should be enforced in DB connections.
    allocatedIpRange string
    The name of the allocated ip range for the private ip CloudSQL instance. For example: "google-managed-services-default". If set, the instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression a-z?.
    authorizedNetworks GetDatabaseInstancesInstanceSettingIpConfigurationAuthorizedNetwork[]
    enablePrivatePathForGoogleCloudServices boolean
    Whether Google Cloud services such as BigQuery are allowed to access data in this Cloud SQL instance over a private IP connection. SQLSERVER database type is not supported.
    ipv4Enabled boolean
    Whether this Cloud SQL instance should be assigned a public IPV4 address. At least ipv4_enabled must be enabled or a private_network must be configured.
    privateNetwork string
    The VPC network from which the Cloud SQL instance is accessible for private IP. For example, projects/myProject/global/networks/default. Specifying a network enables private IP. At least ipv4_enabled must be enabled or a private_network must be configured. This setting can be updated, but it cannot be removed after it is set.
    pscConfigs GetDatabaseInstancesInstanceSettingIpConfigurationPscConfig[]
    PSC settings for a Cloud SQL instance.
    serverCaMode string
    Specify how the server certificate's Certificate Authority is hosted.
    serverCaPool string
    The resource name of the server CA pool for an instance with "CUSTOMER_MANAGED_CAS_CA" as the "server_ca_mode".
    sslMode string
    Specify how SSL connection should be enforced in DB connections.
    allocated_ip_range str
    The name of the allocated ip range for the private ip CloudSQL instance. For example: "google-managed-services-default". If set, the instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression a-z?.
    authorized_networks Sequence[GetDatabaseInstancesInstanceSettingIpConfigurationAuthorizedNetwork]
    enable_private_path_for_google_cloud_services bool
    Whether Google Cloud services such as BigQuery are allowed to access data in this Cloud SQL instance over a private IP connection. SQLSERVER database type is not supported.
    ipv4_enabled bool
    Whether this Cloud SQL instance should be assigned a public IPV4 address. At least ipv4_enabled must be enabled or a private_network must be configured.
    private_network str
    The VPC network from which the Cloud SQL instance is accessible for private IP. For example, projects/myProject/global/networks/default. Specifying a network enables private IP. At least ipv4_enabled must be enabled or a private_network must be configured. This setting can be updated, but it cannot be removed after it is set.
    psc_configs Sequence[GetDatabaseInstancesInstanceSettingIpConfigurationPscConfig]
    PSC settings for a Cloud SQL instance.
    server_ca_mode str
    Specify how the server certificate's Certificate Authority is hosted.
    server_ca_pool str
    The resource name of the server CA pool for an instance with "CUSTOMER_MANAGED_CAS_CA" as the "server_ca_mode".
    ssl_mode str
    Specify how SSL connection should be enforced in DB connections.
    allocatedIpRange String
    The name of the allocated ip range for the private ip CloudSQL instance. For example: "google-managed-services-default". If set, the instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression a-z?.
    authorizedNetworks List<Property Map>
    enablePrivatePathForGoogleCloudServices Boolean
    Whether Google Cloud services such as BigQuery are allowed to access data in this Cloud SQL instance over a private IP connection. SQLSERVER database type is not supported.
    ipv4Enabled Boolean
    Whether this Cloud SQL instance should be assigned a public IPV4 address. At least ipv4_enabled must be enabled or a private_network must be configured.
    privateNetwork String
    The VPC network from which the Cloud SQL instance is accessible for private IP. For example, projects/myProject/global/networks/default. Specifying a network enables private IP. At least ipv4_enabled must be enabled or a private_network must be configured. This setting can be updated, but it cannot be removed after it is set.
    pscConfigs List<Property Map>
    PSC settings for a Cloud SQL instance.
    serverCaMode String
    Specify how the server certificate's Certificate Authority is hosted.
    serverCaPool String
    The resource name of the server CA pool for an instance with "CUSTOMER_MANAGED_CAS_CA" as the "server_ca_mode".
    sslMode String
    Specify how SSL connection should be enforced in DB connections.

    GetDatabaseInstancesInstanceSettingIpConfigurationAuthorizedNetwork

    ExpirationTime string
    Name string
    Value string
    ExpirationTime string
    Name string
    Value string
    expirationTime String
    name String
    value String
    expirationTime string
    name string
    value string
    expirationTime String
    name String
    value String

    GetDatabaseInstancesInstanceSettingIpConfigurationPscConfig

    AllowedConsumerProjects List<string>
    List of consumer projects that are allow-listed for PSC connections to this instance. This instance can be connected to with PSC from any network in these projects. Each consumer project in this list may be represented by a project number (numeric) or by a project id (alphanumeric).
    PscAutoConnections List<GetDatabaseInstancesInstanceSettingIpConfigurationPscConfigPscAutoConnection>
    A comma-separated list of networks or a comma-separated list of network-project pairs. Each project in this list is represented by a project number (numeric) or by a project ID (alphanumeric). This allows Private Service Connect connections to be created automatically for the specified networks.
    PscEnabled bool
    Whether PSC connectivity is enabled for this instance.
    AllowedConsumerProjects []string
    List of consumer projects that are allow-listed for PSC connections to this instance. This instance can be connected to with PSC from any network in these projects. Each consumer project in this list may be represented by a project number (numeric) or by a project id (alphanumeric).
    PscAutoConnections []GetDatabaseInstancesInstanceSettingIpConfigurationPscConfigPscAutoConnection
    A comma-separated list of networks or a comma-separated list of network-project pairs. Each project in this list is represented by a project number (numeric) or by a project ID (alphanumeric). This allows Private Service Connect connections to be created automatically for the specified networks.
    PscEnabled bool
    Whether PSC connectivity is enabled for this instance.
    allowedConsumerProjects List<String>
    List of consumer projects that are allow-listed for PSC connections to this instance. This instance can be connected to with PSC from any network in these projects. Each consumer project in this list may be represented by a project number (numeric) or by a project id (alphanumeric).
    pscAutoConnections List<GetDatabaseInstancesInstanceSettingIpConfigurationPscConfigPscAutoConnection>
    A comma-separated list of networks or a comma-separated list of network-project pairs. Each project in this list is represented by a project number (numeric) or by a project ID (alphanumeric). This allows Private Service Connect connections to be created automatically for the specified networks.
    pscEnabled Boolean
    Whether PSC connectivity is enabled for this instance.
    allowedConsumerProjects string[]
    List of consumer projects that are allow-listed for PSC connections to this instance. This instance can be connected to with PSC from any network in these projects. Each consumer project in this list may be represented by a project number (numeric) or by a project id (alphanumeric).
    pscAutoConnections GetDatabaseInstancesInstanceSettingIpConfigurationPscConfigPscAutoConnection[]
    A comma-separated list of networks or a comma-separated list of network-project pairs. Each project in this list is represented by a project number (numeric) or by a project ID (alphanumeric). This allows Private Service Connect connections to be created automatically for the specified networks.
    pscEnabled boolean
    Whether PSC connectivity is enabled for this instance.
    allowed_consumer_projects Sequence[str]
    List of consumer projects that are allow-listed for PSC connections to this instance. This instance can be connected to with PSC from any network in these projects. Each consumer project in this list may be represented by a project number (numeric) or by a project id (alphanumeric).
    psc_auto_connections Sequence[GetDatabaseInstancesInstanceSettingIpConfigurationPscConfigPscAutoConnection]
    A comma-separated list of networks or a comma-separated list of network-project pairs. Each project in this list is represented by a project number (numeric) or by a project ID (alphanumeric). This allows Private Service Connect connections to be created automatically for the specified networks.
    psc_enabled bool
    Whether PSC connectivity is enabled for this instance.
    allowedConsumerProjects List<String>
    List of consumer projects that are allow-listed for PSC connections to this instance. This instance can be connected to with PSC from any network in these projects. Each consumer project in this list may be represented by a project number (numeric) or by a project id (alphanumeric).
    pscAutoConnections List<Property Map>
    A comma-separated list of networks or a comma-separated list of network-project pairs. Each project in this list is represented by a project number (numeric) or by a project ID (alphanumeric). This allows Private Service Connect connections to be created automatically for the specified networks.
    pscEnabled Boolean
    Whether PSC connectivity is enabled for this instance.

    GetDatabaseInstancesInstanceSettingIpConfigurationPscConfigPscAutoConnection

    ConsumerNetwork string
    The consumer network of this consumer endpoint. This must be a resource path that includes both the host project and the network name. The consumer host project of this network might be different from the consumer service project.
    ConsumerServiceProjectId string
    The project ID of consumer service project of this consumer endpoint.
    ConsumerNetwork string
    The consumer network of this consumer endpoint. This must be a resource path that includes both the host project and the network name. The consumer host project of this network might be different from the consumer service project.
    ConsumerServiceProjectId string
    The project ID of consumer service project of this consumer endpoint.
    consumerNetwork String
    The consumer network of this consumer endpoint. This must be a resource path that includes both the host project and the network name. The consumer host project of this network might be different from the consumer service project.
    consumerServiceProjectId String
    The project ID of consumer service project of this consumer endpoint.
    consumerNetwork string
    The consumer network of this consumer endpoint. This must be a resource path that includes both the host project and the network name. The consumer host project of this network might be different from the consumer service project.
    consumerServiceProjectId string
    The project ID of consumer service project of this consumer endpoint.
    consumer_network str
    The consumer network of this consumer endpoint. This must be a resource path that includes both the host project and the network name. The consumer host project of this network might be different from the consumer service project.
    consumer_service_project_id str
    The project ID of consumer service project of this consumer endpoint.
    consumerNetwork String
    The consumer network of this consumer endpoint. This must be a resource path that includes both the host project and the network name. The consumer host project of this network might be different from the consumer service project.
    consumerServiceProjectId String
    The project ID of consumer service project of this consumer endpoint.

    GetDatabaseInstancesInstanceSettingLocationPreference

    FollowGaeApplication string
    A Google App Engine application whose zone to remain in. Must be in the same region as this instance.
    SecondaryZone string
    The preferred Compute Engine zone for the secondary/failover
    Zone string
    To filter out the Cloud SQL instances which are located in the specified zone. This zone refers to the Compute Engine zone that the instance is currently serving from.
    FollowGaeApplication string
    A Google App Engine application whose zone to remain in. Must be in the same region as this instance.
    SecondaryZone string
    The preferred Compute Engine zone for the secondary/failover
    Zone string
    To filter out the Cloud SQL instances which are located in the specified zone. This zone refers to the Compute Engine zone that the instance is currently serving from.
    followGaeApplication String
    A Google App Engine application whose zone to remain in. Must be in the same region as this instance.
    secondaryZone String
    The preferred Compute Engine zone for the secondary/failover
    zone String
    To filter out the Cloud SQL instances which are located in the specified zone. This zone refers to the Compute Engine zone that the instance is currently serving from.
    followGaeApplication string
    A Google App Engine application whose zone to remain in. Must be in the same region as this instance.
    secondaryZone string
    The preferred Compute Engine zone for the secondary/failover
    zone string
    To filter out the Cloud SQL instances which are located in the specified zone. This zone refers to the Compute Engine zone that the instance is currently serving from.
    follow_gae_application str
    A Google App Engine application whose zone to remain in. Must be in the same region as this instance.
    secondary_zone str
    The preferred Compute Engine zone for the secondary/failover
    zone str
    To filter out the Cloud SQL instances which are located in the specified zone. This zone refers to the Compute Engine zone that the instance is currently serving from.
    followGaeApplication String
    A Google App Engine application whose zone to remain in. Must be in the same region as this instance.
    secondaryZone String
    The preferred Compute Engine zone for the secondary/failover
    zone String
    To filter out the Cloud SQL instances which are located in the specified zone. This zone refers to the Compute Engine zone that the instance is currently serving from.

    GetDatabaseInstancesInstanceSettingMaintenanceWindow

    Day int
    Day of week (1-7), starting on Monday
    Hour int
    Hour of day (0-23), ignored if day not set
    UpdateTrack string
    Receive updates after one week (canary) or after two weeks (stable) or after five weeks (week5) of notification.
    Day int
    Day of week (1-7), starting on Monday
    Hour int
    Hour of day (0-23), ignored if day not set
    UpdateTrack string
    Receive updates after one week (canary) or after two weeks (stable) or after five weeks (week5) of notification.
    day Integer
    Day of week (1-7), starting on Monday
    hour Integer
    Hour of day (0-23), ignored if day not set
    updateTrack String
    Receive updates after one week (canary) or after two weeks (stable) or after five weeks (week5) of notification.
    day number
    Day of week (1-7), starting on Monday
    hour number
    Hour of day (0-23), ignored if day not set
    updateTrack string
    Receive updates after one week (canary) or after two weeks (stable) or after five weeks (week5) of notification.
    day int
    Day of week (1-7), starting on Monday
    hour int
    Hour of day (0-23), ignored if day not set
    update_track str
    Receive updates after one week (canary) or after two weeks (stable) or after five weeks (week5) of notification.
    day Number
    Day of week (1-7), starting on Monday
    hour Number
    Hour of day (0-23), ignored if day not set
    updateTrack String
    Receive updates after one week (canary) or after two weeks (stable) or after five weeks (week5) of notification.

    GetDatabaseInstancesInstanceSettingPasswordValidationPolicy

    Complexity string
    Password complexity.
    DisallowUsernameSubstring bool
    Disallow username as a part of the password.
    EnablePasswordPolicy bool
    Whether the password policy is enabled or not.
    MinLength int
    Minimum number of characters allowed.
    PasswordChangeInterval string
    Minimum interval after which the password can be changed. This flag is only supported for PostgresSQL.
    ReuseInterval int
    Number of previous passwords that cannot be reused.
    Complexity string
    Password complexity.
    DisallowUsernameSubstring bool
    Disallow username as a part of the password.
    EnablePasswordPolicy bool
    Whether the password policy is enabled or not.
    MinLength int
    Minimum number of characters allowed.
    PasswordChangeInterval string
    Minimum interval after which the password can be changed. This flag is only supported for PostgresSQL.
    ReuseInterval int
    Number of previous passwords that cannot be reused.
    complexity String
    Password complexity.
    disallowUsernameSubstring Boolean
    Disallow username as a part of the password.
    enablePasswordPolicy Boolean
    Whether the password policy is enabled or not.
    minLength Integer
    Minimum number of characters allowed.
    passwordChangeInterval String
    Minimum interval after which the password can be changed. This flag is only supported for PostgresSQL.
    reuseInterval Integer
    Number of previous passwords that cannot be reused.
    complexity string
    Password complexity.
    disallowUsernameSubstring boolean
    Disallow username as a part of the password.
    enablePasswordPolicy boolean
    Whether the password policy is enabled or not.
    minLength number
    Minimum number of characters allowed.
    passwordChangeInterval string
    Minimum interval after which the password can be changed. This flag is only supported for PostgresSQL.
    reuseInterval number
    Number of previous passwords that cannot be reused.
    complexity str
    Password complexity.
    disallow_username_substring bool
    Disallow username as a part of the password.
    enable_password_policy bool
    Whether the password policy is enabled or not.
    min_length int
    Minimum number of characters allowed.
    password_change_interval str
    Minimum interval after which the password can be changed. This flag is only supported for PostgresSQL.
    reuse_interval int
    Number of previous passwords that cannot be reused.
    complexity String
    Password complexity.
    disallowUsernameSubstring Boolean
    Disallow username as a part of the password.
    enablePasswordPolicy Boolean
    Whether the password policy is enabled or not.
    minLength Number
    Minimum number of characters allowed.
    passwordChangeInterval String
    Minimum interval after which the password can be changed. This flag is only supported for PostgresSQL.
    reuseInterval Number
    Number of previous passwords that cannot be reused.

    GetDatabaseInstancesInstanceSettingSqlServerAuditConfig

    Bucket string
    The name of the destination bucket (e.g., gs://mybucket).
    RetentionInterval string
    How long to keep generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s"..
    UploadInterval string
    How often to upload generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s".
    Bucket string
    The name of the destination bucket (e.g., gs://mybucket).
    RetentionInterval string
    How long to keep generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s"..
    UploadInterval string
    How often to upload generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s".
    bucket String
    The name of the destination bucket (e.g., gs://mybucket).
    retentionInterval String
    How long to keep generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s"..
    uploadInterval String
    How often to upload generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s".
    bucket string
    The name of the destination bucket (e.g., gs://mybucket).
    retentionInterval string
    How long to keep generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s"..
    uploadInterval string
    How often to upload generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s".
    bucket str
    The name of the destination bucket (e.g., gs://mybucket).
    retention_interval str
    How long to keep generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s"..
    upload_interval str
    How often to upload generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s".
    bucket String
    The name of the destination bucket (e.g., gs://mybucket).
    retentionInterval String
    How long to keep generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s"..
    uploadInterval String
    How often to upload generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s".

    Package Details

    Repository
    Google Cloud (GCP) Classic pulumi/pulumi-gcp
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the google-beta Terraform Provider.
    gcp logo
    Google Cloud v8.27.0 published on Thursday, Apr 17, 2025 by Pulumi
    pulumi/pulumi-gcp