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

# Doris

## Configuration

To set up the Doris source, provide the following configuration parameters:

| Key | Description | Sample Value |
| - | - | - |
| `database` | The name of the database you want to read data from. | `demo` |
| `host` | Host name of your Doris database. | `mage.abc.us-west-2.rds.amazonaws.com` |
| `port` | Port where the database is running (typically 9030). | `9030` |
| `username` | Username with permissions to read and write to the specified schema. | `root` |
| `password` | Password for the user. | `abc123...` |
| `connection_method` | Connection method to Doris server: `direct` or `ssh_tunnel`. | `direct` or `ssh_tunnel` |
| `conn_kwargs` | (Optional) Extra [connection keyword arguments](https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html) in dictionary format. | `{"ssl_ca": "CARoot.pem", "ssl_cert": "certificate.pem", "ssl_key": "key.pem"}` |
| `ssh_host` | (Optional) Host of the intermediate bastion server. | `123.45.67.89` |
| `ssh_port` | (Optional) Port of the bastion server. Default is 22. | `22` |
| `ssh_username` | (Optional) Username used to connect to the bastion server. | `username` |
| `ssh_password` | (Optional) Password used to connect to the bastion server (if authenticating with password). | `password` |
| `ssh_pkey` | (Optional) Path to the private key used to connect to the bastion server (if authenticating with private key). | `/path/to/private/key` |

<br />

### Optional Configuration

| Key | Description | Sample Value |
| - | - | - |
| `batch_fetch_limit` | Number of rows to fetch in each batch (defaults to 50,000). Adjust higher if your instance has more memory. | `50000` |

<br />


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.