MySQL

The MySQL adapter is a data platform adapter that can be installed and used with blackline-core, a powerful data modeling and transformation tool. With the MySQL adapter, you can easily connect to MySQL databases and run SQL commands to transform data. The adapter supports multiple profiles for managing different environments, and you can customize the adapter configuration to suit your specific needs.

Example Config

mysql_dataset.yaml

profiles:
  dev:
    type: mysql
    config:
      connection:
        user: { mysql_user }
        password: { mysql_password }
        host: { mysql_host }
        port: { mysql_port }
        database: { mysql_db }

Additional value pairs can be included in the connection dictionary and will be passed to the mysql.connect method.

See the MySQLConnectionConfig and MySQLDataStore models.