1. Packages
  2. Google Cloud Native
  3. API Docs
  4. spanner
  5. spanner/v1
  6. getDatabase

Google Cloud Native is in preview. Google Cloud Classic is fully supported.

Google Cloud Native v0.31.1 published on Thursday, Jul 20, 2023 by Pulumi

google-native.spanner/v1.getDatabase

Explore with Pulumi AI

google-native logo

Google Cloud Native is in preview. Google Cloud Classic is fully supported.

Google Cloud Native v0.31.1 published on Thursday, Jul 20, 2023 by Pulumi

    Gets the state of a Cloud Spanner database.

    Using getDatabase

    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 getDatabase(args: GetDatabaseArgs, opts?: InvokeOptions): Promise<GetDatabaseResult>
    function getDatabaseOutput(args: GetDatabaseOutputArgs, opts?: InvokeOptions): Output<GetDatabaseResult>
    def get_database(database_id: Optional[str] = None,
                     instance_id: Optional[str] = None,
                     project: Optional[str] = None,
                     opts: Optional[InvokeOptions] = None) -> GetDatabaseResult
    def get_database_output(database_id: Optional[pulumi.Input[str]] = None,
                     instance_id: Optional[pulumi.Input[str]] = None,
                     project: Optional[pulumi.Input[str]] = None,
                     opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseResult]
    func LookupDatabase(ctx *Context, args *LookupDatabaseArgs, opts ...InvokeOption) (*LookupDatabaseResult, error)
    func LookupDatabaseOutput(ctx *Context, args *LookupDatabaseOutputArgs, opts ...InvokeOption) LookupDatabaseResultOutput

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

    public static class GetDatabase 
    {
        public static Task<GetDatabaseResult> InvokeAsync(GetDatabaseArgs args, InvokeOptions? opts = null)
        public static Output<GetDatabaseResult> Invoke(GetDatabaseInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetDatabaseResult> getDatabase(GetDatabaseArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: google-native:spanner/v1:getDatabase
      arguments:
        # arguments dictionary

    The following arguments are supported:

    DatabaseId string
    InstanceId string
    Project string
    DatabaseId string
    InstanceId string
    Project string
    databaseId String
    instanceId String
    project String
    databaseId string
    instanceId string
    project string
    databaseId String
    instanceId String
    project String

    getDatabase Result

    The following output properties are available:

    CreateTime string

    If exists, the time at which the database creation started.

    DatabaseDialect string

    The dialect of the Cloud Spanner Database.

    DefaultLeader string

    The read-write region which contains the database's leader replicas. This is the same as the value of default_leader database option set using DatabaseAdmin.CreateDatabase or DatabaseAdmin.UpdateDatabaseDdl. If not explicitly set, this is empty.

    EarliestVersionTime string

    Earliest timestamp at which older versions of the data can be read. This value is continuously updated by Cloud Spanner and becomes stale the moment it is queried. If you are using this value to recover data, make sure to account for the time from the moment when the value is queried to the moment when you initiate the recovery.

    EnableDropProtection bool

    Whether drop protection is enabled for this database. Defaults to false, if not set.

    EncryptionConfig Pulumi.GoogleNative.Spanner.V1.Outputs.EncryptionConfigResponse

    For databases that are using customer managed encryption, this field contains the encryption configuration for the database. For databases that are using Google default or other types of encryption, this field is empty.

    EncryptionInfo List<Pulumi.GoogleNative.Spanner.V1.Outputs.EncryptionInfoResponse>

    For databases that are using customer managed encryption, this field contains the encryption information for the database, such as all Cloud KMS key versions that are in use. The encryption_status' field inside of each EncryptionInfo` is not populated. For databases that are using Google default or other types of encryption, this field is empty. This field is propagated lazily from the backend. There might be a delay from when a key version is being used and when it appears in this field.

    Name string

    The name of the database. Values are of the form projects//instances//databases/, where `` is as specified in the CREATE DATABASE statement. This name can be passed to other API methods to identify the database.

    Reconciling bool

    If true, the database is being updated. If false, there are no ongoing update operations for the database.

    RestoreInfo Pulumi.GoogleNative.Spanner.V1.Outputs.RestoreInfoResponse

    Applicable only for restored databases. Contains information about the restore source.

    State string

    The current database state.

    VersionRetentionPeriod string

    The period in which Cloud Spanner retains all versions of data for the database. This is the same as the value of version_retention_period database option set using UpdateDatabaseDdl. Defaults to 1 hour, if not set.

    CreateTime string

    If exists, the time at which the database creation started.

    DatabaseDialect string

    The dialect of the Cloud Spanner Database.

    DefaultLeader string

    The read-write region which contains the database's leader replicas. This is the same as the value of default_leader database option set using DatabaseAdmin.CreateDatabase or DatabaseAdmin.UpdateDatabaseDdl. If not explicitly set, this is empty.

    EarliestVersionTime string

    Earliest timestamp at which older versions of the data can be read. This value is continuously updated by Cloud Spanner and becomes stale the moment it is queried. If you are using this value to recover data, make sure to account for the time from the moment when the value is queried to the moment when you initiate the recovery.

    EnableDropProtection bool

    Whether drop protection is enabled for this database. Defaults to false, if not set.

    EncryptionConfig EncryptionConfigResponse

    For databases that are using customer managed encryption, this field contains the encryption configuration for the database. For databases that are using Google default or other types of encryption, this field is empty.

    EncryptionInfo []EncryptionInfoResponse

    For databases that are using customer managed encryption, this field contains the encryption information for the database, such as all Cloud KMS key versions that are in use. The encryption_status' field inside of each EncryptionInfo` is not populated. For databases that are using Google default or other types of encryption, this field is empty. This field is propagated lazily from the backend. There might be a delay from when a key version is being used and when it appears in this field.

    Name string

    The name of the database. Values are of the form projects//instances//databases/, where `` is as specified in the CREATE DATABASE statement. This name can be passed to other API methods to identify the database.

    Reconciling bool

    If true, the database is being updated. If false, there are no ongoing update operations for the database.

    RestoreInfo RestoreInfoResponse

    Applicable only for restored databases. Contains information about the restore source.

    State string

    The current database state.

    VersionRetentionPeriod string

    The period in which Cloud Spanner retains all versions of data for the database. This is the same as the value of version_retention_period database option set using UpdateDatabaseDdl. Defaults to 1 hour, if not set.

    createTime String

    If exists, the time at which the database creation started.

    databaseDialect String

    The dialect of the Cloud Spanner Database.

    defaultLeader String

    The read-write region which contains the database's leader replicas. This is the same as the value of default_leader database option set using DatabaseAdmin.CreateDatabase or DatabaseAdmin.UpdateDatabaseDdl. If not explicitly set, this is empty.

    earliestVersionTime String

    Earliest timestamp at which older versions of the data can be read. This value is continuously updated by Cloud Spanner and becomes stale the moment it is queried. If you are using this value to recover data, make sure to account for the time from the moment when the value is queried to the moment when you initiate the recovery.

    enableDropProtection Boolean

    Whether drop protection is enabled for this database. Defaults to false, if not set.

    encryptionConfig EncryptionConfigResponse

    For databases that are using customer managed encryption, this field contains the encryption configuration for the database. For databases that are using Google default or other types of encryption, this field is empty.

    encryptionInfo List<EncryptionInfoResponse>

    For databases that are using customer managed encryption, this field contains the encryption information for the database, such as all Cloud KMS key versions that are in use. The encryption_status' field inside of each EncryptionInfo` is not populated. For databases that are using Google default or other types of encryption, this field is empty. This field is propagated lazily from the backend. There might be a delay from when a key version is being used and when it appears in this field.

    name String

    The name of the database. Values are of the form projects//instances//databases/, where `` is as specified in the CREATE DATABASE statement. This name can be passed to other API methods to identify the database.

    reconciling Boolean

    If true, the database is being updated. If false, there are no ongoing update operations for the database.

    restoreInfo RestoreInfoResponse

    Applicable only for restored databases. Contains information about the restore source.

    state String

    The current database state.

    versionRetentionPeriod String

    The period in which Cloud Spanner retains all versions of data for the database. This is the same as the value of version_retention_period database option set using UpdateDatabaseDdl. Defaults to 1 hour, if not set.

    createTime string

    If exists, the time at which the database creation started.

    databaseDialect string

    The dialect of the Cloud Spanner Database.

    defaultLeader string

    The read-write region which contains the database's leader replicas. This is the same as the value of default_leader database option set using DatabaseAdmin.CreateDatabase or DatabaseAdmin.UpdateDatabaseDdl. If not explicitly set, this is empty.

    earliestVersionTime string

    Earliest timestamp at which older versions of the data can be read. This value is continuously updated by Cloud Spanner and becomes stale the moment it is queried. If you are using this value to recover data, make sure to account for the time from the moment when the value is queried to the moment when you initiate the recovery.

    enableDropProtection boolean

    Whether drop protection is enabled for this database. Defaults to false, if not set.

    encryptionConfig EncryptionConfigResponse

    For databases that are using customer managed encryption, this field contains the encryption configuration for the database. For databases that are using Google default or other types of encryption, this field is empty.

    encryptionInfo EncryptionInfoResponse[]

    For databases that are using customer managed encryption, this field contains the encryption information for the database, such as all Cloud KMS key versions that are in use. The encryption_status' field inside of each EncryptionInfo` is not populated. For databases that are using Google default or other types of encryption, this field is empty. This field is propagated lazily from the backend. There might be a delay from when a key version is being used and when it appears in this field.

    name string

    The name of the database. Values are of the form projects//instances//databases/, where `` is as specified in the CREATE DATABASE statement. This name can be passed to other API methods to identify the database.

    reconciling boolean

    If true, the database is being updated. If false, there are no ongoing update operations for the database.

    restoreInfo RestoreInfoResponse

    Applicable only for restored databases. Contains information about the restore source.

    state string

    The current database state.

    versionRetentionPeriod string

    The period in which Cloud Spanner retains all versions of data for the database. This is the same as the value of version_retention_period database option set using UpdateDatabaseDdl. Defaults to 1 hour, if not set.

    create_time str

    If exists, the time at which the database creation started.

    database_dialect str

    The dialect of the Cloud Spanner Database.

    default_leader str

    The read-write region which contains the database's leader replicas. This is the same as the value of default_leader database option set using DatabaseAdmin.CreateDatabase or DatabaseAdmin.UpdateDatabaseDdl. If not explicitly set, this is empty.

    earliest_version_time str

    Earliest timestamp at which older versions of the data can be read. This value is continuously updated by Cloud Spanner and becomes stale the moment it is queried. If you are using this value to recover data, make sure to account for the time from the moment when the value is queried to the moment when you initiate the recovery.

    enable_drop_protection bool

    Whether drop protection is enabled for this database. Defaults to false, if not set.

    encryption_config EncryptionConfigResponse

    For databases that are using customer managed encryption, this field contains the encryption configuration for the database. For databases that are using Google default or other types of encryption, this field is empty.

    encryption_info Sequence[EncryptionInfoResponse]

    For databases that are using customer managed encryption, this field contains the encryption information for the database, such as all Cloud KMS key versions that are in use. The encryption_status' field inside of each EncryptionInfo` is not populated. For databases that are using Google default or other types of encryption, this field is empty. This field is propagated lazily from the backend. There might be a delay from when a key version is being used and when it appears in this field.

    name str

    The name of the database. Values are of the form projects//instances//databases/, where `` is as specified in the CREATE DATABASE statement. This name can be passed to other API methods to identify the database.

    reconciling bool

    If true, the database is being updated. If false, there are no ongoing update operations for the database.

    restore_info RestoreInfoResponse

    Applicable only for restored databases. Contains information about the restore source.

    state str

    The current database state.

    version_retention_period str

    The period in which Cloud Spanner retains all versions of data for the database. This is the same as the value of version_retention_period database option set using UpdateDatabaseDdl. Defaults to 1 hour, if not set.

    createTime String

    If exists, the time at which the database creation started.

    databaseDialect String

    The dialect of the Cloud Spanner Database.

    defaultLeader String

    The read-write region which contains the database's leader replicas. This is the same as the value of default_leader database option set using DatabaseAdmin.CreateDatabase or DatabaseAdmin.UpdateDatabaseDdl. If not explicitly set, this is empty.

    earliestVersionTime String

    Earliest timestamp at which older versions of the data can be read. This value is continuously updated by Cloud Spanner and becomes stale the moment it is queried. If you are using this value to recover data, make sure to account for the time from the moment when the value is queried to the moment when you initiate the recovery.

    enableDropProtection Boolean

    Whether drop protection is enabled for this database. Defaults to false, if not set.

    encryptionConfig Property Map

    For databases that are using customer managed encryption, this field contains the encryption configuration for the database. For databases that are using Google default or other types of encryption, this field is empty.

    encryptionInfo List<Property Map>

    For databases that are using customer managed encryption, this field contains the encryption information for the database, such as all Cloud KMS key versions that are in use. The encryption_status' field inside of each EncryptionInfo` is not populated. For databases that are using Google default or other types of encryption, this field is empty. This field is propagated lazily from the backend. There might be a delay from when a key version is being used and when it appears in this field.

    name String

    The name of the database. Values are of the form projects//instances//databases/, where `` is as specified in the CREATE DATABASE statement. This name can be passed to other API methods to identify the database.

    reconciling Boolean

    If true, the database is being updated. If false, there are no ongoing update operations for the database.

    restoreInfo Property Map

    Applicable only for restored databases. Contains information about the restore source.

    state String

    The current database state.

    versionRetentionPeriod String

    The period in which Cloud Spanner retains all versions of data for the database. This is the same as the value of version_retention_period database option set using UpdateDatabaseDdl. Defaults to 1 hour, if not set.

    Supporting Types

    BackupInfoResponse

    Backup string

    Name of the backup.

    CreateTime string

    The time the CreateBackup request was received.

    SourceDatabase string

    Name of the database the backup was created from.

    VersionTime string

    The backup contains an externally consistent copy of source_database at the timestamp specified by version_time. If the CreateBackup request did not specify version_time, the version_time of the backup is equivalent to the create_time.

    Backup string

    Name of the backup.

    CreateTime string

    The time the CreateBackup request was received.

    SourceDatabase string

    Name of the database the backup was created from.

    VersionTime string

    The backup contains an externally consistent copy of source_database at the timestamp specified by version_time. If the CreateBackup request did not specify version_time, the version_time of the backup is equivalent to the create_time.

    backup String

    Name of the backup.

    createTime String

    The time the CreateBackup request was received.

    sourceDatabase String

    Name of the database the backup was created from.

    versionTime String

    The backup contains an externally consistent copy of source_database at the timestamp specified by version_time. If the CreateBackup request did not specify version_time, the version_time of the backup is equivalent to the create_time.

    backup string

    Name of the backup.

    createTime string

    The time the CreateBackup request was received.

    sourceDatabase string

    Name of the database the backup was created from.

    versionTime string

    The backup contains an externally consistent copy of source_database at the timestamp specified by version_time. If the CreateBackup request did not specify version_time, the version_time of the backup is equivalent to the create_time.

    backup str

    Name of the backup.

    create_time str

    The time the CreateBackup request was received.

    source_database str

    Name of the database the backup was created from.

    version_time str

    The backup contains an externally consistent copy of source_database at the timestamp specified by version_time. If the CreateBackup request did not specify version_time, the version_time of the backup is equivalent to the create_time.

    backup String

    Name of the backup.

    createTime String

    The time the CreateBackup request was received.

    sourceDatabase String

    Name of the database the backup was created from.

    versionTime String

    The backup contains an externally consistent copy of source_database at the timestamp specified by version_time. If the CreateBackup request did not specify version_time, the version_time of the backup is equivalent to the create_time.

    EncryptionConfigResponse

    KmsKeyName string

    The Cloud KMS key to be used for encrypting and decrypting the database. Values are of the form projects//locations//keyRings//cryptoKeys/.

    KmsKeyName string

    The Cloud KMS key to be used for encrypting and decrypting the database. Values are of the form projects//locations//keyRings//cryptoKeys/.

    kmsKeyName String

    The Cloud KMS key to be used for encrypting and decrypting the database. Values are of the form projects//locations//keyRings//cryptoKeys/.

    kmsKeyName string

    The Cloud KMS key to be used for encrypting and decrypting the database. Values are of the form projects//locations//keyRings//cryptoKeys/.

    kms_key_name str

    The Cloud KMS key to be used for encrypting and decrypting the database. Values are of the form projects//locations//keyRings//cryptoKeys/.

    kmsKeyName String

    The Cloud KMS key to be used for encrypting and decrypting the database. Values are of the form projects//locations//keyRings//cryptoKeys/.

    EncryptionInfoResponse

    EncryptionStatus Pulumi.GoogleNative.Spanner.V1.Inputs.StatusResponse

    If present, the status of a recent encrypt/decrypt call on underlying data for this database or backup. Regardless of status, data is always encrypted at rest.

    EncryptionType string

    The type of encryption.

    KmsKeyVersion string

    A Cloud KMS key version that is being used to protect the database or backup.

    EncryptionStatus StatusResponse

    If present, the status of a recent encrypt/decrypt call on underlying data for this database or backup. Regardless of status, data is always encrypted at rest.

    EncryptionType string

    The type of encryption.

    KmsKeyVersion string

    A Cloud KMS key version that is being used to protect the database or backup.

    encryptionStatus StatusResponse

    If present, the status of a recent encrypt/decrypt call on underlying data for this database or backup. Regardless of status, data is always encrypted at rest.

    encryptionType String

    The type of encryption.

    kmsKeyVersion String

    A Cloud KMS key version that is being used to protect the database or backup.

    encryptionStatus StatusResponse

    If present, the status of a recent encrypt/decrypt call on underlying data for this database or backup. Regardless of status, data is always encrypted at rest.

    encryptionType string

    The type of encryption.

    kmsKeyVersion string

    A Cloud KMS key version that is being used to protect the database or backup.

    encryption_status StatusResponse

    If present, the status of a recent encrypt/decrypt call on underlying data for this database or backup. Regardless of status, data is always encrypted at rest.

    encryption_type str

    The type of encryption.

    kms_key_version str

    A Cloud KMS key version that is being used to protect the database or backup.

    encryptionStatus Property Map

    If present, the status of a recent encrypt/decrypt call on underlying data for this database or backup. Regardless of status, data is always encrypted at rest.

    encryptionType String

    The type of encryption.

    kmsKeyVersion String

    A Cloud KMS key version that is being used to protect the database or backup.

    RestoreInfoResponse

    BackupInfo Pulumi.GoogleNative.Spanner.V1.Inputs.BackupInfoResponse

    Information about the backup used to restore the database. The backup may no longer exist.

    SourceType string

    The type of the restore source.

    BackupInfo BackupInfoResponse

    Information about the backup used to restore the database. The backup may no longer exist.

    SourceType string

    The type of the restore source.

    backupInfo BackupInfoResponse

    Information about the backup used to restore the database. The backup may no longer exist.

    sourceType String

    The type of the restore source.

    backupInfo BackupInfoResponse

    Information about the backup used to restore the database. The backup may no longer exist.

    sourceType string

    The type of the restore source.

    backup_info BackupInfoResponse

    Information about the backup used to restore the database. The backup may no longer exist.

    source_type str

    The type of the restore source.

    backupInfo Property Map

    Information about the backup used to restore the database. The backup may no longer exist.

    sourceType String

    The type of the restore source.

    StatusResponse

    Code int

    The status code, which should be an enum value of google.rpc.Code.

    Details List<ImmutableDictionary<string, string>>

    A list of messages that carry the error details. There is a common set of message types for APIs to use.

    Message string

    A developer-facing error message, which should be in English. Any user-facing error message should be localized and sent in the google.rpc.Status.details field, or localized by the client.

    Code int

    The status code, which should be an enum value of google.rpc.Code.

    Details []map[string]string

    A list of messages that carry the error details. There is a common set of message types for APIs to use.

    Message string

    A developer-facing error message, which should be in English. Any user-facing error message should be localized and sent in the google.rpc.Status.details field, or localized by the client.

    code Integer

    The status code, which should be an enum value of google.rpc.Code.

    details List<Map<String,String>>

    A list of messages that carry the error details. There is a common set of message types for APIs to use.

    message String

    A developer-facing error message, which should be in English. Any user-facing error message should be localized and sent in the google.rpc.Status.details field, or localized by the client.

    code number

    The status code, which should be an enum value of google.rpc.Code.

    details {[key: string]: string}[]

    A list of messages that carry the error details. There is a common set of message types for APIs to use.

    message string

    A developer-facing error message, which should be in English. Any user-facing error message should be localized and sent in the google.rpc.Status.details field, or localized by the client.

    code int

    The status code, which should be an enum value of google.rpc.Code.

    details Sequence[Mapping[str, str]]

    A list of messages that carry the error details. There is a common set of message types for APIs to use.

    message str

    A developer-facing error message, which should be in English. Any user-facing error message should be localized and sent in the google.rpc.Status.details field, or localized by the client.

    code Number

    The status code, which should be an enum value of google.rpc.Code.

    details List<Map<String>>

    A list of messages that carry the error details. There is a common set of message types for APIs to use.

    message String

    A developer-facing error message, which should be in English. Any user-facing error message should be localized and sent in the google.rpc.Status.details field, or localized by the client.

    Package Details

    Repository
    Google Cloud Native pulumi/pulumi-google-native
    License
    Apache-2.0
    google-native logo

    Google Cloud Native is in preview. Google Cloud Classic is fully supported.

    Google Cloud Native v0.31.1 published on Thursday, Jul 20, 2023 by Pulumi