Skip to main content

​
Configuration Parameters

To use Doris as a destination in Mage, provide the following parameters:

​
Optional Settings

​
Notes

  • SSH tunneling is useful for secure access to Doris behind firewalls or private networks.
  • conn_kwargs is especially helpful if you need to enable SSL or set advanced connection options.
  • Doris uses a MySQL-compatible protocol, so many standard MySQL configurations also apply.

​
Frequently Asked Questions

​
Can I connect to Doris using an SSH tunnel?

Yes. Set connection_method to ssh_tunnel and provide the appropriate ssh_host, ssh_username, and either ssh_password or ssh_pkey depending on your authentication method.

​
Can I use a private key for SSH authentication?

Yes. Use the ssh_pkey parameter to provide the file path or content of the SSH private key. This is recommended over using ssh_password.

​
Does Doris support SSL connections?

Yes. Use the conn_kwargs parameter to pass MySQL-compatible SSL options like ssl_ca, ssl_cert, and ssl_key.

​
What happens if I use overwrite mode?

Mage will drop the existing table (if it exists) and recreate it, replacing all existing data. Make sure your downstream systems can handle this reset.

​
What’s the difference between use_lowercase and lower_case?

Both settings control whether column names are converted to lowercase. use_lowercase applies during export, while lower_case can be used to enforce this behavior globally. We recommend keeping them consistent.