Amazon Q DataSource: Amazon RDS MYSQL error

Question

I am trying to add a data source to my AmazonQ application using the Amazon RDS MYSQL connector, but I keep having this error:

Encountered 1 error(s) while processing the data source configuration input against the schema for data source type: JDBC. #/additionalProperties/sqlQuery: subject must not be valid against schema {"pattern":";+"} - ValidationException - 400 Request ID: 04eca206-3d2d-44e9-b21c-c376479bc4bd

I launched a new RDS in the same region and it is publicly available. (I can connect no problem from home) so I don't think there are any connectivity issues. I created 1 schema inside that database and 1 table with my info.
CREATE TABLE `blog` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `blog` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=192009 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

I also populated so data.

My SQL is SELECT * FROM amazonQ.blog;
and I put id/title/blog as the Sync Scope values.

Any idea what could be the issue ?

Thanks!

Simon

Accepted Answer

First verify that you can open mysql database from any client like SQLWorkbranch Because perhaps the user does not have permission to % (All).
Second in Query don't use ( ; ):
SELECT * FROM amazonQ.blog

Amazon Q DataSource: Amazon RDS MYSQL error

Contenuto pertinente