Amazon QuickSight
User Guide

Required Permissions for Database Credentials

To connect to a database, you must provide a user name and password. The user account identified by these credentials must have SELECT permissions on some system tables in order to allow Amazon QuickSight to do things like discover table schemas and estimate table size.

The following table identifies the tables that the user account must have SELECT permissions on, depending on the type of database you are connecting to. These requirements apply for all database instances you connect to, regardless of their environment—that is, whether they are on-premises, in Amazon RDS, in Amazon EC2, or elsewhere.

Instance Type Tables

Amazon Aurora

  • INFORMATION_SCHEMA.STATISTICS

  • INFORMATION_SCHEMA.TABLES

Amazon Redshift

  • pg_stats

  • pg_class

  • pg_namespace

MariaDB

  • INFORMATION_SCHEMA.STATISTICS

  • INFORMATION_SCHEMA.TABLES

Microsoft SQL Server

  • DBCC SHOW_STATISTICS

  • sp_statistics

MySQL

  • INFORMATION_SCHEMA.STATISTICS

  • INFORMATION_SCHEMA.TABLES

PostgreSQL

  • pg_stats

  • pg_class

  • pg_namespace

Note

If you are using MySQL or PostgreSQL, verify that you are connecting from an allowed host or IP address. For more detail, see Database Configuration Requirements for Self-Administered Instances.