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/my-user-name'
- Account: !Ref AWS::AccountId
QSDataSet:
DependsOn: QuickSightDataSource
Type: AWS::QuickSight::DataSet
Properties:
AwsAccountId: !Ref 'AWS::AccountId'
DataSetId: 'QSDataSet-test'
ImportMode: SPICE
Name: Dataset-test
Permissions:
- Actions:
- 'quicksight:CreateDataSet'
- 'quicksight:DeleteDataSet'
- 'quicksight:DescribeDataSet'
- 'quicksight:DescribeDataSetPermissions'
- 'quicksight:PassDataSet'
- 'quicksight:UpdateDataSet'
- 'quicksight:UpdateDataSetPermissions'
Principal: !Sub
- 'arn:aws:quicksight:us-east-1:${AWS::AccountId}:user/default/my-user-name'
- Account: !Ref 'AWS::AccountId'
PhysicalTableMap:
downtime_data_json:
DataSourceArn: !GetAtt QuickSightDataSource.Arn
InputColumns:
- Name: downtime
Type: INTEGER
Schema: XXX???
I have data source & data tables in Athena and want to refer that in above template. I am not finding DatasourceArn, the above template throwing error as Model validation failed (#: extraneous key [DataSourceArn] is not permitted)". can anyone please help me out to hash out this.