從 Timestream for LiveAnalytics 的 UNLOAD 先決條件

以下是使用 UNLOAD Timestream for LiveAnalytics 將資料寫入 S3 的先決條件。

• 您必須具有從 Timestream for LiveAnalytics 資料表 （要在 UNLOAD命令中使用的） 讀取資料的許可。

• 您必須在與 Timestream for LiveAnalytics 資源相同的 AWS 區域中擁有 Amazon S3 儲存貯體。

• 對於選取的 S3 儲存貯體，請確定 S3 儲存貯體政策也具有允許 Timestream for LiveAnalytics 匯出資料的許可。

• 用於執行UNLOAD查詢的登入資料必須具有必要的 AWS Identity and Access Management (IAM) 許可，允許 Timestream for LiveAnalytics 將資料寫入 S3。範例政策如下：

JSON

{
    "Version": "2012-10-17",
    "Statement": [{
            "Effect": "Allow",
            "Action": [
                "timestream:Select",
                "timestream:ListMeasures",
                "timestream:WriteRecords",
                "timestream:Unload"
            ],
            "Resource": "arn:aws:timestream:111122223333:database/database_name/table/table_name"
        },
        {
            "Effect": "Allow",
            "Action": [
                "s3:GetBucketAcl",
                "s3:PutObject",
                "s3:GetObjectMetadata",
                "s3:AbortMultipartUpload"
            ],
            "Resource": [
                "arn:aws:s3:::S3_Bucket_Created",
                "arn:aws:s3:::S3_Bucket_Created/*"
            ]
        }
    ]
}

如需這些 S3 寫入許可的其他內容，請參閱 Amazon Simple Storage Service 指南。如果您使用 KMS 金鑰來加密匯出的資料，請參閱以下內容以了解所需的其他 IAM 政策。

JSON

{
    "Version": "2012-10-17",
    "Statement": [
      {
        "Effect": "Allow",
        "Action": [
            "kms:DescribeKey",
            "kms:Decrypt",
            "kms:GenerateDataKey*"
        ],
        "Resource": "arn:aws:kms:111122223333:key/*",
        "Condition": {
            "ForAnyValue:StringLike": {
                "kms:ResourceAliases": "alias/Alias_For_Generated_Key"
            }
        }
    }, {
        "Effect": "Allow",
        "Action": [
            "kms:CreateGrant"
        ],
        "Resource": "arn:aws:kms:111122223333:key/*",
        "Condition": {
            "ForAnyValue:StringEquals": {
                "kms:EncryptionContextKeys": "aws:timestream:database_name"
            },
            "Bool": {
                "kms:GrantIsForAWSResource": true
            },
            "StringLike": {
                "kms:ViaService": "timestream..amazonaws.com"
            },
            "ForAnyValue:StringLike": {
                "kms:ResourceAliases": "alias/Alias_For_Generated_Key"
            }
        }
    }
]
}