Creating Amazon Quicksight datasets in code and using them through the console

Question

I'm creating datasources/ datasets in code (boto3) but these don't show up in the console. Even though the datasets are listed with list_data_sets, they don't seem to be available in the console.

I need to be able to create all the necessary datasets in code and then be able to use these to create new analyses/ dashboards in the console.

I'm using the Standard Edition of QuickSight. Can this be done? Or, can it only be done in the Enterprise Edition? Or, not at all?

Thanks

Answer 1

According to the QuickSight pricing page "APIs" are not available in Standard Edition. Exactly what that means, I have no idea.

But, assuming it's possible to call create-data-set, one important thing to remember is that data set permissions are necessary in order for users to view them.

According to the boto docs, these permissions should be included in the following schema

    Permissions=[
        {
            'Principal': 'string',
            'Actions': [
                'string',
            ]
        },
    ]

In my code, I use the following to share with the all-users group (note the group principal, replace AWS_REGION and ACCOUNT_ID with your values)

    Permissions= [
      {
        'Principal': 'arn:aws:quicksight:AWS_REGION:ACCOUNT_ID:group/default/all-users',
        'Actions': [
          'quicksight:DescribeDataSet',
          'quicksight:DescribeDataSetPermissions',
          'quicksight:PassDataSet',
          'quicksight:DescribeIngestion',
          'quicksight:ListIngestions'
        ]
      }
    ],

I believe the same can be done for individual users, with an ARN resource of user/default/user.name instead of group/default/all-users.

For data sources, the set of permissions that I use is

        'Actions': [
          'quicksight:DescribeDataSource',
          'quicksight:DescribeDataSourcePermissions',
          'quicksight:UpdateDataSource',
          'quicksight:UpdateDataSourcePermissions',
          'quicksight:DeleteDataSource',
          'quicksight:PassDataSource'
        ]