Hi Sanjeeb, I am trying to create it via CDK. Here is cdk synth output getting created,
“GeneDXDataSource”: {
“Type”: “AWS::QuickSight::DataSource”,
“Properties”: {
“AwsAccountId”: “############”,
“DataSourceId”: “GeneDXDS”,
“DataSourceParameters”: {
“S3Parameters”: {
“ManifestFileLocation”: {
“Bucket”: “XXXXXXXXXXXXXX”,
“Key”: “GeneDX/GeneDXReports.manifest”
}
}
},
“Name”: “GeneDXDSrc”,
“Permissions”: [
{
“Actions”: [
“quicksight:UpdateDataSourcePermissions”,
“quicksight:DescribeDataSourcePermissions”,
“quicksight:PassDataSource”,
“quicksight:DescribeDataSource”,
“quicksight:DeleteDataSource”,
“quicksight:UpdateDataSource”
],
“Principal”: “arn:aws:quicksight:us-east-1:$$$$$$$$$$$:user/default/Admin/$$$$$$$$$”
}
],
“Type”: “S3”
},
“Metadata”: {
“aws:cdk:path”: “EbresearchQSCdkStack/GeneDXDataSource”
}
},
“GeneDXDataSet”: {
“Type”: “AWS::QuickSight::DataSet”,
“Properties”: {
“AwsAccountId”: “############”,
“ColumnGroups”: [
{
“GeoSpatialColumnGroup”: {
“Columns”: [
“Country”,
“City”,
“Zipcode”
],
“Name”: “Location”
}
}
],
“DataSetId”: “GeneDX Dataset”,
“ImportMode”: “SPICE”,
“LogicalTableMap”: {
“logicalTableMapKey”: {
“Alias”: “GenemicReports”,
“DataTransforms”: [
{
“CastColumnTypeOperation”: {
“ColumnName”: “Column-1”,
“NewColumnType”: “INTEGER”
}
},
{
“CastColumnTypeOperation”: {
“ColumnName”: “Age”,
“NewColumnType”: “INTEGER”
}
},
{
“TagColumnOperation”: {
“ColumnName”: “City”,
“Tags”: [
{
“ColumnGeographicRole”: “CITY”
}
]
}
},
{
“TagColumnOperation”: {
“ColumnName”: “Zipcode”,
“Tags”: [
{
“ColumnGeographicRole”: “POSTCODE”
}
]
}
},
{
“TagColumnOperation”: {
“ColumnName”: “Country”,
“Tags”: [
{
“ColumnGeographicRole”: “COUNTRY”
}
]
}
},
{
“FilterOperation”: {
“ConditionExpression”: “NOT ({Gene }=" ")”
}
},
{
“ProjectOperation”: {
“ProjectedColumns”: [
"Gene ",
"Disease(s) ",
"Mode of Inheritance ",
"Variant ",
"Classification ",
“Protein”,
“Gene Summary”,
“Condition”,
“Age”,
“Gender”,
“City”,
“Zipcode”,
“Country”
]
}
}
],
“Source”: {
“PhysicalTableId”: “GeneDXPM”
}
}
},
“Name”: “GeneDXDataSet”,
“Permissions”: [
{
“Actions”: [
“quicksight:DescribeDataSet”,
“quicksight:DescribeDataSetPermissions”,
“quicksight:PassDataSet”,
“quicksight:DescribeIngestion”,
“quicksight:ListIngestions”,
“quicksight:UpdateDataSet”,
“quicksight:DeleteDataSet”,
“quicksight:CreateIngestion”,
“quicksight:CancelIngestion”,
“quicksight:UpdateDataSetPermissions”
],
“Principal”: “arn:aws:quicksight:us-east-1:$$$$$$$$$$$$:user/default/Admin/$$$$$$$$$$$$$$”
}
],
“PhysicalTableMap”: {
“GeneDXPM”: {
“S3Source”: {
“DataSourceArn”: {
“Fn::GetAtt”: [
“GeneDXDataSource”,
“Arn”
]
},
“InputColumns”: [
{
“Name”: “Column-1”,
“Type”: “STRING”
},
{
“Name”: "Gene ",
“Type”: “STRING”
},
{
“Name”: "Disease(s) ",
“Type”: “STRING”
},
{
“Name”: "Mode of Inheritance ",
“Type”: “STRING”
},
{
“Name”: "Variant ",
“Type”: “STRING”
},
{
“Name”: "Classification ",
“Type”: “STRING”
},
{
“Name”: “Protein”,
“Type”: “STRING”
},
{
“Name”: “Gene Summary”,
“Type”: “STRING”
},
{
“Name”: “Condition”,
“Type”: “STRING”
},
{
“Name”: “Age”,
“Type”: “STRING”
},
{
“Name”: “Gender”,
“Type”: “STRING”
},
{
“Name”: “City”,
“Type”: “STRING”
},
{
“Name”: “Zipcode”,
“Type”: “STRING”
},
{
“Name”: “Country”,
“Type”: “STRING”
}
],
“UploadSettings”: {
“ContainsHeader”: true,
“Delimiter”: “,”,
“Format”: “CSV”,
“StartFromRow”: 1,
“TextQualifier”: “DOUBLE_QUOTE”
}
}
}
}
},
“Metadata”: {
“aws:cdk:path”: “EbresearchQSCdkStack/GeneDXDataSet”
}
},