ETL from MySQL to SQL2019 using Amazon Glue

• LightShip

  SSC-Addicted

  Points: 421

  More actions

  September 23, 2022 at 4:04 pm

  #4091271

  I've a project to move data from MySQL to SQL Server on AWS using Amazon Glue, and was wondering has anyone good learning material on Glue, there is a lot of stuff on youtube but if anyone has a good recommendation that would be great before I disappear down the rabbit hole.

  If not, I'll report back here if I stumble on something particularly good.

  thanks and have a good weekend

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  September 24, 2022 at 4:10 pm

  #4091564

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• LightShip

  SSC-Addicted

  Points: 421

  More actions

  September 26, 2022 at 11:54 am

  #4091985

  in case anyone hits this issue down the road, I found this article very useful.

  https://ruslanmv.com/blog/How-to-connect-MySQL-Server-with-AWS-Glue

   

• Jeff Moden

  SSC Guru

  Points: 1004589

  More actions

  September 27, 2022 at 12:40 am

  #4092235

  LightShip wrote:

  in case anyone hits this issue down the road, I found this article very useful.

  https://ruslanmv.com/blog/How-to-connect-MySQL-Server-with-AWS-Glue

  Nice link.  Thanks for posting it.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)