Frequently Asked Questions
How do I know if I should be able to see a particular table/database/domain in QuickSight?
Databases and Tables should be available via the Athena
data source in QuickSight provided that:
- your Analytical Platform
alpha_user
has access to the data via the data-engineering-database-access GitHub repository - the data is within one of the
mojap-derived-table
domains in Create a Derived Table
Can I share the dashboards that I create?
See Sharing dashboards for information on sharing published dashboards.
Be aware that users who have access to the dashboard can also see the data used in the associated analysis.
I’m already a user of another version of QuickSight on the AP, what should I do if:
I can do all of my work on the new QuickSight (all of my tables are create-a-derived-table tables)
It is possible to export dashboards from other instances of QuickSight using Asset Bundle export. If your previous dashboard is sufficiently complex that recreation in this QuickSight would be a significant issue, raise a support request and the Analytical Platform team may be able to help you migrate the dashboard.
I can’t do all of my work on the new QuickSight (some / all of my tables are outside create-a-derived-table)
We will keep you updated as new data becomes available to QuickSight via the Control Panel.
When should I use SPICE?
Importing a dataset into SPICE imports the data into memory, rather than querying the data where it lives in S3. Whether to use SPICE or directly query the data is a judgement call, and will likely come down to:
- how complex the analysis is
- the size, format and structure of the underlying data
- how likely users are to drill down into the dashboards
- user tolerance for load times while making changes to dashboards
What should I do if I encounter an error while using QuickSight?
Check the Troubleshooting guide, and raise a support request if you’re unable to resolve your issue there.