Snowflake Connector for MySQL installation and configuration tasks¶
Important
Thank you for your interest in the Snowflake Connector for MySQL. We’re now focused on a next-generation solution that will offer a significantly improved experience; therefore, moving this connector to the general availability status is currently not on our product roadmap. You may continue to use this connector as preview feature, but please note that support for future bug fixes and improvements are not guaranteed. The new solution is available as Openflow Connector for MySQL and includes better performance, customizability, and enhanced deployment options.
Working with the Snowflake Connector for MySQL involves several key tasks:
- Installation and configuration of the connector
- Configuring data replication and examining the ingested data
It’s important to carefully review each of the installation and configuration steps, before enabling data replication.
Installation and configuration of the connector¶
These steps are designed to guide you through the initial setup of the Connector. The installation process involves various stages and contributions from different departments.
| Task | Description | Area Involved |
|---|---|---|
| Prerequisites for Snowflake Connector for MySQL datasources | The configuration of the source database instance to enable data replication. | Source Database Administrator |
| Setting up the Snowflake Connector for MySQL using Snowsight | Installation of the Connector using Snowsight. | Snowflake Administrator |
| Set up connectivity | The configuration of the network access to Snowflake. A sub-task of Setting up the Snowflake Connector for MySQL Agent container. | Network Administrator |
| Setting up the Snowflake Connector for MySQL Agent container | Installation and configuring the Snowflake Connector for MySQL agent. | Developer and Operations |
| Setting up Email Notifications for the MySQL connector | The configuration of email notifications for the connector. | Snowflake Administrator |
| Configuring replication for the Snowflake Connector for MySQL | Configure connector replication | Developer and Operations |
Configuring data replication and examining the ingested data¶
This installation step enables you to configure the data source and activate table replication.
| Task | Description |
|---|---|
| Configuring replication for the Snowflake Connector for MySQL | Configure connector replication |
| Viewing MySQL data in Snowflake | Viewing data ingested using the connector. |