{"id":4114,"date":"2022-01-26T10:38:58","date_gmt":"2022-01-26T01:38:58","guid":{"rendered":"https:\/\/www.ryucom.co.jp\/blog\/?p=4114"},"modified":"2022-01-26T10:39:01","modified_gmt":"2022-01-26T01:39:01","slug":"post-4114","status":"publish","type":"post","link":"https:\/\/www.ryucom.co.jp\/blog\/aws\/4114","title":{"rendered":"Redshift+QuickSight\u3067S3\u306e\u30c7\u30fc\u30bf\u3092\u5206\u6790\u3057\u3066\u307f\u305f"},"content":{"rendered":"\n<p>\u3053\u3093\u306b\u3061\u306f\u3001\u4fdd\u967a\u30b7\u30b9\u30c6\u30e0\u90e8\u306e\u7167\u5c4b\u3067\u3059\u3002<br>\u4eca\u56de\u306f\u3001Redshift\u3092\u69cb\u7bc9\u3057\u3001\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u3001S3\u306b\u3042\u308bCSV\u30d5\u30a1\u30a4\u30eb\u3092\u5206\u6790\u3057\u3066\u307f\u307e\u3059\u3002<br>\u3055\u3089\u306b\u3001QuickSight\u3068\u306e\u9023\u643a\u3092\u884c\u3063\u3066\u3001\u30c7\u30fc\u30bf\u306e\u53ef\u8996\u5316\u3082\u884c\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Amazon Redshift\u3068\u306f<\/h2>\n\n\n\n<p>Redshift\u3068\u306fAWS\u304c\u63d0\u4f9b\u3059\u308b\u30d5\u30eb\u30de\u30cd\u30fc\u30b8\u30c9\u578b\u306e\u30c7\u30fc\u30bf\u30a6\u30a7\u30a2\u30cf\u30a6\u30b9\u30b5\u30fc\u30d3\u30b9\u3067\u3059\u3002<br>Redshift\u306f\u3001PostgreSQL\u3092\u30d9\u30fc\u30b9\u306b\u69cb\u7bc9\u3055\u308c\u3066\u304a\u308a\u3001PostgreSQL\u306e\u69cb\u6587\u3092\u4f7f\u7528\u3057\u3066\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<br>\u307e\u305f\u3001\u30c7\u30fc\u30bf\u3092\u4e26\u5217\u3067\u51e6\u7406\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u9ad8\u901f\u306b\u30c7\u30fc\u30bf\u306e\u8aad\u307f\u51fa\u3057\u3084\u5206\u6790\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br>\u305d\u306e\u305f\u3081\u3001\u5927\u898f\u6a21\u306a\u30c7\u30fc\u30bf\u3092\u51e6\u7406\u3059\u308b\u3053\u3068\u3092\u5f97\u610f\u3068\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Redshift\u306e\u69cb\u7bc9<\/h2>\n\n\n\n<p>Redshift\u306e\u69cb\u7bc9\u306b\u306f\u3001VPC\u3084\u30b5\u30d6\u30cd\u30c3\u30c8\u306e\u4f5c\u6210\u3092\u884c\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<br>\u6700\u521d\u306b\u3001VPC\u3068\u30b5\u30d6\u30cd\u30c3\u30c8\u306e\u4f5c\u6210\u304b\u3089\u884c\u3063\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u69cb\u6210\u56f3<\/h2>\n\n\n\n<p>\u4eca\u56de\u306e\u30b4\u30fc\u30eb\u3068\u306a\u308b\u69cb\u6210\u56f3\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<br>Redshift\u3092\u69cb\u7bc9\u3057\u3066\u3001QuickSight\u3068\u9023\u643a\u3059\u308b\u3053\u3068\u3067\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3057\u307e\u3059\u3002<br>\u3057\u304b\u3057\u3001Redshift\u306f\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8\u30b5\u30d6\u30cd\u30c3\u30c8\u306b\u3042\u308a\u3001QuickSight\u304b\u3089\u76f4\u63a5\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093\u3002<br>\u305d\u306e\u305f\u3081\u3001Redshift\u3068QuickSight\u306e\u9593\u306b\u8e0f\u307f\u53f0\u3068\u306a\u308b\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8\u30b5\u30d6\u30cd\u30c3\u30c8\u3092\u69cb\u7bc9\u3057\u3001QuickSight\u3068\u306eVPC\u63a5\u7d9a\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"567\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000209-1024x567.jpg\" alt=\"AWS\u69cb\u6210\u56f3\" class=\"wp-image-4521\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000209-1024x567.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000209-300x166.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000209-768x426.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000209.jpg 1211w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">VPC\u306e\u4f5c\u6210<\/h3>\n\n\n\n<p>VPC\u306e\u30b3\u30f3\u30bd\u30fc\u30eb\u753b\u9762\u3092\u958b\u304d\u3001\u300cVPC\u300d\u30bf\u30d6\u304b\u3089\u300cVPC\u3092\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"195\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000188-1024x195.jpg\" alt=\"VPC\u3092\u4f5c\u6210\" class=\"wp-image-4363\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000188-1024x195.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000188-300x57.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000188-768x146.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000188.jpg 1099w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>VPC\u306e\u8a2d\u5b9a\u753b\u9762\u3067\u3001VPC\u306e\u540d\u524d\u3084IPv4CIDR\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"607\" height=\"711\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000207.jpg\" alt=\"VPC\u306e\u8a2d\u5b9a\" class=\"wp-image-4408\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000207.jpg 607w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000207-256x300.jpg 256w\" sizes=\"(max-width: 607px) 100vw, 607px\" \/><\/figure>\n\n\n\n<p>\u5165\u529b\u304c\u5b8c\u4e86\u3057\u305f\u3089\u3001\u300cVPC\u3092\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Redshift\u7528\u306e\u30b5\u30d6\u30cd\u30c3\u30c8\u3092\u4f5c\u6210<\/h3>\n\n\n\n<p>\u4f5c\u6210\u3057\u305fVPC\u5185\u306b\u3001\u30b5\u30d6\u30cd\u30c3\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<br>\u4e0b\u56f3\u306e\u30aa\u30ec\u30f3\u30b8\u306e\u67a0\u3067\u56f2\u308f\u308c\u3066\u3044\u308b\u90e8\u5206\u3092\u69cb\u7bc9\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"571\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000210-1024x571.jpg\" alt=\"\u69cb\u7bc9\u3059\u308b\u90e8\u5206\" class=\"wp-image-4522\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000210-1024x571.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000210-300x167.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000210-768x428.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000210.jpg 1212w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>VPC\u306e\u30b3\u30f3\u30bd\u30fc\u30eb\u753b\u9762\u3067\u3001\u300c\u30b5\u30d6\u30cd\u30c3\u30c8\u3092\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"215\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000189-1024x215.jpg\" alt=\"\u30b5\u30d6\u30cd\u30c3\u30c8\u3092\u4f5c\u6210\" class=\"wp-image-4366\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000189-1024x215.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000189-300x63.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000189-768x162.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000189.jpg 1241w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u30b5\u30d6\u30cd\u30c3\u30c8\u3092\u4f5c\u6210\u3059\u308bVPC\u3068\u3057\u3066\u3001\u5148\u307b\u3069\u4f5c\u6210\u3057\u305fVPC\u3092\u9078\u629e\u3057\u307e\u3059\u3002<br>\u30b5\u30d6\u30cd\u30c3\u30c8\u306e\u8a2d\u5b9a\u6b04\u3067\u3001\u30b5\u30d6\u30cd\u30c3\u30c8\u540d\u3001\u30a2\u30d9\u30a4\u30e9\u30d3\u30ea\u30c6\u30a3\uff0d\u30be\u30fc\u30f3\u3001CIDR\u30d6\u30ed\u30c3\u30af\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"567\" height=\"661\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000191.jpg\" alt=\"\u30b5\u30d6\u30cd\u30c3\u30c8\u306e\u8a2d\u5b9a\" class=\"wp-image-4367\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000191.jpg 567w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000191-257x300.jpg 257w\" sizes=\"(max-width: 567px) 100vw, 567px\" \/><\/figure>\n\n\n\n<p>\u5165\u529b\u304c\u5b8c\u4e86\u3057\u305f\u3089\u300c\u30b5\u30d6\u30cd\u30c3\u30c8\u3092\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30af\u30e9\u30b9\u30bf\u30fc\u30b5\u30d6\u30cd\u30c3\u30c8\u30b0\u30eb\u30fc\u30d7\u306e\u4f5c\u6210<\/h3>\n\n\n\n<p>Redshift\u306e\u30b3\u30f3\u30bd\u30fc\u30eb\u753b\u9762\u3067\u3001\u300c\u8a2d\u5b9a\u300d\u30bf\u30d6\u306e\u300c\u30b5\u30d6\u30cd\u30c3\u30c8\u30b0\u30eb\u30fc\u30d7\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"392\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000152-1024x392.jpg\" alt=\"Redshift, \u30b5\u30d6\u30cd\u30c3\u30c8\u30b0\u30eb\u30fc\u30d7\u306e\u4f5c\u6210\" class=\"wp-image-4132\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000152-1024x392.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000152-300x115.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000152-768x294.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000152.jpg 1213w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u300c\u30af\u30e9\u30b9\u30bf\u30fc\u30b5\u30d6\u30cd\u30c3\u30c8\u30b0\u30eb\u30fc\u30d7\u306e\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"167\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000192-1024x167.jpg\" alt=\"Redshift, \u30af\u30e9\u30b9\u30bf\u30fc\u30b5\u30d6\u30cd\u30c3\u30c8\u30b0\u30eb\u30fc\u30d7\u306e\u4f5c\u6210\" class=\"wp-image-4368\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000192-1024x167.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000192-300x49.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000192-768x125.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000192.jpg 1185w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u30af\u30e9\u30b9\u30bf\u30fc\u30b5\u30d6\u30cd\u30c3\u30c8\u30b0\u30eb\u30fc\u30d7\u306e\u8a73\u7d30\u6b04\u3067\u3001\u30af\u30e9\u30b9\u30bf\u30fc\u30b5\u30d6\u30cd\u30c3\u30c8\u30b0\u30eb\u30fc\u30d7\u306e\u540d\u524d\u3068\u8aac\u660e\u3092\u5165\u529b\u3057\u307e\u3059\u3002<br>\u30b5\u30d6\u30cd\u30c3\u30c8\u306e\u8ffd\u52a0\u6b04\u3067\u3001\u4f5c\u6210\u3057\u305fVPC\u3068\u30b5\u30d6\u30cd\u30c3\u30c8\u3092\u9078\u629e\u3057\u3001\u300c\u30b5\u30d6\u30cd\u30c3\u30c8\u3092\u8ffd\u52a0\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br>\u30b5\u30d6\u30cd\u30c3\u30c8\u306e\u8ffd\u52a0\u307e\u3067\u5b8c\u4e86\u3057\u305f\u3089\u3001\u300c\u30af\u30e9\u30b9\u30bf\u30fc\u30b5\u30d6\u30cd\u30c3\u30c8\u30b0\u30eb\u30fc\u30d7\u306e\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"584\" height=\"704\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000193.jpg\" alt=\"Redshift, \u30b5\u30d6\u30cd\u30c3\u30c8\u306e\u8ffd\u52a0\" class=\"wp-image-4369\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000193.jpg 584w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000193-249x300.jpg 249w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u30af\u30e9\u30b9\u30bf\u30fc\u306e\u4f5c\u6210<\/h3>\n\n\n\n<p>Redshift\u306e\u30b3\u30f3\u30bd\u30fc\u30eb\u753b\u9762\u3067\u3001\u300c\u30af\u30e9\u30b9\u30bf\u30fc\u300d\u30bf\u30d6\u306e\u300c\u30af\u30e9\u30b9\u30bf\u30fc\u3092\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"257\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000159-1024x257.jpg\" alt=\"Redshift, \u30af\u30e9\u30b9\u30bf\u30fc\u306e\u4f5c\u6210\" class=\"wp-image-4143\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000159-1024x257.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000159-300x75.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000159-768x193.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000159.jpg 1358w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u6b21\u306e\u753b\u9762\u3067\u3001\u30af\u30e9\u30b9\u30bf\u30fc\u3092\u4f5c\u6210\u3057\u3066\u3044\u304d\u307e\u3059\u3002<br>\u30af\u30e9\u30b9\u30bf\u30fc\u8a2d\u5b9a\u3067\u3001\u30af\u30e9\u30b9\u30bf\u30fc\u8b58\u5225\u5b50\u3068\u30ce\u30fc\u30c9\u306e\u7a2e\u985e\u30fb\u6570\u3092\u5165\u529b\u3057\u307e\u3059\u3002<br>\u4eca\u56de\u306f\u30ce\u30fc\u30c9\u306e\u7a2e\u985e\u3068\u3057\u3066\u3001\u6700\u3082\u5b89\u4fa1\u3067\u5229\u7528\u3067\u304d\u308b\u300cdc2.large\u300d\u3092\u9078\u629e\u3057\u3001\u30ce\u30fc\u30c9\u306e\u6570\u306f1\u3064\u3067\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"550\" height=\"659\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000160.jpg\" alt=\"Redshift, \u30af\u30e9\u30b9\u30bf\u30fc\u306e\u8a2d\u5b9a\" class=\"wp-image-4145\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000160.jpg 550w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000160-250x300.jpg 250w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/figure>\n\n\n\n<p>\u7d9a\u3044\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a2d\u5b9a\u3067\u3001\u7ba1\u7406\u8005\u30e6\u30fc\u30b6\u30fc\u540d\u3068\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<br>\u30af\u30e9\u30b9\u30bf\u30fc\u306e\u8a31\u53ef\u6b04\u3067\u306f\u3001Redshift\u3084S3\u3078\u306e\u30a2\u30af\u30bb\u30b9\u6a29\u9650\u304c\u4ed8\u4e0e\u3055\u308c\u305fIAM\u30ed\u30fc\u30eb\u3092\u95a2\u9023\u4ed8\u3051\u307e\u3059\u3002<br>\u8a2d\u5b9a\u304c\u5b8c\u4e86\u3057\u305f\u3089\u3001\u753b\u9762\u4e0b\u90e8\u306b\u3042\u308b\u300c\u30af\u30e9\u30b9\u30bf\u30fc\u3092\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"585\" height=\"658\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000161.jpg\" alt=\"Redshift, \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a2d\u5b9a\" class=\"wp-image-4148\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000161.jpg 585w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000161-267x300.jpg 267w\" sizes=\"(max-width: 585px) 100vw, 585px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">S3\u306e\u30c7\u30fc\u30bf\u3092Redshift\u3078\u30ed\u30fc\u30c9<\/h3>\n\n\n\n<p>\u30af\u30e9\u30b9\u30bf\u30fc\u4f5c\u6210\u5f8c\u306b\u300c\u30af\u30e9\u30b9\u30bf\u30fc\u300d\u30bf\u30d6\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u4f5c\u6210\u3057\u305f\u30af\u30e9\u30b9\u30bf\u30fc\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<br>\u4f5c\u6210\u3057\u305f\u30af\u30e9\u30b9\u30bf\u30fc\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3001\u300cQuery in query editor\u300d\u304b\u300cQuery in query editor v2\u300d\u306e\u3069\u3061\u3089\u304b\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30a8\u30c7\u30a3\u30bf\u3092\u958b\u304d\u307e\u3059\u3002\uff08\u4eca\u56de\u306f\u300cQuery in query editor v2\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\uff09<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"273\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000183-1024x273.jpg\" alt=\"Redshift, \u30a8\u30c7\u30a3\u30bf\u3092\u958b\u304f\" class=\"wp-image-4246\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000183-1024x273.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000183-300x80.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000183-768x205.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000183.jpg 1288w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>S3\u306e\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30c9\u3059\u308b\u524d\u306b\u3001Redshift\u30af\u30e9\u30b9\u30bf\u30fc\u306b\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"723\" height=\"288\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000163.jpg\" alt=\"Redshift, \u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\" class=\"wp-image-4168\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000163.jpg 723w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000163-300x120.jpg 300w\" sizes=\"(max-width: 723px) 100vw, 723px\" \/><\/figure>\n\n\n\n<p>S3\u306e\u30c7\u30fc\u30bf\u3092Redshift\u306b\u30ed\u30fc\u30c9\u3059\u308b\u306b\u306f\u3001COPY\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<br>FROM\u306b\u306f\u3001\u30ed\u30fc\u30c9\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u30d1\u30b9\u3092\u5165\u529b\u3057\u307e\u3059\u3002<br>iam_role\u306b\u306f\u3001\u30af\u30e9\u30b9\u30bf\u30fc\u4f5c\u6210\u6642\u306b\u7d10\u3065\u3051\u305fIAM\u30ed\u30fc\u30eb\u306eARN\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<br>\u4eca\u56de\u306fCSV\u30d5\u30a1\u30a4\u30eb\u3092\u30ed\u30fc\u30c9\u3059\u308b\u305f\u3081\u3001delimiter\u306b&#8217; , &#8216;\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<br>\u305d\u3057\u3066\u3001IGNOREHEADER\u306b1\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u30011\u884c\u76ee\u3092\u30d8\u30c3\u30c0\u30fc\u3068\u3057\u3066\u6271\u3044\u3001\u30ed\u30fc\u30c9\u3057\u306a\u3044\u3068\u3044\u3046\u8a2d\u5b9a\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"933\" height=\"330\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000184.jpg\" alt=\"Redshift, S3\u30c7\u30fc\u30bf\u306e\u30ed\u30fc\u30c9\" class=\"wp-image-4247\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000184.jpg 933w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000184-300x106.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000184-768x272.jpg 768w\" sizes=\"(max-width: 933px) 100vw, 933px\" \/><\/figure>\n\n\n\n<p>\u30c7\u30fc\u30bf\u306e\u30ed\u30fc\u30c9\u304c\u5b8c\u4e86\u3057\u305f\u3089\u3001SELECT\u6587\u3092\u5b9f\u884c\u3057\u3001\u6b63\u3057\u304f\u30ed\u30fc\u30c9\u3067\u304d\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"404\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000166-1024x404.jpg\" alt=\"Redshift, \u30ed\u30fc\u30c9\u78ba\u8a8d\" class=\"wp-image-4173\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000166-1024x404.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000166-300x118.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000166-768x303.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2021\/12\/WS000166.jpg 1298w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u6b63\u3057\u304f\u30ed\u30fc\u30c9\u3067\u304d\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u51fa\u6765\u305f\u3089\u3001Redshift\u306e\u69cb\u7bc9\u306f\u5b8c\u4e86\u3067\u3059\uff01<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">QuickSight\u3078\u306e\u9023\u643a<\/h2>\n\n\n\n<p>Redshift\u306b\u30ed\u30fc\u30c9\u3057\u305f\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3057\u3066\u5206\u6790\u3059\u308b\u305f\u3081\u306b\u3001QuickSight\u3078\u306e\u9023\u643a\u3092\u884c\u3044\u307e\u3059\u3002<br>\u3057\u304b\u3057\u3001\u4eca\u56de\u69cb\u7bc9\u3057\u305fRedshift\u30af\u30e9\u30b9\u30bf\u30fc\u306f\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8\u30b5\u30d6\u30cd\u30c3\u30c8\u5185\u306b\u3042\u308b\u305f\u3081\u3001\u73fe\u5728\u306e\u72b6\u614b\u3067\u306fQuickSight\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093\u3002<br>\u305d\u306e\u305f\u3081\u3001QuickSight\u304b\u3089Redshift\u30af\u30e9\u30b9\u30bf\u30fc\u3078\u306eVPC\u63a5\u7d9a\u3092\u884c\u3044\u307e\u3059\u3002<br>VPC\u63a5\u7d9a\u3092\u884c\u3046\u305f\u3081\u306b\u306f\u3001\u65b0\u3057\u304f\u30b5\u30d6\u30cd\u30c3\u30c8\u3068\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u3092\u4f5c\u6210\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">QuickSight\u30a2\u30af\u30bb\u30b9\u7528\u306e\u30b5\u30d6\u30cd\u30c3\u30c8\u3092\u4f5c\u6210<\/h3>\n\n\n\n<p>\u4e0b\u56f3\u306e\u30aa\u30ec\u30f3\u30b8\u306e\u67a0\u3067\u56f2\u308f\u308c\u3066\u3044\u308b\u90e8\u5206\u3092\u69cb\u7bc9\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"564\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000211-1024x564.jpg\" alt=\"\u69cb\u7bc9\u3059\u308b\u90e8\u5206\" class=\"wp-image-4523\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000211-1024x564.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000211-300x165.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000211-768x423.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000211.jpg 1226w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u4eca\u56de\u4f5c\u6210\u3057\u305fVPC\u5185\u306b\u3001QuickSight\u30a2\u30af\u30bb\u30b9\u7528\u306e\u30b5\u30d6\u30cd\u30c3\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"523\" height=\"682\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000194.jpg\" alt=\"Quicksight\u30a2\u30af\u30bb\u30b9\u7528\u30b5\u30d6\u30cd\u30c3\u30c8\u4f5c\u6210\" class=\"wp-image-4371\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000194.jpg 523w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000194-230x300.jpg 230w\" sizes=\"(max-width: 523px) 100vw, 523px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">QuickSight\u30a2\u30af\u30bb\u30b9\u7528\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u306e\u4f5c\u6210<\/h3>\n\n\n\n<p>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\uff08Security group1\uff09\u3092\u4f5c\u6210\u3057\u3066\u3001\u4e0b\u56f3\u306e\u30aa\u30ec\u30f3\u30b8\u306e\u67a0\u3067\u56f2\u308f\u308c\u305f\u90e8\u5206\u3067\u901a\u4fe1\u3092\u884c\u3048\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"559\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000212-1024x559.jpg\" alt=\"\u69cb\u7bc9\u3059\u308b\u90e8\u5206\" class=\"wp-image-4524\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000212-1024x559.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000212-300x164.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000212-768x420.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000212.jpg 1219w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>VPC\u5185\u306b\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\uff08Security group1\uff09\u3092\u4f5c\u6210\u3057\u3066\u3044\u304d\u307e\u3059\u3002<br>Redshift\u30af\u30e9\u30b9\u30bf\u30fc\u304b\u3089\u306e\u901a\u4fe1\u3092\u8a31\u53ef\u3059\u308b\u30a4\u30f3\u30d0\u30a6\u30f3\u30c9\u30eb\u30fc\u30eb\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<br>\u300c\u30bf\u30a4\u30d7\u300d\u306f\u300c\u3059\u3079\u3066\u306eTCP\u300d\u3092\u9078\u629e\u3057\u3001\u300c\u30bd\u30fc\u30b9\u300d\u306b\u306fVPC\u3092\u4f5c\u6210\u3057\u305f\u969b\u306b\u81ea\u52d5\u3067\u4f5c\u6210\u3055\u308c\u305f\u3001Redshift\u7528\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\uff08Security group2\uff09\u306eID\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1004\" height=\"357\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000195.jpg\" alt=\"Quicksight\u30a2\u30af\u30bb\u30b9\u7528\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u4f5c\u6210, \u30a4\u30f3\u30d0\u30a6\u30f3\u30c9\u30eb\u30fc\u30eb\" class=\"wp-image-4372\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000195.jpg 1004w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000195-300x107.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000195-768x273.jpg 768w\" sizes=\"(max-width: 1004px) 100vw, 1004px\" \/><\/figure>\n\n\n\n<p>Redshift\u30af\u30e9\u30b9\u30bf\u30fc\u3078\u306e\u30c8\u30e9\u30d5\u30a3\u30c3\u30af\u3092\u8a31\u53ef\u3059\u308b\u30a2\u30a6\u30c8\u30d0\u30a6\u30f3\u30c9\u30eb\u30fc\u30eb\u3082\u8ffd\u52a0\u3057\u307e\u3059\u3002<br>\u300c\u30bf\u30a4\u30d7\u300d\u306f\u300c\u30ab\u30b9\u30bf\u30e0TCP\u300d\u3092\u9078\u629e\u3057\u3001\u300c\u30dd\u30fc\u30c8\u7bc4\u56f2\u300d\u306b\u306fRedshift\u30dd\u30fc\u30c8\u3067\u3042\u308b\u300c5439\u300d\u3092\u5165\u529b\u3057\u307e\u3059\u3002<br>\u300c\u30bd\u30fc\u30b9\u300d\u306b\u306f\u30a4\u30f3\u30d0\u30a6\u30f3\u30c9\u30eb\u30fc\u30eb\u3067\u8a2d\u5b9a\u3057\u305f\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7ID\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"173\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000214-1024x173.jpg\" alt=\"\u30a2\u30a6\u30c8\u30d0\u30a6\u30f3\u30c9\u30eb\u30fc\u30eb\" class=\"wp-image-4529\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000214-1024x173.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000214-300x51.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000214-768x129.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000214.jpg 1169w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u4ee5\u4e0a\u3067\u3001QuickSight\u30a2\u30af\u30bb\u30b9\u7528\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u306e\u4f5c\u6210\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Redshift\u7528\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u3092\u7de8\u96c6<\/h3>\n\n\n\n<p>VPC\u3092\u4f5c\u6210\u3057\u305f\u969b\u306b\u3001\u81ea\u52d5\u7684\u306b\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u4f5c\u6210\u3055\u308c\u308bRedshift\u7528\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\uff08Security group2\uff09\u3092\u7de8\u96c6\u3057\u3066\u3044\u304d\u307e\u3059\u3002<br>QuickSight\u30a2\u30af\u30bb\u30b9\u7528\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\uff08Security group1\uff09\u304b\u3089\u306e\u30c8\u30e9\u30d5\u30a3\u30c3\u30af\u3092\u8a31\u53ef\u3059\u308b\u30a4\u30f3\u30d0\u30a6\u30f3\u30c9\u30eb\u30fc\u30eb\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<br>\u300c\u30bf\u30a4\u30d7\u300d\u306f\u300cRedshift\u300d\u3092\u9078\u629e\u3057\u3001\u300c\u30bd\u30fc\u30b9\u300d\u306b\u306fQuickSight\u30a2\u30af\u30bb\u30b9\u7528\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7ID\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"256\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000197-1024x256.jpg\" alt=\"\u30c7\u30d5\u30a9\u30eb\u30c8\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u306e\u7de8\u96c6, \u30a4\u30f3\u30d0\u30a6\u30f3\u30c9\u30eb\u30fc\u30eb\" class=\"wp-image-4375\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000197-1024x256.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000197-300x75.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000197-768x192.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000197.jpg 1026w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>QuickSight\u30a2\u30af\u30bb\u30b9\u7528\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\uff08Security group1\uff09\u3078\u306e\u30c8\u30e9\u30d5\u30a3\u30c3\u30af\u3092\u8a31\u53ef\u3059\u308b\u30a2\u30a6\u30c8\u30d0\u30a6\u30f3\u30c9\u30eb\u30fc\u30eb\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<br>\u300c\u30bf\u30a4\u30d7\u300d\u306f\u300c\u3059\u3079\u3066\u306eTCP\u300d\u3092\u9078\u629e\u3057\u3001\u30bd\u30fc\u30b9\u306b\u30a4\u30f3\u30d0\u30f3\u30c9\u30eb\u30fc\u30eb\u3067\u8a2d\u5b9a\u3057\u305f\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7ID\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"277\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000215-1024x277.jpg\" alt=\"\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u306e\u7de8\u96c6\uff08\u30a2\u30a6\u30c8\u30d0\u30a6\u30f3\u30c9\uff09\" class=\"wp-image-4532\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000215-1024x277.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000215-300x81.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000215-768x208.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000215.jpg 1162w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u4ee5\u4e0a\u3067\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u306e\u7de8\u96c6\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">VPC\u63a5\u7d9a\u306e\u8ffd\u52a0<\/h3>\n\n\n\n<p>\u4e0b\u56f3\u306e\u30aa\u30ec\u30f3\u30b8\u306e\u67a0\u3067\u56f2\u308f\u308c\u305f\u90e8\u5206\u3092\u69cb\u7bc9\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"555\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000213-1024x555.jpg\" alt=\"\u69cb\u7bc9\u3059\u308b\u90e8\u5206\" class=\"wp-image-4526\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000213-1024x555.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000213-300x163.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000213-768x416.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000213.jpg 1217w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>QuickSight\u306eVPC\u63a5\u7d9a\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<br>QuickSight\u30b3\u30f3\u30bd\u30fc\u30eb\u753b\u9762\u53f3\u4e0a\u306e\u3001\u30e6\u30fc\u30b6\u30fc\u540d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u300cQuickSight\u306e\u7ba1\u7406\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"242\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000172-1024x242.jpg\" alt=\"Quicksight, Quicksight\u306e\u7ba1\u7406\" class=\"wp-image-4207\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000172-1024x242.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000172-300x71.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000172-768x181.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000172.jpg 1498w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u6b21\u306e\u753b\u9762\u3067\u300cVPC\u63a5\u7d9a\u306e\u7ba1\u7406\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u300cVPC\u63a5\u7d9a\u306e\u8ffd\u52a0\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"172\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000201-1024x172.jpg\" alt=\"Quicksight, VPC\u63a5\u7d9a\u306e\u8ffd\u52a0\" class=\"wp-image-4394\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000201-1024x172.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000201-300x50.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000201-768x129.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000201.jpg 1245w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>VPC\u63a5\u7d9a\u306e\u8ffd\u52a0\u753b\u9762\u3067\u3001VPC\u63a5\u7d9a\u540d\u3001VPC ID\u3001\u30b5\u30d6\u30cd\u30c3\u30c8ID\u3001\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7ID\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"743\" height=\"556\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000199.jpg\" alt=\"Quicksight, VPC\u63a5\u7d9a\u306e\u8ffd\u52a0\" class=\"wp-image-4378\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000199.jpg 743w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000199-300x224.jpg 300w\" sizes=\"(max-width: 743px) 100vw, 743px\" \/><\/figure>\n\n\n\n<p>\u5165\u529b\u304c\u5b8c\u4e86\u3057\u305f\u3089\u3001\u300c\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br>\u4ee5\u4e0a\u3067VPC\u63a5\u7d9a\u306e\u8ffd\u52a0\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306e\u4f5c\u6210\u3068\u5206\u6790<\/h3>\n\n\n\n<p>QuickSight\u30b3\u30f3\u30bd\u30fc\u30eb\u753b\u9762\u306e\u300c\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u300d\u30bf\u30d6\u306e\u300c\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<br>\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u4f5c\u6210\u3059\u308b\u753b\u9762\u3067\u3001\u300cRedshift\u300d\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"410\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000174-1024x410.jpg\" alt=\"Quicksight, \u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u4f5c\u6210\" class=\"wp-image-4218\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000174-1024x410.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000174-300x120.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000174-768x307.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000174.jpg 1302w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u6b21\u306e\u753b\u9762\u3067\u3001\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u540d\u3092\u5165\u529b\u3057\u3001\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9ID\u3067\u4eca\u56de\u4f5c\u6210\u3057\u305fRedshift\u30af\u30e9\u30b9\u30bf\u30fc\u3092\u9078\u629e\u3057\u307e\u3059\u3002<br>\u63a5\u7d9a\u30bf\u30a4\u30d7\u3067\u306f\u3001\u5148\u307b\u3069\u4f5c\u6210\u3057\u305fVPC\u63a5\u7d9a\u3092\u9078\u629e\u3057\u3001\u30af\u30e9\u30b9\u30bf\u30fc\u4f5c\u6210\u6642\u306b\u8a2d\u5b9a\u3057\u305f\u3057\u305f\u30e6\u30fc\u30b6\u540d\u3068\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u307e\u3059\u3002<br>\u5165\u529b\u304c\u5b8c\u4e86\u3057\u305f\u3089\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"662\" height=\"642\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000175.jpg\" alt=\"Quicksight, \u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u4f5c\u6210\" class=\"wp-image-4219\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000175.jpg 662w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000175-300x291.jpg 300w\" sizes=\"(max-width: 662px) 100vw, 662px\" \/><\/figure>\n\n\n\n<p>\u6b21\u306e\u30c6\u30fc\u30d6\u30eb\u9078\u629e\u753b\u9762\u3067\u4eca\u56de\u4f5c\u6210\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"647\" height=\"531\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000176.jpg\" alt=\"Quicksight, \u30c6\u30fc\u30d6\u30eb\u306e\u9078\u629e\" class=\"wp-image-4235\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000176.jpg 647w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000176-300x246.jpg 300w\" sizes=\"(max-width: 647px) 100vw, 647px\" \/><\/figure>\n\n\n\n<p>\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u4f5c\u6210\u306e\u5b8c\u4e86\u753b\u9762\u3067\u306f\u3001SPICE\u3078\u30a4\u30f3\u30dd\u30fc\u30c8\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3001\u300cVisualize\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"663\" height=\"405\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000177.jpg\" alt=\"Quicksight, \u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u4f5c\u6210\u5b8c\u4e86\" class=\"wp-image-4238\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000177.jpg 663w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000177-300x183.jpg 300w\" sizes=\"(max-width: 663px) 100vw, 663px\" \/><\/figure>\n\n\n\n<p>\u6b21\u306e\u753b\u9762\u3067\u3001\u5b9f\u969b\u306b\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3057\u3066\u5206\u6790\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"563\" src=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000178-1024x563.jpg\" alt=\"Quicksight, \u5206\u6790\" class=\"wp-image-4240\" srcset=\"https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000178-1024x563.jpg 1024w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000178-300x165.jpg 300w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000178-768x422.jpg 768w, https:\/\/www.ryucom.co.jp\/blog\/cms\/wp-content\/uploads\/2022\/01\/WS000178.jpg 1112w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u4ee5\u4e0a\u3067QuickSight\u3078\u306e\u9023\u643a\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\uff01<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u3055\u3044\u3054\u306b<\/h2>\n\n\n\n<p>\u4eca\u56de\u306f\u3001Redshift\u306e\u69cb\u7bc9\u304b\u3089QuickSight\u3078\u306e\u9023\u643a\u307e\u3067\u884c\u3044\u307e\u3057\u305f\u3002<br>QuickSight\u3078\u306e\u9023\u643a\u3067\u306f\u3001\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8\u30b5\u30d6\u30cd\u30c3\u30c8\u306b\u4f5c\u6210\u3057\u305fRedshift\u30af\u30e9\u30b9\u30bf\u30fc\u306b\u5bfe\u3057\u3066VPC\u63a5\u7d9a\u3092\u884c\u3046\u305f\u3081\u3001\u8907\u96d1\u306a\u624b\u9806\u304c\u5fc5\u8981\u3067\u3057\u305f\u3002<br>\u3057\u304b\u3057\u3001VPC\u3084\u30b5\u30d6\u30cd\u30c3\u30c8\u3001\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u306a\u3069\u69d8\u3005\u306a\u30b5\u30fc\u30d3\u30b9\u3092\u89e6\u308b\u6a5f\u4f1a\u3068\u306a\u308a\u307e\u3057\u305f\uff01<br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u3093\u306b\u3061\u306f\u3001\u4fdd\u967a\u30b7\u30b9\u30c6\u30e0\u90e8\u306e\u7167\u5c4b\u3067\u3059\u3002\u4eca\u56de\u306f\u3001Redshift\u3092\u69cb\u7bc9\u3057\u3001\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u3001S3\u306b\u3042\u308bCSV\u30d5\u30a1\u30a4\u30eb\u3092\u5206\u6790\u3057\u3066\u307f\u307e\u3059\u3002\u3055\u3089\u306b\u3001QuickSight\u3068\u306e\u9023\u643a\u3092\u884c\u3063\u3066\u3001\u30c7\u30fc\u30bf\u306e\u53ef\u8996\u5316\u3082\u884c\u3044\u307e\u3059\u3002 Amazon  [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":4345,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[36,41],"_links":{"self":[{"href":"https:\/\/www.ryucom.co.jp\/blog\/wp-json\/wp\/v2\/posts\/4114"}],"collection":[{"href":"https:\/\/www.ryucom.co.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ryucom.co.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ryucom.co.jp\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ryucom.co.jp\/blog\/wp-json\/wp\/v2\/comments?post=4114"}],"version-history":[{"count":104,"href":"https:\/\/www.ryucom.co.jp\/blog\/wp-json\/wp\/v2\/posts\/4114\/revisions"}],"predecessor-version":[{"id":4536,"href":"https:\/\/www.ryucom.co.jp\/blog\/wp-json\/wp\/v2\/posts\/4114\/revisions\/4536"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ryucom.co.jp\/blog\/wp-json\/wp\/v2\/media\/4345"}],"wp:attachment":[{"href":"https:\/\/www.ryucom.co.jp\/blog\/wp-json\/wp\/v2\/media?parent=4114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ryucom.co.jp\/blog\/wp-json\/wp\/v2\/categories?post=4114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ryucom.co.jp\/blog\/wp-json\/wp\/v2\/tags?post=4114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}