Connecting PostgreSQL to Amazon Q Business
PostgreSQL is an open source database management system. You can connect your PostgreSQL instance to Amazon Q Business—using either the AWS Management Console, CLI, or the CreateDataSource API—and create an Amazon Q web experience.
The Amazon Q PostgreSQL data source connector supports PostgreSQL 9.6.
Important
As a best practice, provide Amazon Q with read-only database credentials. Also, avoid adding tables with sensitive data or personal identifiable information (PII).
Topics
- Known limitations for the PostgreSQL connector
- PostgreSQL connector overview
- Prerequisites for connecting Amazon Q Business to PostgreSQL
- Connecting Amazon Q Business to PostgreSQL using the console
- Connecting Amazon Q Business to PostgreSQL using APIs
- How Amazon Q Business connector crawls PostgreSQL ACLs
- PostgreSQL data source connector field mappings
- IAM role for PostgreSQL connector
Learn more
-
For an overview of the Amazon Q web experience creation process using IAM Identity Center, see Configuring an application using IAM Identity Center.
-
For an overview of the Amazon Q web experience creation process using AWS Identity and Access Management, see Configuring an application using IAM.
-
For an overview of connector features, see Data source connector concepts.
-
For information about connector configuration best practices, see Connector configuration best practices.
Known limitations for the PostgreSQL connector
-
Deleted database rows will not be tracked in when Amazon Q checks for updated content.
-
The size of field names and values in a row of your database can't exceed 400KB.
-
If you have a large amount of data in your database data source, and do not want Amazon Q to index all your database content after the first sync, you can choose to sync only new, modified, or deleted documents.
