我能否使用AWS CLI在Quicksight中创建RDS数据源？

Question

我想创建一个连接到我们的一个RDS实例的数据源。我可以很容易地通过UI创建RDS的数据源，但是当我使用AWS CLI时，我只看到这些值作为create-data-source命令的可能值：

ADOBE_ANALYTICS AMAZON_ELASTICSEARCH ATHENA AURORA AURORA_POSTGRESQL AWS_IOT_ANALYTICS GITHUB JIRA MARIADB MYSQL POSTGRESQL PRESTO REDSHIFT S3 SALESFORCE SERVICENOW SNOWFLAKE SPARK SQLSERVER TERADATA TWITTER

但我确实在选项中看到了RdsParameters：

​

​

我错过了什么？如何创建连接到RDS实例的数据源

Answer 1

使用值中列出的RDS数据库。

aws quicksight create-data-source --aws-account-id 1234567890 --data-source-id "abcdefghijkl" --name "NameOfDS" --type POSTGRESQL --data-source-parameters ...

上面的代码是针对在PostGreSQL中创建的RDS的。

另一种方法是创建一个包含所有必需参数的JSON文件，然后使用如下所示的命令

aws quicksight create-data-source --cli-input-json file://./create-data-source-cli-input.json

其输出将为：

{
    "Status": 202,
    "Arn": "arn:aws:quicksight:ap-southeast-2:xxxxxxxxxxxx:datasource/sample-postgres-db",
    "DataSourceId": "sample-postgres-db",
    "CreationStatus": "CREATION_IN_PROGRESS",
    "RequestId": "d4392bc6-77fa-4346-8e9c-09a716761c4b"
}

JSON文件的格式为：

{
    "AwsAccountId": "xxxxxxxxxxxx",
    "DataSourceId": "sample-postgres-db",
    "Name": "sample-postgres-db",
    "Type": "POSTGRESQL",
    "DataSourceParameters": {
        "PostgreSqlParameters": {
            "Host": "hostname.from-rds.ap-southeast-2.rds.amazonaws.com",
            "Port": 5432,
            "Database": "name-of-db"
        }
    },
    "Credentials": {
        "CredentialPair": {
            "Username": "xxxxxxxxxxxx_postgres_admin",
            "Password": "xxxxxxxxxxxx"
        }
    },
    "Permissions": [
        {
            "Principal": "arn:aws:quicksight:ap-southeast-2:xxxxxxxxxxxx:user/default/alice",
            "Actions": [
                "quicksight:UpdateDataSourcePermissions",
                "quicksight:DescribeDataSource",
                "quicksight:DescribeDataSourcePermissions",
                "quicksight:PassDataSource",
                "quicksight:UpdateDataSource",
                "quicksight:DeleteDataSource"
                
            ]
        }
    ],
    "VpcConnectionProperties": {
        "VpcConnectionArn": "arn:aws:quicksight:ap-southeast-2:xxxxxxxxxxxx:vpcConnection/QuickSight-DB-VPC"
    },
    "Tags": [
        {
            "Key": "Name",
            "Value": "PGSQL-TestDB"
        }
    ]
}