Can I use access list data as dashboard input and refresh the data dynamically?

Q&A
, ,
1

I want to create a dashboard that shows volume of users registered to an access list. I don’t want to publish any sensitive data, rather just read the count of members in the list on a cadenced basis and put that in a dashboard for tracking.

2

Hi @najahah welcome to the Community!

I see two ways of doing what you need:

  • Importing/connecting to the source you need and creating a count using Quick Sight visuals (as you would do in any other case), and then just grant the permissions so that no one can see the original data you’re connected to (or that you have imported).
  • The other way, supposing you’re connecting to a DB, is that you can launch directly a query from Quick Sight, so that you will just import the single number, and not all the data.
    • Create a DataSource with the connections values needed to connect to your DB
    • Create, starting from that DataSource, a custom query DataSet
    • Just add your query like “Select count(*) From your-table…”. In this way your dataset will just have one column and a single value.

Hope this helps!

Andrea

3

Hi @najahah,

Following up here as it’s been awhile since last communication took place on this thread; did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @najahah,

Since we have not heard back any further, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you