# Source: https://docs.datadoghq.com/ddsql_reference/data_directory/aws/aws.lightsail_relational_database.dataset.md

---
title: Lightsail Relational Database
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: Docs > DDSQL Reference > Data Directory > Lightsail Relational Database
---

# Lightsail Relational Database

Lightsail Relational Database is a managed database service in AWS Lightsail that provides an easy way to set up, operate, and scale relational databases without deep cloud expertise. It supports popular engines like MySQL and PostgreSQL, offering automated backups, monitoring, and maintenance. Designed for simplicity, it is ideal for small to medium applications that need reliable database performance with predictable pricing.

```
aws.lightsail_relational_database
```

## Fields

| Title                            | ID   | Type       | Data Type                                                                                                                                                                                                                                                                                              | Description |
| -------------------------------- | ---- | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ----------- |
| _key                             | core | string     |
| account_id                       | core | string     |
| arn                              | core | string     | The Amazon Resource Name (ARN) of the database.                                                                                                                                                                                                                                                        |
| backup_retention_enabled         | core | bool       | A Boolean value indicating whether automated backup retention is enabled for the database.                                                                                                                                                                                                             |
| ca_certificate_identifier        | core | string     | The certificate associated with the database.                                                                                                                                                                                                                                                          |
| created_at                       | core | timestamp  | The timestamp when the database was created. Formatted in Unix time.                                                                                                                                                                                                                                   |
| engine                           | core | string     | The database software (for example, MySQL).                                                                                                                                                                                                                                                            |
| engine_version                   | core | string     | The database engine version (for example, 5.7.23).                                                                                                                                                                                                                                                     |
| hardware                         | core | json       | Describes the hardware of the database.                                                                                                                                                                                                                                                                |
| latest_restorable_time           | core | timestamp  | The latest point in time to which the database can be restored. Formatted in Unix time.                                                                                                                                                                                                                |
| location                         | core | json       | The Region name and Availability Zone where the database is located.                                                                                                                                                                                                                                   |
| master_database_name             | core | string     | The name of the master database created when the Lightsail database resource is created.                                                                                                                                                                                                               |
| master_endpoint                  | core | json       | The master endpoint for the database.                                                                                                                                                                                                                                                                  |
| master_username                  | core | string     | The master user name of the database.                                                                                                                                                                                                                                                                  |
| name                             | core | string     | The unique name of the database resource in Lightsail.                                                                                                                                                                                                                                                 |
| next_page_token                  | core | string     | The token to advance to the next page of results from your request. A next page token is not returned if there are no more results to display. To get the next page of results, perform another GetRelationalDatabaseParameters request and specify the next page token using the pageToken parameter. |
| parameter_apply_status           | core | string     | The status of parameter updates for the database.                                                                                                                                                                                                                                                      |
| parameters                       | core | json       | An object describing the result of your get relational database parameters request.                                                                                                                                                                                                                    |
| pending_maintenance_actions      | core | json       | Describes the pending maintenance actions for the database.                                                                                                                                                                                                                                            |
| pending_modified_values          | core | json       | Describes pending database value modifications.                                                                                                                                                                                                                                                        |
| preferred_backup_window          | core | string     | The daily time range during which automated backups are created for the database (for example, 16:00-16:30).                                                                                                                                                                                           |
| preferred_maintenance_window     | core | string     | The weekly time range during which system maintenance can occur on the database. In the format ddd:hh24:mi-ddd:hh24:mi. For example, Tue:17:00-Tue:17:30.                                                                                                                                              |
| publicly_accessible              | core | bool       | A Boolean value indicating whether the database is publicly accessible.                                                                                                                                                                                                                                |
| relational_database_blueprint_id | core | string     | The blueprint ID for the database. A blueprint describes the major engine version of a database.                                                                                                                                                                                                       |
| relational_database_bundle_id    | core | string     | The bundle ID for the database. A bundle describes the performance specifications for your database.                                                                                                                                                                                                   |
| resource_type                    | core | string     | The Lightsail resource type for the database (for example, RelationalDatabase).                                                                                                                                                                                                                        |
| secondary_availability_zone      | core | string     | Describes the secondary Availability Zone of a high availability database. The secondary database is used for failover support of a high availability database.                                                                                                                                        |
| state                            | core | string     | Describes the current state of the database.                                                                                                                                                                                                                                                           |
| support_code                     | core | string     | The support code for the database. Include this code in your email to support when you have questions about a database in Lightsail. This code enables our support team to look up your Lightsail information more easily.                                                                             |
| tags                             | core | hstore_csv |