By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

AWS Glue - setting data target for RDS mysql

0

I've started using Glue and I'm having trouble understanding how the data targets work. Using visual method to create a new Job I selected target to be MySQL (that is where I want the data to be saved). In the next tab, Data target properties, I can only select the Database from the Glue's data catalog and not from the target db. Are there any pre-requisites I need to complete before I can save the table in AWS RDS mysql?

Topics
DatabaseAnalytics
Tags
DatabaseAWS GlueExtract Transform & Load Data
Language
English
DanielRem
asked 2 years ago2871 views
1 Answer
0

AWS Glue studio has the following three options for target properties. It can write to,

  • S3
  • AWS Glue Data Catalog
  • A connector

In this case, you might want to catalog the target database in the Glue data catalog before trying to read it from the data target properties. This means crawling the target database, and storing the metadata in Glue's data catalog, by which way we can map this information to the AWS RDS MySQL target.

AWS
SivaramanRadharaman
answered 2 years ago
AWS
EXPERT
Fabrizio@AWS
reviewed 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content