Amazon Q with MySQL database issue

Hi Fady,

Please check the step by step process of connecting Amazon Q Business to MySQL using the console - https://docs.aws.amazon.com/amazonq/latest/qbusiness-ug/my-sql-console.html

The title column and body column in the Amazon Q and MySQL connector refer to the column mappings when syncing data from a MySQL database to Amazon Q.

When the MySQL connector crawls the database, each row is treated as a single searchable document in Amazon Q. The title column specifies which database column should be used as the title or name of the document. Similarly, the body column specifies which column contains the main text content of the document.

Additional column mappings can also be configured, such as columns for user permissions, timestamps, and metadata fields. By default, the primary key column of each database row is used as the document ID in Amazon Q.

The AWS documentation provides more details on all the configuration options for the MySQL connector and how to connect your database.

Useful links:

[1] MySQL connector overview - Amazon Q Business - https://docs.aws.amazon.com/amazonq/latest/qbusiness-ug/my-sql-overview.html

[2] Connecting MySQL to Amazon Q Business - Amazon Q Business - https://docs.aws.amazon.com/amazonq/latest/qbusiness-ug/my-sql-connector.html

Hope it helps