> ## Documentation Index
> Fetch the complete documentation index at: https://artie.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# DocumentDB

> Learn how to use Artie to replicate data from DocumentDB via change streams.

<Note>
  To run Artie with DocumentDB, you **must** have [SSH tunnels](/connection-options/ssh-tunnel) enabled or use BYOC with VPC peering as DocumentDB only allows access within your VPC.
</Note>

## Required settings

* Cluster endpoint
* Port (default is `27017`)
* Service account
* Database name (ensure the database has change stream enabled)

<Accordion title="Need help finding the cluster endpoint?">
  You can find the cluster endpoint by going to the AWS console, selecting the DocumentDB cluster and go to the "Configuration" tab.

  <img src="https://mintcdn.com/artie/cR74rDu7gj_LCvTI/assets/documentdb.png?fit=max&auto=format&n=cR74rDu7gj_LCvTI&q=85&s=ceec29b84e9938f9388eafb871dd04c2" alt="DocumentDB cluster endpoint" width="371" height="452" data-path="assets/documentdb.png" />
</Accordion>

## Setting up change streams and a service account

```javascript setup.js theme={null}
// Creating a service account for Artie to subscribe to change stream
db.createUser({user: "artie", pwd: "changeme", roles: ["read"]});
// Grants access to DocumentDB change streams
use admin;
db.grantRolesToUser("artie", [
  { role: "readAnyDatabase", db: "admin" }
]);

// Depending on the permission granularity you want, 
// you can use the following commands to grant permissions to the service account.
// Enable change streams for all collections in database "changeme"
db.adminCommand({
    modifyChangeStreams: 1,
    database: "changeme",
    collection: "",
    enable: true
});

// Enable change streams for all collections in all databases
db.adminCommand({
    modifyChangeStreams: 1,
    database: "",
    collection: "",
    enable: true
});

// Optional - Enable change streams for the collection "foo" in database "changeme"
db.adminCommand({
    modifyChangeStreams: 1,
    database: "changeme",
    collection: "foo",
    enable: true
});
```

## Advanced

<Accordion title="Cast all columns to string">
  DocumentDB collections have no enforced schema, so different documents can store the same field with different types. By default, Artie infers the column type from the first non-null value it sees. If a later document stores that field with a different type, Artie lands the column as a string.

  The **Cast all columns to string** setting makes this explicit: every column is stored as a string as it is discovered, regardless of the underlying BSON type. Nested objects are stored as JSON strings.

  This setting applies to new columns as they are discovered. Existing destination columns keep their current types. To cast all columns as strings on a pipeline with an existing destination table, rebuild the table after enabling this setting.

  You can enable this from your pipeline's destination advanced settings.
</Accordion>