Quick Sight datasource error

Question

QSDataSource:
    Type: AWS::QuickSight::DataSource
    Properties:
      AwsAccountId: !Ref 'AWS::AccountId'
      DataSourceId: '????'
      Name: '????'
      SslProperties:
        DisableSsl: false
      Type: ATHENA

Hello,

I am trying to create datasource in quicksight as Athena resource type, but not able to understand what to mention at 'DataSourceId' and 'Name'.

If anyone can provide Sample/Example template would be helpful.

samsonlee · Answer

"DataSourceId" is used for identifying the data source within your AWS account so it should be unique. See resource-id described in  [Amazon Resource Names (ARNs) documentation](https://docs.aws.amazon.com/general/latest/gr/aws-arns-and-namespaces.html) for the relevant concept.

"Name" refers to the display name of the data source that can be any string.

Below is an example of CloudFormation template creating the QuickSight data source:

```
---
AWSTemplateFormatVersion: '2010-09-09'
Description: 'Creating QuickSight data source'

Resources:
  QuickSightDataSource:
    Type: AWS::QuickSight::DataSource
    Properties:
      AwsAccountId: !Ref AWS::AccountId
      Name: Testing Data Source
      Type: ATHENA
      DataSourceId: testing-data-source
      DataSourceParameters:
        AthenaParameters:
          Workgroup: primary
      Permissions:
      - Actions:
          - quicksight:DescribeDataSource
          - quicksight:DescribeDataSourcePermissions
          - quicksight:PassDataSource
        Principal: !Sub
        - 'arn:aws:quicksight:us-east-1:${Account}:user/default/your-user-name'
        - Account: !Ref AWS::AccountId
```

Quick Sight datasource error

Relevant content