📊 QuickSight Trial Information: Corp Data & Analytics Engineers

[williamorrie]

Use Case Description

We are planning to build a POC KPI dashboard to show value gained from Athena usage by linking Athena and SOP datasets. This is related to #6170 . The following users will require access:

• [email protected]
• [email protected]
• [email protected]
• [email protected]
• [email protected]
• [email protected]
• [email protected]

Dataset(s) to Visualise

• analytical_platform_value_derived
• analytical_platform_value_derived_dev_dbt
• athena_query_executions
• sop_derived
• sop_remuneration

Are you an Analytical Platform Admin of the S3 Data Warehouse for the Datasource(s)?

No

Audience Details

• Other AP Users
• Senior management

Additional Information

No response

[moj-supratikc]

Two additional databases to add to the three above:

• analytical_platform_value_derived
• analytcial_platform_value_derived_dev_dbt

Just wanted to make sure these aren't going to cause any problems with linking up Quicksight as:

• The first one doesn't exist yet (it's to be created during the Firebreak). Assuming the database needs to exist first! If that's true then I can do a dbt prod run over the weekend to create some dummy tables in the db.
• The second one, as a dev_dbt table, gets deleted every week or so I think. We can recreate it only the fly, but will Quicksight have an issue if a database suddenly drops?

[moj-supratikc]

Can I also confirm where we actually access Quicksight from now? The URL used during the trial is no longer working.

[moj-supratikc]

I have used the same Azure EntraID group that was set up during the trial - azure-aws-sso-qs-dmet. This is the group that should be given Quicksight access to the databases above.

Just to confirm we have three owners:
[email protected]
[email protected]
[email protected]

and four members:
[email protected]
[email protected]
[email protected]
[email protected]