Error while loading Snowflake tables into Quicksight

Question & Answer
2

Hi @likhitha,
The Snowflake user that is being used for QuickSight should have access to the relevant warehouse, database, Schema, and tables. You should only need SELECT permissions. See the sample code below for reference on how to grant those permissions.

GRANT USAGE ON WAREHOUSE YOUR_WH TO ROLE REPORTING;

GRANT USAGE ON DATABASE YOUR_DB TO ROLE REPORTING;

GRANT USAGE ON SCHEMA YOUR_DB.PUBLIC TO ROLE REPORTING;

GRANT SELECT ON ALL TABLES IN SCHEMA YOUR_DB.PUBLIC TO ROLE REPORTING;
GRANT SELECT ON FUTURE TABLES IN SCHEMA YOUR_DB.PUBLIC TO ROLE REPORTING;

GRANT SELECT ON ALL VIEWS IN SCHEMA YOUR_DB.PUBLIC TO ROLE REPORTING;
GRANT SELECT ON FUTURE VIEWS IN SCHEMA YOUR_DB.PUBLIC TO ROLE REPORTING;

GRANT ROLE REPORTING TO USER QUICKSIGHT;
3 Likes