1 Resposta
- Mais recentes
- Mais votos
- Mais comentários
0
Hello.
Have you set an IAM role for Aurora MySQL?
If you have not set it, please set it by following the steps in the document below.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.LoadFromS3.html#AuroraMySQL.Integrating.LoadFromS3.Authorize
Also, what command did you run?
To read the text, you need to specify the S3 URL as shown below.
LOAD DATA FROM S3 's3://mybucket/data.txt'
INTO TABLE table1
(column1, @var1)
SET table_column2 = @var1/100;
To connect to Aurora MySQL without using "Workbench" you need to use MySQL commands.
You need to run the below command below.
mysql -h "Aurora MySQL Endpoint" -u root -p
Conteúdo relevante
- AWS OFICIALAtualizada há um ano
- AWS OFICIALAtualizada há 2 anos
I did set the IAM role, and use the command with the S3 URL as in the example. Workbench appears to complain about the S3 part of the command, before even reaching the URL.
mysql command works - thank you. It sure would have been nice to be able to run this from the workbench.