# QuickSight (beta)

To connect QuickSight to Select Star, you will need to...

1. [Connect QuickSight to Select Star](#1.-connect-quicksight-to-select-star)
2. [Create an AWS IAM Role ARN using Cloudformation](#2.-create-an-aws-iam-role-arn-using-cloudformation)
3. [Confirm authorization](#3.-confirm-authorization)

{% hint style="info" %}

* Select Star requires only minimal metadata access to AWS QuickSight
* The granted permissions are defined in CloudFormation template
* IAM permission is defined by resource "CrossAccountRolePolicy" in file [SelectStarQuickSight.json](https://github.com/selectstar/cloudformation-templates/blob/main/quicksight/SelectStarQuickSight.json)
  {% endhint %}

### **1**. Connect QuickSight to Select Star

Select QuickSight from the Add Data Source menu and provide the

**Display Name** - This value is `QuickSight` by default, but you can override it if desired.

**Region** - ID of the AWS region where the cluster was created. For example `us-east-2`,`us-west-1`, `eu-central-1`

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-1b0896121aad9b029effc78dbc3fb1066d0de2d1%2Fquicksight-1.png?alt=media)

### 2. **Create** an AWS IAM Role ARN using CloudFormation

Select Star recommends use of AWS CloudFormation to setup integration, which allows you to make necessary changes to the QuickSight environment in an automatic, transparent, safe, and auditable manner.

AWS CloudFormation creates an AWS IAM Role to enable access for Select Star and add it to QuickSight cluster.

The source code of the CloudFormation template along with build scripts and real-time logs of the continuous deployment system is available on public repository on GitHub "[selectstar/cloudformation-templates](https://github.com/selectstar/cloudformation-templates/tree/main/quicksight)" to be freely audited.

You can pass the link to CloudFormation to the infrastructure team to enable the integration to be created.

1\. A simple form will be displayed in Select Star.

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-4fb26372544bacef4b42128068201462270950fd%2Fquicksight-2.png?alt=media)

2\. Select the "Open CloudFormation" button. A new window will open to proceed to the creation of a CloudFormation stack by AWS Management Console. Make sure you are logged into the AWS account in which the QuickSight is hosted.

3\. The **Create Stack** form will be displayed. Fill it in with the required information:

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-d6454428a27b5ed8d064ec9028d2b5a2f4969249%2Fquicksight-3.png?alt=media)

4\. Review the correctness of information in the form. Under **Capabilities** check "I acknowledge that AWS CloudFormation might create IAM resources".

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-e583faffb04765efb8290bf2d85501a60b16f502%2Fquicksight-4.png?alt=media)

5\. Click **Create stack**.

6\. Wait until the stack changes it status to "<mark style="color:green;">CREATE\_COMPLETE</mark>" from "CREATE\_IN\_PROGRESS" in tab "**Stack Info**". The operation should take up to 5 minutes. You need to refresh the tab to see the progress.

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-b74bafcfb1b319c82e26e5a53cc497d81d09068d%2Fquicksight-5.png?alt=media)

7\. After completing stack creation, the `Role ARN` is available from the "**Outputs**". Copy and save the `RoleArn` for later use.

![Outputs tab](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-b5c81e348989f59b54e50cd5bd030c6f48c7dc60%2Fquicksight-6.png?alt=media)

### 3. Confirm authorization

1\. Return to Select Star. You should see a form that allows you to provide "Role ARN". Pay attention to its value, it should not contain any whitespace characters (e.g. tab at the end of the line). Fill out the form with the required information:

* **Role ARN:** Identifier of AWS IAM Role to use by Select Star. You'll see this after completing [step 2.7](#2.-create-an-aws-iam-role-arn-using-cloudformation) of the instructions.

![Enter Role ARN from Step 2.7](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-91f2cfa182eaa42e4611393b8c83ad5337a6b5ff%2Fquicksight-7.png?alt=media)

2\. Click **Save**.

### 3. Connect Activity Data

Activity data is used to calculate popularity and top users. To enable event logs in select star you will need to [setup AWS CloudTrail](https://docs.selectstar.com/integrations/quicksight/event-logs), once complete you should have the following information available:

* **Event Logs Bucket** - The name of the bucket created in the S3.
* **Event Logs Bucket Prefix** - The prefix specified for your CloudTrail logs.

![Connect Activity Data](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-43f4abe9ad38b30562b27415c1ad06438f7c901f%2Fquicksight-8.png?alt=media)

3\. When the sync is complete, you'll be able to explore QuickSight in Select Star.