getDatabaseInstances

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")
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 main
import (
"github.com/pulumi/pulumi-gcp/sdk/v7/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
})
}
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

Return

A collection of values returned by getDatabaseInstances.

Parameters

argument

A collection of arguments for invoking getDatabaseInstances.


suspend fun getDatabaseInstances(databaseVersion: String? = null, project: String? = null, region: String? = null, state: String? = null, tier: String? = null, zone: String? = null): GetDatabaseInstancesResult

Return

A collection of values returned by getDatabaseInstances.

Parameters

databaseVersion

To filter out the Cloud SQL instances which are of the specified database version.

project

The ID of the project in which the resources belong. If it is not provided, the provider project is used.

region

To filter out the Cloud SQL instances which are located in the specified region.

state

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

To filter out the Cloud SQL instances based on the tier(or machine type) of the database instances.

zone

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.

See also


Return

A collection of values returned by getDatabaseInstances.

Parameters

argument

Builder for com.pulumi.gcp.sql.kotlin.inputs.GetDatabaseInstancesPlainArgs.

See also