MySQL Snap Pack

Overview

Use the MySQL Snap Pack to connect to your MySQL database or MySQL-compatible database (like Aurora and MariaDB) and achieve read and write access to its objects.

Use Snaps in this Snap Pack to:

  • Get list of tables in a database.
  • Lookup records in the target table and return a selected set of fields.
  • Fetch data from a database.
  • Execute SQL statements to delete, update, merge or insert data within a specified table.

Supported Versions

  • This Snap Pack is tested against:
    • MySQL 8.0.17
    • Amazon Aurora 1.17.2
    • Azure SQL DB 5.6 and 5.7
  • MySQL Bulk Load Snap supports the following versions:
    • MySQL 8.0.17
    • MySQL 5.6.34

Known Issues

When MySQL execute Snaps (MySQL Execute and MySQL Multi Execute) are followed by MySQL non-execute Snaps, such as MySQL Insert, MySQL Merge, and so on, the following error is displayed when executed:

Table definition has changed, please retry transaction.

This happens due to a known issue in the MySQL Connector. For more information about this issue, see MySQL Bug #65378.