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
Thank you, it was the ; in my SQL query!