gcp.sql.getDatabases
Explore with Pulumi AI
Use this data source to get information about a list of databases in a Cloud SQL instance.
Example Usage
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Gcp = Pulumi.Gcp;
return await Deployment.RunAsync(() =>
{
var qa = Gcp.Sql.GetDatabases.Invoke(new()
{
Instance = google_sql_database_instance.Main.Name,
});
});
package main
import (
"github.com/pulumi/pulumi-gcp/sdk/v6/go/gcp/sql"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sql.GetDatabases(ctx, &sql.GetDatabasesArgs{
Instance: google_sql_database_instance.Main.Name,
}, 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.GetDatabasesArgs;
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.getDatabases(GetDatabasesArgs.builder()
.instance(google_sql_database_instance.main().name())
.build());
}
}
import pulumi
import pulumi_gcp as gcp
qa = gcp.sql.get_databases(instance=google_sql_database_instance["main"]["name"])
import * as pulumi from "@pulumi/pulumi";
import * as gcp from "@pulumi/gcp";
const qa = gcp.sql.getDatabases({
instance: google_sql_database_instance.main.name,
});
variables:
qa:
fn::invoke:
Function: gcp:sql:getDatabases
Arguments:
instance: ${google_sql_database_instance.main.name}
Using getDatabases
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 getDatabases(args: GetDatabasesArgs, opts?: InvokeOptions): Promise<GetDatabasesResult>
function getDatabasesOutput(args: GetDatabasesOutputArgs, opts?: InvokeOptions): Output<GetDatabasesResult>
def get_databases(instance: Optional[str] = None,
project: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> GetDatabasesResult
def get_databases_output(instance: Optional[pulumi.Input[str]] = None,
project: Optional[pulumi.Input[str]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetDatabasesResult]
func GetDatabases(ctx *Context, args *GetDatabasesArgs, opts ...InvokeOption) (*GetDatabasesResult, error)
func GetDatabasesOutput(ctx *Context, args *GetDatabasesOutputArgs, opts ...InvokeOption) GetDatabasesResultOutput
> Note: This function is named GetDatabases
in the Go SDK.
public static class GetDatabases
{
public static Task<GetDatabasesResult> InvokeAsync(GetDatabasesArgs args, InvokeOptions? opts = null)
public static Output<GetDatabasesResult> Invoke(GetDatabasesInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetDatabasesResult> getDatabases(GetDatabasesArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
function: gcp:sql/getDatabases:getDatabases
arguments:
# arguments dictionary
The following arguments are supported:
getDatabases Result
The following output properties are available:
- Databases
List<Get
Databases Database> - Id string
The provider-assigned unique ID for this managed resource.
- Instance string
- Project string
- Databases
[]Get
Databases Database - Id string
The provider-assigned unique ID for this managed resource.
- Instance string
- Project string
- databases
List<Get
Databases Database> - id String
The provider-assigned unique ID for this managed resource.
- instance String
- project String
- databases
Get
Databases Database[] - id string
The provider-assigned unique ID for this managed resource.
- instance string
- project string
- databases
Sequence[Get
Databases Database] - id str
The provider-assigned unique ID for this managed resource.
- instance str
- project str
- databases List<Property Map>
- id String
The provider-assigned unique ID for this managed resource.
- instance String
- project String
Supporting Types
GetDatabasesDatabase
- Charset string
- Collation string
- Deletion
Policy string - Instance string
The name of the Cloud SQL database instance in which the database belongs.
- Name string
- Project string
The ID of the project in which the instance belongs.
Note This datasource performs client-side sorting to provide consistent ordering of the databases.
- Self
Link string
- Charset string
- Collation string
- Deletion
Policy string - Instance string
The name of the Cloud SQL database instance in which the database belongs.
- Name string
- Project string
The ID of the project in which the instance belongs.
Note This datasource performs client-side sorting to provide consistent ordering of the databases.
- Self
Link string
- charset String
- collation String
- deletion
Policy String - instance String
The name of the Cloud SQL database instance in which the database belongs.
- name String
- project String
The ID of the project in which the instance belongs.
Note This datasource performs client-side sorting to provide consistent ordering of the databases.
- self
Link String
- charset string
- collation string
- deletion
Policy string - instance string
The name of the Cloud SQL database instance in which the database belongs.
- name string
- project string
The ID of the project in which the instance belongs.
Note This datasource performs client-side sorting to provide consistent ordering of the databases.
- self
Link string
- charset str
- collation str
- deletion_
policy str - instance str
The name of the Cloud SQL database instance in which the database belongs.
- name str
- project str
The ID of the project in which the instance belongs.
Note This datasource performs client-side sorting to provide consistent ordering of the databases.
- self_
link str
- charset String
- collation String
- deletion
Policy String - instance String
The name of the Cloud SQL database instance in which the database belongs.
- name String
- project String
The ID of the project in which the instance belongs.
Note This datasource performs client-side sorting to provide consistent ordering of the databases.
- self
Link String
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.