If a company did a snowflake data share to my customer and we connect QuickSight to that share, are there restrictions?
We can create the data source, and do custom sql select queries if we pull small amounts of data 10-60 rows (LIMIT 10). If we click the visualize button or the edit/preview data the query makes it to the snowflake log but the import times out.
There is a long story behind all of this - so this is a narrow question on purpose.
From what we can tell permissions are good enough but we are baffled why the larger row full queries or button pushing doesn’t bring the data.
I’m reading up on snowflake data shares now.
When the customer granted the connecting user permissions all grants succeeded except those with future in it.
Here are the grants, bold are ones that failed and at the moment I don’t have an error message.
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;