QuickSight doesn't show existing DataSource

Question & Answer
,
1

Hi there,

We created a QuickSight DataSource with AWS CloudFormation Template by using DataSource template. I can see the existing data source from aws quicksight cli but the QuickSight UI doesn’t display it.

Here is the existing data source that I am able to see from the aws quicksight list-data-sources cli command output

        {
            "Arn": "arn:aws:quicksight:us-east-1:494882029813:datasource/redshift-data-source-QuickSight",
            "DataSourceId": "redshift-data-source-",
            "Name": "redshift-data-source-QuickSight",
            "Type": "REDSHIFT",
            "Status": "CREATION_SUCCESSFUL",
            "CreatedTime": "2023-11-22T00:30:42.472000+03:00",
            "LastUpdatedTime": "2023-11-22T00:30:42.952000+03:00",
            "DataSourceParameters": {
                "RedshiftParameters": {
                    "Host": "awesome-cluster.us-east-1.redshift.amazonaws.com",
                    "Port": 5439,
                    "Database": "default_db",
                    "ClusterId": "awesome-cluster"
                }
            },
            "VpcConnectionProperties": {
                "VpcConnectionArn": "arn:aws:quicksight:us-east-1:******:vpcConnection/quicksight-vpc-conn"
            },
            "SslProperties": {
                "DisableSsl": false
            }
        }

However, the same data source is not showing up from the UI.

Screen Shot 2024-04-19 at 19.15.09
Screen Shot 2024-04-19 at 19.15.092509×870 167 KB

Any help is appreciated. Thanks

2

Hi @buraktas - Welcome to AWS QuickSight community and thanks for posting the question. For your data source issue, can you please update the permission from aws cli.
You can use the below command, provide the require details correctly. After update the permission, please check in the UI.

 aws quicksight update-data-source-permissions --aws-account-id <<account id>> --data-source-id <<data source id>> --grant-permissions Principal="<<arn of the user>>",Actions=quicksight:DescribeDataSource,quicksight:DescribeDataSourcePermissions,quicksight:PassDataSource --region <<region name>>

Regards - Sanjeeb

1 Like
3

Thanks a lot @Sanjeeb2022! I created a new QuickSight Group and updating the DataSource permission worked by passing its Arn.

1 Like