Required Permissions for Database Credentials - Amazon QuickSight

Required Permissions for Database Credentials

 Applies to: Enterprise Edition and Standard Edition 

 Intended audience: System administrators 

When you connect to a database that requires a user name, the user name must have SELECT permissions on some system tables 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 for, depending on the type of database you are connecting to. These requirements apply for all database instances you connect to, regardless of their environment. In other words, they apply whether your database instances 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.