Error while loading Snowflake tables into Quicksight

After the successful validation (connection type: Public network), I tried to load Snowflake tables into Quicksight and ended up with error " This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors". What type of role should be given to QS user in Snowflake to fix this error?

I’d appreciate feedback. Thanks

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;
1 Like