MySQL

The MySQL driver depends on pymysql and can be installed with:

pip install "sayn[mysql]"

SAYN will consider the following parameters to construct the sqlalchemy url:

Parameter	Description	Default
host	Host name or public IP of the server	Required
port	Connection port	3306
user	User name used to connect	Required
password	Password for that user	Required
database	Database in use upon connection	Required

Other parameters specified will be passed on to sqlalchemy.create_engine when creating the engine.

settings.yaml

credentials:
  mysql-conn:
    type: mysql
    host: warehouse.company.com
    port: 3306
    user: mysql_user
    password: 'Pas$w0rd' #use quotes to avoid conflict with special characters
    database: models

Check the sqlalchemy mysql-connector dialect for extra parameters.