QuickSight data source creation via Cloudformation failing with "Bucket name should not contain uppercase characters".
graham-tibbitts
asked 2 years ago

Question

I'm attempting to create a QuickSight data source via Cloudformation. When I deploy the following, it fails with the message `"Resource of type 'AWS::QuickSight::DataSource' with identifier 'ds1' was not found."`. The other resource create correctly. Any idea what's going wrong?

```typescript
        this.athenaOutputBucket = new Bucket(this, "AthenaOutputBucket", {
            removalPolicy: RemovalPolicy.DESTROY,
            enforceSSL: true,
            versioned: false,
            publicReadAccess: false,
        })

this.athenaWorkGroup = new CfnWorkGroup(this, "AthenaWorkGroup", {
            name: "my-athena-workgroup",
            recursiveDeleteOption: true,
            state: "ENABLED",
            workGroupConfiguration: {
                enforceWorkGroupConfiguration: true,
                resultConfiguration: {
                    outputLocation: `s3://${this.athenaOutputBucket}/`,
                },
            },
        });

this.quickSightDatasource = new CfnDataSource(this, "QuickSightDataSource", {
            name: "my-transactions-datasource",
            type: "ATHENA",
            dataSourceId: "ds1",
            dataSourceParameters: {
                athenaParameters: {
                    workGroup: this.athenaWorkGroup.name,
                },
            },
            awsAccountId: stageConfig.env.account,
            permissions: [{
              actions: [
                "quicksight:DescribeDataSource",
                "quicksight:DescribeDataSourcePermissions",
                "quicksight:PassDataSource" ],
              principal: `arn:aws:quicksight:${stageConfig.env.region}:${stageConfig.env.account}:user/default/your-user-name`
            }]
        })
    }
```

re:Post Agent · Accepted Answer

The error you're encountering suggests that CloudFormation is unable to find the QuickSight data source after attempting to create it. This could be due to a few reasons:

1. Permissions: Ensure that the IAM role executing the CloudFormation template has the necessary permissions to create and manage QuickSight resources. The role should have appropriate QuickSight permissions, including the ability to create data sources.

2. QuickSight subscription: Verify that you have an active QuickSight subscription in the AWS account and region where you're deploying the stack. Without an active subscription, QuickSight resources cannot be created.

3. Resource naming: The `dataSourceId` you've specified ("ds1") might not be unique or could be conflicting with an existing resource. Try using a more unique identifier or allowing CloudFormation to generate one automatically.

4. Dependencies: Make sure that the Athena workgroup is fully created before the QuickSight data source tries to reference it. You might need to add a dependency to ensure the correct order of resource creation.

5. Region compatibility: Confirm that QuickSight is available and supports Athena integration in the region where you're deploying.

To troubleshoot:

1. Double-check your IAM permissions and QuickSight subscription status.
2. Try removing the `dataSourceId` property to let CloudFormation generate a unique ID.
3. Add an explicit dependency between the QuickSight data source and the Athena workgroup.
4. Review CloudFormation logs and QuickSight console for any additional error messages.

If the issue persists, you may want to try creating the QuickSight data source manually through the AWS console to see if you encounter any specific errors that could provide more insight into the problem.  
**Sources**  
[CreateDataSource - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/developerguide/create-data-source.html)  
[Creating a data source - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/create-a-data-source.html)  
[DataSource - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/APIReference/API_DataSource.html)  
[AssetBundleExportJobDataSourceOverrideProperties - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/APIReference/API_AssetBundleExportJobDataSourceOverrideProperties.html)

QuickSight data source creation via CloudFormation fails with "Resource of type 'AWS::QuickSight::DataSource' with identifier 'ds1' was not found."

Add your answer

Relevant content