Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Azure Native
  3. API Docs
  4. sql
  5. getManagedDatabase
This is the latest version of Azure Native. Use the Azure Native v2 docs if using the v2 version of this package.
Azure Native v3.3.0 published on Monday, Apr 28, 2025 by Pulumi
pulumi/pulumi-azure-native

azure-native.sql.getManagedDatabase

Explore with Pulumi AI

azure-native logo
This is the latest version of Azure Native. Use the Azure Native v2 docs if using the v2 version of this package.
Azure Native v3.3.0 published on Monday, Apr 28, 2025 by Pulumi
pulumi/pulumi-azure-native

    Gets a managed database.

    Uses Azure REST API version 2023-08-01.

    Other available API versions: 2017-03-01-preview, 2018-06-01-preview, 2019-06-01-preview, 2020-02-02-preview, 2020-08-01-preview, 2020-11-01-preview, 2021-02-01-preview, 2021-05-01-preview, 2021-08-01-preview, 2021-11-01, 2021-11-01-preview, 2022-02-01-preview, 2022-05-01-preview, 2022-08-01-preview, 2022-11-01-preview, 2023-02-01-preview, 2023-05-01-preview, 2023-08-01-preview, 2024-05-01-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native sql [ApiVersion]. See the version guide for details.

    Using getManagedDatabase

    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 getManagedDatabase(args: GetManagedDatabaseArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseResult>
function getManagedDatabaseOutput(args: GetManagedDatabaseOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseResult>
    def get_managed_database(database_name: Optional[str] = None,
                         managed_instance_name: Optional[str] = None,
                         resource_group_name: Optional[str] = None,
                         opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseResult
def get_managed_database_output(database_name: Optional[pulumi.Input[str]] = None,
                         managed_instance_name: Optional[pulumi.Input[str]] = None,
                         resource_group_name: Optional[pulumi.Input[str]] = None,
                         opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseResult]
    func LookupManagedDatabase(ctx *Context, args *LookupManagedDatabaseArgs, opts ...InvokeOption) (*LookupManagedDatabaseResult, error)
func LookupManagedDatabaseOutput(ctx *Context, args *LookupManagedDatabaseOutputArgs, opts ...InvokeOption) LookupManagedDatabaseResultOutput

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

    public static class GetManagedDatabase 
{
    public static Task<GetManagedDatabaseResult> InvokeAsync(GetManagedDatabaseArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseResult> Invoke(GetManagedDatabaseInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetManagedDatabaseResult> getManagedDatabase(GetManagedDatabaseArgs args, InvokeOptions options)
public static Output<GetManagedDatabaseResult> getManagedDatabase(GetManagedDatabaseArgs args, InvokeOptions options)

    fn::invoke:
  function: azure-native:sql:getManagedDatabase
  arguments:
    # arguments dictionary

    The following arguments are supported:

    DatabaseName string
    The name of the database.
    ManagedInstanceName string
    The name of the managed instance.
    ResourceGroupName string
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    DatabaseName string
    The name of the database.
    ManagedInstanceName string
    The name of the managed instance.
    ResourceGroupName string
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    databaseName String
    The name of the database.
    managedInstanceName String
    The name of the managed instance.
    resourceGroupName String
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    databaseName string
    The name of the database.
    managedInstanceName string
    The name of the managed instance.
    resourceGroupName string
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    database_name str
    The name of the database.
    managed_instance_name str
    The name of the managed instance.
    resource_group_name str
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    databaseName String
    The name of the database.
    managedInstanceName String
    The name of the managed instance.
    resourceGroupName String
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

    getManagedDatabase Result

    The following output properties are available:

    AzureApiVersion string
    The Azure API version of the resource.
    CreationDate string
    Creation date of the database.
    DefaultSecondaryLocation string
    Geo paired region.
    EarliestRestorePoint string
    Earliest restore point in time for point in time restore.
    FailoverGroupId string
    Instance Failover Group resource identifier that this managed database belongs to.
    Id string
    Resource ID.
    Location string
    Resource location.
    Name string
    Resource name.
    Status string
    Status of the database.
    Type string
    Resource type.
    CatalogCollation string
    Collation of the metadata catalog.
    Collation string
    Collation of the managed database.
    IsLedgerOn bool
    Whether or not this database is a ledger database, which means all tables in the database are ledger tables. Note: the value of this property cannot be changed after the database has been created.
    Tags Dictionary<string, string>
    Resource tags.
    AzureApiVersion string
    The Azure API version of the resource.
    CreationDate string
    Creation date of the database.
    DefaultSecondaryLocation string
    Geo paired region.
    EarliestRestorePoint string
    Earliest restore point in time for point in time restore.
    FailoverGroupId string
    Instance Failover Group resource identifier that this managed database belongs to.
    Id string
    Resource ID.
    Location string
    Resource location.
    Name string
    Resource name.
    Status string
    Status of the database.
    Type string
    Resource type.
    CatalogCollation string
    Collation of the metadata catalog.
    Collation string
    Collation of the managed database.
    IsLedgerOn bool
    Whether or not this database is a ledger database, which means all tables in the database are ledger tables. Note: the value of this property cannot be changed after the database has been created.
    Tags map[string]string
    Resource tags.
    azureApiVersion String
    The Azure API version of the resource.
    creationDate String
    Creation date of the database.
    defaultSecondaryLocation String
    Geo paired region.
    earliestRestorePoint String
    Earliest restore point in time for point in time restore.
    failoverGroupId String
    Instance Failover Group resource identifier that this managed database belongs to.
    id String
    Resource ID.
    location String
    Resource location.
    name String
    Resource name.
    status String
    Status of the database.
    type String
    Resource type.
    catalogCollation String
    Collation of the metadata catalog.
    collation String
    Collation of the managed database.
    isLedgerOn Boolean
    Whether or not this database is a ledger database, which means all tables in the database are ledger tables. Note: the value of this property cannot be changed after the database has been created.
    tags Map<String,String>
    Resource tags.
    azureApiVersion string
    The Azure API version of the resource.
    creationDate string
    Creation date of the database.
    defaultSecondaryLocation string
    Geo paired region.
    earliestRestorePoint string
    Earliest restore point in time for point in time restore.
    failoverGroupId string
    Instance Failover Group resource identifier that this managed database belongs to.
    id string
    Resource ID.
    location string
    Resource location.
    name string
    Resource name.
    status string
    Status of the database.
    type string
    Resource type.
    catalogCollation string
    Collation of the metadata catalog.
    collation string
    Collation of the managed database.
    isLedgerOn boolean
    Whether or not this database is a ledger database, which means all tables in the database are ledger tables. Note: the value of this property cannot be changed after the database has been created.
    tags {[key: string]: string}
    Resource tags.
    azure_api_version str
    The Azure API version of the resource.
    creation_date str
    Creation date of the database.
    default_secondary_location str
    Geo paired region.
    earliest_restore_point str
    Earliest restore point in time for point in time restore.
    failover_group_id str
    Instance Failover Group resource identifier that this managed database belongs to.
    id str
    Resource ID.
    location str
    Resource location.
    name str
    Resource name.
    status str
    Status of the database.
    type str
    Resource type.
    catalog_collation str
    Collation of the metadata catalog.
    collation str
    Collation of the managed database.
    is_ledger_on bool
    Whether or not this database is a ledger database, which means all tables in the database are ledger tables. Note: the value of this property cannot be changed after the database has been created.
    tags Mapping[str, str]
    Resource tags.
    azureApiVersion String
    The Azure API version of the resource.
    creationDate String
    Creation date of the database.
    defaultSecondaryLocation String
    Geo paired region.
    earliestRestorePoint String
    Earliest restore point in time for point in time restore.
    failoverGroupId String
    Instance Failover Group resource identifier that this managed database belongs to.
    id String
    Resource ID.
    location String
    Resource location.
    name String
    Resource name.
    status String
    Status of the database.
    type String
    Resource type.
    catalogCollation String
    Collation of the metadata catalog.
    collation String
    Collation of the managed database.
    isLedgerOn Boolean
    Whether or not this database is a ledger database, which means all tables in the database are ledger tables. Note: the value of this property cannot be changed after the database has been created.
    tags Map<String>
    Resource tags.

    Package Details

    Repository
    Azure Native pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native logo
    This is the latest version of Azure Native. Use the Azure Native v2 docs if using the v2 version of this package.
    Azure Native v3.3.0 published on Monday, Apr 28, 2025 by Pulumi
    pulumi/pulumi-azure-native