Prerequisites for Snowflake Connector for MySQL datasources¶

Configure associated datasource¶

• Ensure that you have a MySQL version 8 or higher server that includes data you want to synchronize with Snowflake.

• Set the following options for your MySQL server:

  log_bin = on
  binlog_format = row
  binlog_row_metadata = full
  binlog_row_image = full
  binlog_row_value_options =
  

  Copy

  Note

  Be cautious about the binary log expiration period (binlog_expire_logs_seconds). After it ends, binary log files might be automatically removed. If the agent is paused for a long period of time (for example due to maintenance work) and the expired binary log files are deleted during this time, the agent is not able to replicate the data from these files. Set the binary log expiration period to at least a few hours to ensure stable work of the connector.

  For more information about the automatic purging of binary log files, see MySQL Reference Manual (https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html).

Create required user¶

Create a user for the Snowflake Connector for MySQL with the following permissions:

• REPLICATION SLAVE and REPLICATION CLIENT to be able to read from binlog.

  For example:

  GRANT REPLICATION SLAVE ON *.* TO '<username>'@'%'
  GRANT REPLICATION CLIENT ON *.* TO '<username>'@'%'
  

  Copy

• SELECT permission to all tables that are replicated.

  For example:

  GRANT SELECT ON <schema>.* TO '<username>'@'%'
  GRANT SELECT ON <schema>.<table> TO '<username>'@'%'
  

  Copy

  Where <schema>.<table> is the unique identifier of a table to be replicated.

Next steps¶

After completing these procedures, follow the steps in Setting up the Snowflake Connector for MySQL using Snowsight.