Configuration

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

KeyDescriptionSample Value
databaseName of the database you want to read data from.demo
hostHostname of your MySQL server.mage.abc.us-west-2.rds.amazonaws.com
portPort on which the database is running (typically 3306).3306
usernameUsername with permissions to read and write to the specified schema.root
passwordPassword for the user to access the database.abc123...
connection_methodMethod used to connect to MySQL server, either direct or ssh_tunnel.direct or ssh_tunnel
conn_kwargs(Optional) Extra connection keyword arguments 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 for bastion authentication (if using password).password
ssh_pkey(Optional) Path to the private key file for bastion authentication (if using a private key)./path/to/private/key

Optional Configuration

KeyDescriptionSample Value
batch_fetch_limitNumber of rows to fetch per batch (defaults to 50,000). Adjust higher if your instance has more memory.50000