Ao usar o AWS re:Post, você concorda com os AWS re:Post Termos de uso
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?

Tópicos
Banco de dadosAnálise
Tags
Banco de dadosAWS GlueExtrair, transformar e carregar dados
Idioma
English
DanielRem
feita há 2 anos2928 visualizações
1 Resposta
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
respondido há 2 anos
AWS
ESPECIALISTA
Fabrizio@AWS
avaliado há 2 anos
  • DanielRem
    há 2 anos

    In the Legacy Jobs I was able to select 'create tables in your data target' and pick my data store, connection and database name, shown here: https://www.sqlshack.com/how-to-connect-aws-rds-sql-server-with-aws-glue/

    Can you explain how this be accomplished using new Jobs module with the Visual option, especially for the case when the target db is new and it doesnt have any tables.

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas

Conteúdo relevante