Amazon QuickSight 直接アップロードした CSV のデータセットから S3+Athena のデータセット置き換えを試してみた

date,category,subcategory,location,value,temperature,precipitation,visitor_count,revenue,fish_type,catch_weight
2024-01-15,観光,博物館,網走監獄博物館,850,−8.2,12.5,850,127500,カニ,2500
2024-01-15,漁業,水揚げ,網走港,2500,−8.2,12.5,0,0,ホタテ,1800
2024-01-16,観光,体験,流氷ウォーク,320,−6.8,0.0,320,96000,サケ,950
以下省略

CREATE DATABASE IF NOT EXISTS abashiri_data

CREATE EXTERNAL TABLE abashiri_data.abashiri_tourism (
    date date,
    category string,
    subcategory string,
    location string,
    value int,
    temperature double,
    precipitation double,
    visitor_count int,
    revenue bigint,
    fish_type string,
    catch_weight int
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
    'serialization.format' = ',',
    'field.delim' = ',',
    'escape.delim' = '\\'
)
LOCATION 's3://test-quicksight-data-migration/'
TBLPROPERTIES (
    'has_encrypted_data'='false',
    'skip.header.line.count'='1',
    'projection.enabled'='false'
);

$ aws quicksight start-asset-bundle-export-job --cli-input-json file://input.json
$ aws quicksight describe-asset-bundle-export-job --aws-account-id $SOURCE_ACCOUNT_ID --asset-bundle-export-job-id $EXPORT_JOB_ID

{
    "Status": 200,
    "JobStatus": "SUCCESSFUL",
    "DownloadUrl": "https://quicksight-asset-bundle-export-job-ap-northeast-1.s3.ap-northeast-1.amazonaws.com/0123456789012/test-export-1/example-uuid/assetbundle-test-export-1.qs?X-Amz-Security-Token=EXAMPLE_TOKEN&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20250526T235800Z&X-Amz-SignedHeaders=host&X-Amz-Credential=EXAMPLE_CREDENTIAL&X-Amz-Expires=300&X-Amz-Signature=EXAMPLE_SIGNATURE",
    "Arn": "arn:aws:quicksight:ap-northeast-1:0123456789012:asset-bundle-export-job/test-export-1",
    "CreatedTime": "2025-05-27T08:55:16+09:00",
    "AssetBundleExportJobId": "test-export-1",
    "AwsAccountId": "0123456789012",
    "ResourceArns": [
        "arn:aws:quicksight:ap-northeast-1:0123456789012:dashboard/1a98513b-d667-4702-921f-6532c20a7d37"
    ],
    "IncludeAllDependencies": true,
    "ExportFormat": "QUICKSIGHT_JSON",
    "RequestId": "cab5a141-ad86-4fc4-aa73-4b5f9241e996",
    "IncludePermissions": true,
    "IncludeTags": false,
    "IncludeFolderMemberships": false,
    "IncludeFolderMembers": "NONE"
}