io_config.yaml
.default
(you can
have multiple profiles, add it under whichever is relevant to you)MYSQL_SSH_HOST
: Hostname or IP of the SSH bastion.MYSQL_SSH_PORT
: SSH port (default 22).MYSQL_SSH_USERNAME
: SSH user to log in as.MYSQL_SSH_PKEY
: Path to private key file (preferred).MYSQL_SSH_PASSWORD
: Password for SSH user (alternative to key).MYSQL_SSH_PKEY
or MYSQL_SSH_PASSWORD
, not both.
SQL
.Data provider
/Connection
dropdown, select Mysql
.Profile
dropdown, select default
(or the profile you added
credentials underneath).Write policy
dropdown, select Replace
or Append
(please see
SQL blocks guide for more information on write policies).SELECT 1
.overwrite_types
dict in data exporter config
Here is an example code snippet: