0

I have a MySQL RDS database that holds configuration/dimension tables. I also have transaction data streaming into Snowflake. I want the MySQL tables to be synced in Snowflake so that they are available in Snowflake because I will be writing a compute job that will join the config/dimension tables with the transactional data in Snowflake. What is the best way to sync the tables from MySQL to Snowflake at a certain frequency?

Maarab
  • 143
  • 1
  • 14

2 Answers2

2

In order to replicate MySQL tables towards Snowflake, you could use one of the following:

  • Fivetran (cloud-native for on-premise and cloud database replication)
  • Debezium (open-source distributed platform for change data capture)
Francesco Quaratino
  • 550
  • 2
  • 9
0

Disclaimer: I'm part of the team working on the solution suggested below

In addition to the solutions that were already mentioned, you can also create a data application using Turbine to sync your tables from MySQL to SnowflakeDB in real-time.

Depending on your current tech stack and the language you feel most comfortable developing in, you can create an application using any of the following libraries:

Jessy Jordan
  • 1