Menu
Amazon QuickSight
User Guide

Required Permissions for Database Credentials

You must provide a user name and password for a database in order to connect to it. 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 (whether they are on-premise, in Amazon RDS, in Amazon EC2, etc.).

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 PostreSQL, verify that you are connecting from an allowed host or IP address. See Database Configuration Requirements for Self-Administered Instances for more detail.