# Get a PaaS Database by ID.

Endpoint: GET /paas-databases/{paaSDatabaseId}
Version: 3.30.0
Security: ApiKeyAuth

## Security:

  - `ApiKeyAuth` (unknown)
    apiKey in header Authorization

## Path parameters:

  - `paaSDatabaseId` (string, required)
    The ID of the PaaS Database.

## Response 200:

  - `200` (unknown)
    OK

## Response 200 fields (application/json):

  - `id` (string)
    The PaaS Database object entity ID.
    Example: db-123

  - `name` (string)
    The PaaS Database name.
    Example: my-db-123

  - `plugin_id` (string)
    Id of the PaaS plugin which manages this Database.
    Example: plugin-123

  - `is_snapshot_operation_target` (boolean)
    Whether this PaaS Database can be the target of a DCT snapshot operation.

  - `instance_id` (string)
    Id of the PaaS Instance of this Database.
    Example: instance-123

  - `instance_name` (string)
    Name of the PaaS Instance of this Database.
    Example: my-instance-123

  - `cloud_account_id` (string)
    Id of the Cloud Account to which this Database belongs.
    Example: environment-123

  - `cloud_account_name` (string)
    Name of the Cloud Account to which this Database belongs.
    Example: AWS-US-EAST-1

  - `database_engine` (string)
    Name of the database engine.
    Example: Azure SQL Server

  - `database_engine_version` (string)
    Version of the database engine.
    Example: 19.1.2

  - `status` (string)
    The management status of this PaaS Database. DISCOVERED means the database has been found by DCT but is not yet under DCT management. DCT_MANAGED means the database is actively managed by DCT. ROOT means the database serves as the root source for DCT-managed child databases.
    Enum: "DISCOVERED", "DCT_MANAGED", "ROOT"

  - `runtime_status` (string)
    Runtime status of the PaaS Database.
    Enum: "CREATING", "FAILED", "RUNNING", "DEPROVISIONED", "STOPPED", "DELETED_ROOT_SOURCE", "REFRESHING"

  - `connection_strings` (array)
    Connection strings (such as JDBC URLs) for applications to connect to the database.

  - `parent_database_id` (string)
    The ID of the parent PaaS Database, if this is a child database.
    Example: my-db-123

  - `parent_database_name` (string)
    The name of the parent PaaS Database, if this is a child database.
    Example: my-parent-db

  - `root_database_id` (string)
    The ID of the root PaaS Database, if this is a managed database.
    Example: my-root-123

  - `root_database_name` (string)
    The name of the root PaaS Database, if this is a managed database.
    Example: my-root-db

  - `parent_snapshot_id` (string)
    The ID of the parent PaaS Snapshot, if this is a child database.
    Example: my-snapshot-123

  - `is_encrypted` (boolean)
    Whether this database is encrypted or not.
    Example: true

  - `compliance_connector_id` (string)
    ID of the compliance connector created for this PaaS Database if any.
    Example: 123-connector-456

  - `database_type` (string)
    The type of database.
    Enum: "ORACLE", "RDS_POSTGRES", "MSSQL"

  - `owner` (string)
    The owner or responsible party for this database, typically derived from metadata or tags.

  - `created_time` (string)
    The timestamp when the database instance was created, in ISO 8601 date-time format.

  - `size_bytes` (integer)
    The size of the database in bytes.

  - `size_measurement_time` (string)
    The timestamp when the size of the database was retrieved, in ISO 8601 date-time format.

  - `size_measurement_source` (string)
    The source from where the size was retrieved.

  - `current_timeflow_id` (string)
    The ID of the current active PaaS Timeflow for this Database, if the database is live.
    Example: paas-timeflow-abc123

  - `tags` (array)

  - `tags.key` (string, required)
    Key of the tag
    Example: key-1

  - `tags.value` (string, required)
    Value of the tag
    Example: value-1

  - `tags.mirror_on_cloud` (boolean)
    Whether this tag is mirrored from/to the Cloud Provider account hosting the PaaS Database or Instance. Not applicable to non PaaS objects.