MySQL

Learn the steps for ingesting your MySQL data into your target.

Steps

Enable CDC for your source MySQL database.
Create a connection to your source MySQL database.
Create a connection to your target (see the Supported Targets list below for links).
Create the entities for your target per the list in the Job Type & Steps column below. Note that there are multiple options for ingesting to Snowflake:

Job Type & Steps	Supported Targets
Ingestion Job Create a staging table in the data lake Create an ingestion job to load data into the staging table Create a transformation job for each target	Amazon Redshift Amazon S3 AWS Glue Data Catalog ClickHouse Elasticsearch PostgreSQL Snowflake Tabular
Replication Job Create a replication job to ingest into multiple Snowflake schemas	Snowflake
Single Entity Job Create a staging table in the data lake Create an ingestion job to load data into the staging table Create a parent job that auto-creates a sub-job for each source table to copy data to the target table	Snowflake

Job Type & Steps

Supported Targets

Ingestion Job

Create a staging table in the data lake
Create an ingestion job to load data into the staging table
Create a transformation job for each target

Replication Job

Create a replication job to ingest into multiple Snowflake schemas

Snowflake

Single Entity Job

Create a staging table in the data lake
Create an ingestion job to load data into the staging table
Create a parent job that auto-creates a sub-job for each source table to copy data to the target table

Snowflake

No-code Wizard

Alternatively, you can use the to get your pipelines started in super-quick time. The Wizard generates the code for you so you can optionally customize it for your requirements, and create advanced use cases.

Reference

MySQL

Steps

Quickstarts

How To Guides

Reference

Articles