/
MySQL Snap Pack

MySQL Snap Pack

In this article

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.

Snap Pack History





Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2025 SnapLogic, Inc.