# DynamoDB

> Connect DynamoDB to sanda: what to prepare, the fields the connection form asks for, and how its data lands in your warehouse.

## Connect DynamoDB

:::steps
1. **Open the catalogue.** In the console, go to **Data · Connections** and press **New connection**.
2. **Choose DynamoDB.** It is listed under databases; you can also search for it by name.
3. **Fill in the form.** Enter the fields below. Credentials go straight to sanda’s sync engine and are never stored in sanda’s database.
4. **Choose what to sync.** Pick the tables you want, and a sync mode for each. See [choose what to sync](https://docs.sanda-os.com.au/connections/choose-tables).
5. **Run the first sync.** sanda tests the connection, then lands each table you chose in your warehouse.
:::

## Configuration fields

What the connection form asks for. Required fields are marked; the rest are optional.

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| **Credentials** | one of 2 options | No | Credentials for the service. |
| **Dynamodb Endpoint** | string | No | The URL of the Dynamodb database. |
| **Ignore missing read permissions tables** | boolean | No | Ignore tables with missing scan/read permissions. Default `false`. |
| **Dynamodb Region** | string | No | The region of the Dynamodb database. One of ``, `af-south-1`, `ap-east-1`, `ap-northeast-1`, `ap-northeast-2`, `ap-northeast-3`, `ap-south-1`, `ap-south-2`, `ap-southeast-1`, `ap-southeast-2`, `ap-southeast-3`, `ap-southeast-4`, `ca-central-1`, `ca-west-1`, `cn-north-1`, `cn-northwest-1`, `eu-central-1`, `eu-central-2`, `eu-north-1`, `eu-south-1`, `eu-south-2`, `eu-west-1`, `eu-west-2`, `eu-west-3`, `il-central-1`, `me-central-1`, `me-south-1`, `sa-east-1`, `us-east-1`, `us-east-2`, `us-gov-east-1`, `us-gov-west-1`, `us-west-1`, `us-west-2`. |
| **Reserved attribute names** | string, secret | No | Comma separated reserved attribute names present in your tables. |

### Credentials

Credentials for the service.

Choose one of the following. Each asks for its own fields.

**Authenticate via Access Keys**

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| **Dynamodb Key Id** | string, secret | Yes | The access key id to access Dynamodb. becca requires read permissions to the database. |
| **Dynamodb Access Key** | string, secret | Yes | The corresponding secret to the access key id. |

**Role Based Authentication**

No further fields.


## Related

:::links
- [Sync modes](https://docs.sanda-os.com.au/connections/sync-modes): How sanda reads each table on every run.
- [Sync schedules](https://docs.sanda-os.com.au/connections/schedules): How often a connection runs.
- [Allowlist sanda’s address](https://docs.sanda-os.com.au/connections/allowlist): For a system behind a firewall.
- [Troubleshoot connections](https://docs.sanda-os.com.au/connections/troubleshooting): What an error means and how to fix it.
:::