Database configuration requirements for self-administered instances - Amazon QuickSight
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Database configuration requirements for self-administered instances

   Intended audience: System administrators and Amazon QuickSight administrators 

For a database to be accessible to QuickSight, it must meet the following criteria:

  • It must be accessible from the internet. To enable internet connectivity, see your database management system documentation.

  • It must be configured to accept connections and authenticate access using the user credentials that you provide as part of creating the data set.

  • If you are connecting to MySQL or PostgreSQL, the database engine must be accessible from your host or IP range. This optional security limitation is specified in MySQL or PostgreSQL connection settings. If this limitation is in place, any attempt to connect from a nonspecified host or IP address is rejected, even if you have the correct username and password.

  • In MySQL, the server accepts the connection only if the user and host are verified in the user table. For more information, see Access Control, Stage 1: Connection Verification in the MySQL documentation.

  • In PostgreSQL, you control client authentication by using the pg_hba.conf file in the database cluster's data directory. However, this file might be named and located differently on your system. For more information, see Client Authentication in the PostgreSQL documentation.