{"id":24765,"date":"2023-12-04T14:50:39","date_gmt":"2023-12-04T05:50:39","guid":{"rendered":"https:\/\/www.skyarch.net\/blog\/?p=24765"},"modified":"2023-12-04T14:50:39","modified_gmt":"2023-12-04T05:50:39","slug":"amazon-redshift-streaming-ingestion-%e3%82%92%e3%82%84%e3%81%a3%e3%81%a6%e3%81%bf%e3%81%9f","status":"publish","type":"post","link":"https:\/\/www.skyarch.net\/blog\/amazon-redshift-streaming-ingestion-%e3%82%92%e3%82%84%e3%81%a3%e3%81%a6%e3%81%bf%e3%81%9f\/","title":{"rendered":"Amazon Redshift Streaming Ingestion \u3092\u3084\u3063\u3066\u307f\u305f"},"content":{"rendered":"<h2>\u306f\u3058\u3081\u306b<\/h2>\n<p>\u30b9\u30c8\u30ea\u30fc\u30df\u30f3\u30b0\u30a4\u30f3\u30b8\u30a7\u30b9\u30c8\u3068\u306f\uff1f<br \/>\n\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u751f\u6210\u3055\u308c\u308b\u30c7\u30fc\u30bf\u3092\u7d99\u7d9a\u7684\u306b\u53ce\u96c6\u3057\u3001\u5206\u6790\u3084\u51e6\u7406\u306e\u305f\u3081\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3084\u30c7\u30fc\u30bf\u30a6\u30a7\u30a2\u30cf\u30a6\u30b9\u306b\u9001\u4fe1\u3059\u308b\u30d7\u30ed\u30bb\u30b9\u3002<br \/>\n\u3053\u308c\u306b\u3088\u308a\u3001\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u8fbc\u307f\u3068\u5206\u6790\u304c\u307b\u307c\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u884c\u3048\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u4eca\u56de\u306f\u3001Kinesis Data Streams\u306b\u9001\u3089\u308c\u3066\u304f\u308b\u30c7\u30fc\u30bf\u3092\u3001Redshift\u306e\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30fb\u30d3\u30e5\u30fc\u7d4c\u7531\u3067\u30cb\u30a2\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306bSQL\u3067\u53c2\u7167\u3059\u308b\u3068\u3053\u308d\u307e\u3067\u3092\u3084\u3063\u3066\u307f\u3088\u3046\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<h2>\u76ee\u6b21<\/h2>\n<ul>\n<li><a href=\"#overview\">\u624b\u9806\u306e\u6982\u8981<\/a><\/li>\n<li><a href=\"#tejun\">\u624b\u9806<\/a><\/li>\n<li><a href=\"#matome\">\u307e\u3068\u3081<\/a><\/li>\n<\/ul>\n<h2 id=\"overview\">\u624b\u9806\u306e\u6982\u8981<\/h2>\n<ol>\n<li>Kinesis DataStream\u306e\u4f5c\u6210<\/li>\n<li>RedshiftServerless\u306e\u4f5c\u6210<\/li>\n<li>Redshift\u306bKinesis Data Streams\u7528\u30dd\u30ea\u30b7\u30fc\u3092\u4ed8\u4e0e<\/li>\n<li>Kinesis Data Stream\u3000\u2192\u3000RedShift\u3000\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u306e\u9023\u643a<\/li>\n<li>\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u306e\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u3092\u5b9a\u671f\u5b9f\u884c<\/li>\n<li>\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u306e\u78ba\u8a8d<\/li>\n<\/ol>\n<h2 id=\"tejun\">\u624b\u9806<\/h2>\n<h3>Kinesis DataStream\u306e\u4f5c\u6210<\/h3>\n<p>\u30b9\u30c8\u30ea\u30fc\u30e0\u30c7\u30fc\u30bf\u3092\u9001\u4fe1\u3059\u308b Kinesis Data Stream \u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<br \/>\n\u4eca\u56de\u306f\u691c\u8a3c\u306a\u306e\u3067\u3001\u30b7\u30e3\u30fc\u30c9\u6570\u306f 1\u3064 \u3067\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/03ca0137be88bc415e7a20794dc10c5c.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24867\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/03ca0137be88bc415e7a20794dc10c5c.png\" alt=\"\" width=\"588\" height=\"619\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/03ca0137be88bc415e7a20794dc10c5c.png 588w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/03ca0137be88bc415e7a20794dc10c5c-285x300.png 285w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/a>\n<p>Kinesis Data Stream\u306e\u30ad\u30e3\u30d1\u30b7\u30c6\u30a3\u7ba1\u7406\u306b\u306f\u3001\u30aa\u30f3\u30c7\u30de\u30f3\u30c9\u30e2\u30fc\u30c9\u3068\u30d7\u30ed\u30d3\u30b8\u30e7\u30f3\u30c9\u30e2\u30fc\u30c9\u306e\uff12\u3064\u304c\u5b58\u5728\u3057\u307e\u3059\u3002<br \/>\n<b>\u30aa\u30f3\u30c7\u30de\u30f3\u30c9<\/b><br \/>\n\u30fb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u9700\u8981\u306b\u5fdc\u3058\u3066\u81ea\u52d5\u7684\u306b\u30b9\u30b1\u30fc\u30ea\u30f3\u30b0\u304c\u884c\u308f\u308c\u307e\u3059\u3002<br \/>\n\u30fb\u30c7\u30fc\u30bf\u306e\u8aad\u307f\u66f8\u304d\u306b\u5fc5\u8981\u306a\u5bb9\u91cf\u3092\u81ea\u52d5\u7684\u306b\u8abf\u6574\u3057\u3001\u5fc5\u8981\u306a\u30b9\u30eb\u30fc\u30d7\u30c3\u30c8\u3092\u63d0\u4f9b\u3059\u308b\u305f\u3081\u306b\u3001\u30b7\u30e3\u30fc\u30c9\u3092\u81ea\u52d5\u7684\u306b\u7ba1\u7406\u3057\u307e\u3059\u3002<br \/>\n\u30fb\u4e88\u6e2c\u4e0d\u80fd\u3067\u5909\u52d5\u6027\u306e\u9ad8\u3044\u30c8\u30e9\u30d5\u30a3\u30c3\u30af\u30d1\u30bf\u30fc\u30f3\u3092\u6301\u3064\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u306b\u9069\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\n<strong>\u30d7\u30ed\u30d3\u30b8\u30e7\u30f3\u30c9<\/strong><br \/>\n\u30fb\u30c7\u30fc\u30bf\u30b9\u30c8\u30ea\u30fc\u30e0\u306e\u30b7\u30e3\u30fc\u30c9\u30ab\u30a6\u30f3\u30c8\u3092\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u30c7\u30fc\u30bf\u30b9\u30c8\u30ea\u30fc\u30e0\u306e\u7dcf\u5bb9\u91cf\u306f\u3001\u30b7\u30e3\u30fc\u30c9\u306e\u5bb9\u91cf\u306e\u5408\u8a08\u3068\u306a\u308a\u307e\u3059<br \/>\n\u30fb\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u3001\u30c7\u30fc\u30bf\u30b9\u30c8\u30ea\u30fc\u30e0\u306e\u30b7\u30e3\u30fc\u30c9\u306e\u6570\u3092\u5897\u6e1b\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<br \/>\n\u30fb\u4e88\u6e2c\u3057\u3084\u3059\u3044\u5bb9\u91cf\u8981\u4ef6\u3092\u6301\u3064\u4e88\u6e2c\u53ef\u80fd\u306a\u30c8\u30e9\u30d5\u30a3\u30c3\u30af\u306b\u9069\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u300c<a class=\"confluence-ssr-app-tgpl01\" title=\"https:\/\/docs.aws.amazon.com\/ja_jp\/streams\/latest\/dev\/how-do-i-size-a-stream.html\" href=\"https:\/\/docs.aws.amazon.com\/ja_jp\/streams\/latest\/dev\/how-do-i-size-a-stream.html\" data-testid=\"link-with-safety\" data-renderer-mark=\"true\">\u30c7\u30fc\u30bf\u30b9\u30c8\u30ea\u30fc\u30e0\u5bb9\u91cf\u30e2\u30fc\u30c9\u306e\u9078\u629e<\/a>\u300d\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>Data Stream\u306e\u4f5c\u6210\u5b8c\u4e86<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/a02ab1519b109db7ff424d8c5963f03c.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-24869\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/a02ab1519b109db7ff424d8c5963f03c-1024x369.png\" alt=\"\" width=\"728\" height=\"262\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/a02ab1519b109db7ff424d8c5963f03c-1024x369.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/a02ab1519b109db7ff424d8c5963f03c-300x108.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/a02ab1519b109db7ff424d8c5963f03c-768x277.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/a02ab1519b109db7ff424d8c5963f03c-728x262.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/a02ab1519b109db7ff424d8c5963f03c.png 1285w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/a><\/p>\n<h3>RedshiftServerless\u306e\u4f5c\u6210<\/h3>\n<p>Amazon Redshift\u306e\u30b3\u30f3\u30bd\u30fc\u30eb\u304b\u3089\u300cTry Redshift Serverless free trial\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u4f5c\u6210\u306e<br \/>\n\u958b\u59cb\u3067\u3059\u3002<br \/>\n(Redshift Serverless\u3092\u521d\u3081\u3066\u306e\u5229\u7528\u306e\u5834\u5408\u3001\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u4f7f\u7528\u3067\u304d\u308b300\u30c9\u30eb\u306e\u30af\u30ec\u30b8\u30c3\u30c8\u304c\u3082\u3089\u3048\u308b\u3088\u3046\u3067\u3059)<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/5395c97613c4833ca4c5ad799ca5eddf.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-24872\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/5395c97613c4833ca4c5ad799ca5eddf-1024x341.png\" alt=\"\" width=\"728\" height=\"242\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/5395c97613c4833ca4c5ad799ca5eddf-1024x341.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/5395c97613c4833ca4c5ad799ca5eddf-300x100.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/5395c97613c4833ca4c5ad799ca5eddf-768x256.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/5395c97613c4833ca4c5ad799ca5eddf-728x243.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/5395c97613c4833ca4c5ad799ca5eddf.png 1275w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/a><\/p>\n<p>\u4eca\u56de\u306f\u3001\u8a2d\u5b9a\u3092\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3092\u9078\u629e\u3057\u307e\u3057\u305f\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/093cf55368a7ffd3e43ffa3804391441.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24874\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/093cf55368a7ffd3e43ffa3804391441.png\" alt=\"\" width=\"748\" height=\"319\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/093cf55368a7ffd3e43ffa3804391441.png 748w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/093cf55368a7ffd3e43ffa3804391441-300x128.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/093cf55368a7ffd3e43ffa3804391441-728x310.png 728w\" sizes=\"auto, (max-width: 748px) 100vw, 748px\" \/><\/a><\/p>\n<p>\u540d\u524d\u7a7a\u9593\u306e\u540d\u79f0\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/03f358e362745fbe8bd25efb76d08cf8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24873\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/03f358e362745fbe8bd25efb76d08cf8.png\" alt=\"\" width=\"736\" height=\"456\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/03f358e362745fbe8bd25efb76d08cf8.png 736w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/03f358e362745fbe8bd25efb76d08cf8-300x186.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/03f358e362745fbe8bd25efb76d08cf8-728x451.png 728w\" sizes=\"auto, (max-width: 736px) 100vw, 736px\" \/><\/a><\/p>\n<p>\u30ef\u30fc\u30af\u30b0\u30eb\u30fc\u30d7\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<br \/>\n\u30ef\u30fc\u30af\u30b0\u30eb\u30fc\u30d7\u306e\u540d\u524d\u3092\u5165\u529b\u3057\u3001RPU\u5bb9\u91cf\u306f\u4e00\u756a\u5c0f\u3055\u3044 8 \u306b\u8a2d\u5b9a\u3057\u307e\u3057\u305f<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/fa3efbea674af5d026335c3fd142b113.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24875\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/fa3efbea674af5d026335c3fd142b113.png\" alt=\"\" width=\"708\" height=\"401\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/fa3efbea674af5d026335c3fd142b113.png 708w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/fa3efbea674af5d026335c3fd142b113-300x170.png 300w\" sizes=\"auto, (max-width: 708px) 100vw, 708px\" \/><\/a><\/p>\n<p>\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u3068\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3092\u8a2d\u5b9a<br \/>\n\u3053\u3053\u3067\u306f\u3001VPC\u3001\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u3001\u30b5\u30d6\u30cd\u30c3\u30c8(\uff13\u3064\u4ee5\u4e0a\u9078\u629e)\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/fa3efbea674af5d026335c3fd142b113.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24875\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/fa3efbea674af5d026335c3fd142b113.png\" alt=\"\" width=\"708\" height=\"401\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/fa3efbea674af5d026335c3fd142b113.png 708w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/fa3efbea674af5d026335c3fd142b113-300x170.png 300w\" sizes=\"auto, (max-width: 708px) 100vw, 708px\" \/><\/a><br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/b6dad46a740f2d60610d100aca176681-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24877\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/b6dad46a740f2d60610d100aca176681-1.png\" alt=\"\" width=\"733\" height=\"567\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/b6dad46a740f2d60610d100aca176681-1.png 733w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/b6dad46a740f2d60610d100aca176681-1-300x232.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/b6dad46a740f2d60610d100aca176681-1-728x563.png 728w\" sizes=\"auto, (max-width: 733px) 100vw, 733px\" \/><\/a><\/p>\n<ul>\n<li>\u540d\u524d\u7a7a\u9593\u3068\u30ef\u30fc\u30af\u30b0\u30eb\u30fc\u30d7\u3068\u3044\u3046\u6982\u5ff5\u304c\u3042\u308b<br \/>\n\u30fb\u540d\u524d\u7a7a\u9593\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068\u30e6\u30fc\u30b6\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<br \/>\n\u30fb\u30ef\u30fc\u30af\u30b0\u30eb\u30fc\u30d7\u306f\u3001\u30b3\u30f3\u30d4\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u30ea\u30bd\u30fc\u30b9\u306e\u96c6\u5408<\/li>\n<\/ul>\n<p>\u300c\u8a2d\u5b9a\u3092\u4fdd\u5b58\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001Redshift Serverless\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u304c\u958b\u59cb\u3055\u308c\u307e\u3059\u3002<br \/>\n\u79c1\u304c\u4f5c\u6210\u3057\u305f\u6642\u306f\u3001\u7d04\uff13\u5206\u4f4d\u3067\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002<\/p>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/36ca25ac1de5a460c84dae85c5bbf77e.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24878\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/36ca25ac1de5a460c84dae85c5bbf77e.png\" alt=\"\" width=\"752\" height=\"435\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/36ca25ac1de5a460c84dae85c5bbf77e.png 752w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/36ca25ac1de5a460c84dae85c5bbf77e-300x174.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/36ca25ac1de5a460c84dae85c5bbf77e-728x421.png 728w\" sizes=\"auto, (max-width: 752px) 100vw, 752px\" \/><\/a>\n<p>\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u5b8c\u4e86\uff01<br \/>\nRedshift Serverless\u304c\u4f5c\u6210\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n<p><a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/e4dd252d98ee6f560819961774ba782a.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-24879\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/e4dd252d98ee6f560819961774ba782a-1024x467.png\" alt=\"\" width=\"728\" height=\"332\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/e4dd252d98ee6f560819961774ba782a-1024x467.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/e4dd252d98ee6f560819961774ba782a-300x137.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/e4dd252d98ee6f560819961774ba782a-768x350.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/e4dd252d98ee6f560819961774ba782a-1536x701.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/e4dd252d98ee6f560819961774ba782a-728x332.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/e4dd252d98ee6f560819961774ba782a.png 1839w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/a><br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d757caecdbbff84af209b0a3c157799.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-24880\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d757caecdbbff84af209b0a3c157799-1024x342.png\" alt=\"\" width=\"728\" height=\"243\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d757caecdbbff84af209b0a3c157799-1024x342.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d757caecdbbff84af209b0a3c157799-300x100.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d757caecdbbff84af209b0a3c157799-768x257.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d757caecdbbff84af209b0a3c157799-1536x514.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d757caecdbbff84af209b0a3c157799-728x243.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d757caecdbbff84af209b0a3c157799.png 1800w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/a><br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/99a43cfa24c99d53d8a08cdb7a44303a.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-24881\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/99a43cfa24c99d53d8a08cdb7a44303a-1024x406.png\" alt=\"\" width=\"728\" height=\"289\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/99a43cfa24c99d53d8a08cdb7a44303a-1024x406.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/99a43cfa24c99d53d8a08cdb7a44303a-300x119.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/99a43cfa24c99d53d8a08cdb7a44303a-768x304.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/99a43cfa24c99d53d8a08cdb7a44303a-1536x609.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/99a43cfa24c99d53d8a08cdb7a44303a-728x288.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/99a43cfa24c99d53d8a08cdb7a44303a.png 1782w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/a><\/p>\n<h3>Redshift\u306bKinesis Data Streams\u7528\u30dd\u30ea\u30b7\u30fc\u3092\u4ed8\u4e0e<\/h3>\n<p>Redshift\u304cKinesis Data Streams\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u3001Redshift\u30af\u30e9\u30b9\u30bf\u30fc\u306b\u3001\u30dd\u30ea\u30b7\u30fc\u3092\u4ed8\u4e0e\u3057\u305fIAM\u30ed\u30fc\u30eb\u3092\u9069\u7528\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"lang:default decode:true \">{\n    \"Version\": \"2012-10-17\",\n    \"Statement\": [\n        {\n            \"Sid\": \"ReadStream\",\n            \"Effect\": \"Allow\",\n            \"Action\": [\n                \"kinesis:DescribeStreamSummary\",\n                \"kinesis:GetShardIterator\",\n                \"kinesis:GetRecords\",\n                \"kinesis:DescribeStream\"\n            ],\n            \"Resource\": \"arn:aws:kinesis:ap-northeast-1:123456789012:stream\/*\"\n        },\n        {\n            \"Sid\": \"ListStream\",\n            \"Effect\": \"Allow\",\n            \"Action\": [\n                \"kinesis:ListStreams\",\n                \"kinesis:ListShards\"\n            ],\n            \"Resource\": \"*\"\n        }\n    ]\n}<\/pre>\n<h3>Kinesis Data Stream\u3000\u2192\u3000RedShift\u3000\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u306e\u9023\u643a<\/h3>\n<h4>Kinesis\u7528\u5916\u90e8\u30b9\u30ad\u30fc\u30de\u306e\u4f5c\u6210<\/h4>\n<p><code>IAM_ROLE<\/code> \u306b\u306f\u3001\u4f5c\u6210\u3057\u305f IAM \u30ed\u30fc\u30eb\u306e ARN \u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"lang:default decode:true \">CREATE EXTERNAL SCHEMA schema_one\nFROM KINESIS\nIAM_ROLE 'arn:aws:iam::123456789012:role\/redshift-streaming-role'<\/pre>\n<h4>\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u3092\u4f5c\u6210<\/h4>\n<p>Kinesis Data Stream\u306e\u540d\u524d\u306b\u3000-\u3000\u3092\u5165\u308c\u3066\u3044\u308b\u5834\u5408\u3001\"\u3067\u56f2\u3080\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"lang:default decode:true\">CREATE MATERIALIZED VIEW \"mview_test-kinesis-datastream-shard-1\" AS\nSELECT\n  approximate_arrival_timestamp,\n  partition_key,\n  shard_id,\n  sequence_number,\n  JSON_PARSE(from_varbyte(kinesis_data, 'utf-8')) as Data,\n  refresh_time\nFROM\n  schema_one.\"test-kinesis-datastream-shard-1\"<\/pre>\n<p>\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u3068\u306f\uff1f<br \/>\n\u901a\u5e38\u306e\u30d3\u30e5\u30fc\u306f\u3001\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u305f\u6642\u306b\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066\u304d\u307e\u3059\u304c\u3001\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u306f\u3001\u30af\u30a8\u30ea\u7d50\u679c\u3092\u3042\u3089\u304b\u3058\u3081\u8a08\u7b97\u3057\u3001\u305d\u306e\u7d50\u679c\u3092\u4fdd\u5b58\u3057\u3066\u304a\u304f\u3053\u3068\u304c\u51fa\u6765\u308b\u30d3\u30e5\u30fc\u306b\u306a\u308a\u307e\u3059\u3002<br \/>\n\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u52b9\u7387\u7684\u306b\u51e6\u7406\u3057\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306b\u7d50\u679c\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<br \/>\n\u3053\u308c\u306b\u3088\u308a\u3001\u5927\u898f\u6a21\u306a\u30c7\u30fc\u30bf\u5206\u6790\u3084\u30cb\u30a2\u30ea\u30a2\u30eb\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u304c\u5fc5\u8981\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u958b\u767a\u304c\u5bb9\u6613\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<h4 id=\"toc-6\">\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30fb\u30d3\u30e5\u30fc\u306e\u66f4\u65b0<\/h4>\n<p>\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u306f\u4e8b\u524d\u306b\u30af\u30a8\u30ea\u7d50\u679c\u3092\u4f5c\u6210\u3057\u3066\u304a\u304f\u306e\u3067\u3001\u5b9a\u671f\u7684\u306b\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002<br \/>\n\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u3059\u308b\u3053\u3068\u3067\u3001\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u3082\u6700\u65b0\u306e\u72b6\u614b\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"lang:default decode:true \">REFRESH MATERIALIZED VIEW \"mview_test-kinesis-datastream-shard-1\"<\/pre>\n<h4>\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30fb\u30d3\u30e5\u30fc\u306e\u53c2\u7167<\/h4>\n<p>SELECT\u6587\u3067\u53c2\u7167\u304c\u51fa\u6765\u307e\u3059\u3002<\/p>\n<pre class=\"lang:default decode:true\">select *\nfrom \"mview_test-kinesis-datastream-shard-1\"<\/pre>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/90de2b91bf65f7aeac7377fe66d190fb.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-25001\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/90de2b91bf65f7aeac7377fe66d190fb-1024x408.png\" alt=\"\" width=\"728\" height=\"290\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/90de2b91bf65f7aeac7377fe66d190fb-1024x408.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/90de2b91bf65f7aeac7377fe66d190fb-300x120.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/90de2b91bf65f7aeac7377fe66d190fb-768x306.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/90de2b91bf65f7aeac7377fe66d190fb-728x290.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/90de2b91bf65f7aeac7377fe66d190fb.png 1036w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/a>\n<p>Kinesis Data Streams\u306e\u30c7\u30fc\u30bf\u304c\u53c2\u7167\u51fa\u6765\u307e\u3057\u305f\u3002<\/p>\n<p>\u4eca\u56de\u306e\u691c\u8a3c\u3067\u4f7f\u7528\u3057\u305f\u3082\u306e<\/p>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d7b612cae5d24e6898a222d45cb8c74.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-25005\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d7b612cae5d24e6898a222d45cb8c74-1024x500.png\" alt=\"\" width=\"728\" height=\"355\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d7b612cae5d24e6898a222d45cb8c74-1024x500.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d7b612cae5d24e6898a222d45cb8c74-300x147.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d7b612cae5d24e6898a222d45cb8c74-768x375.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d7b612cae5d24e6898a222d45cb8c74-728x356.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/1d7b612cae5d24e6898a222d45cb8c74.png 1465w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/a>\n<p>Kinesis Data Streams\u306b\u30c7\u30fc\u30bf\u306e\u6295\u5165\u306f\u3001<a title=\"KPL\u3092\u4f7f\u3063\u3066JSON\u3092\u6295\u3052\u308b\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\" href=\"https:\/\/docs.aws.amazon.com\/ja_jp\/streams\/latest\/dev\/tutorial-stock-data-kplkcl2.html\" target=\"_blank\" rel=\"noopener\">KPL\u3092\u4f7f\u3063\u3066JSON\u3092\u6295\u3052\u308b\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb<\/a>\u3092\u53c2\u8003\u306b\u3057\u3066\u30c7\u30fc\u30bf\u6295\u5165\u3057\u307e\u3057\u305f\u3002<\/p>\n<h3>\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u306e\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u3092\u5b9a\u671f\u5b9f\u884c<\/h3>\n<p>\u5b9a\u671f\u7684\u306b\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u3092\u3057\u305f\u3044\u3002\u306e\u3067\u3001EventBridge\u3067\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u306e\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u30af\u30a8\u30ea\u30fc\u3092\u5b9f\u884c\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/dd519df73228934e017c9cafcef277e5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-25015\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/dd519df73228934e017c9cafcef277e5.png\" alt=\"\" width=\"1015\" height=\"806\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/dd519df73228934e017c9cafcef277e5.png 1015w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/dd519df73228934e017c9cafcef277e5-300x238.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/dd519df73228934e017c9cafcef277e5-768x610.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/dd519df73228934e017c9cafcef277e5-728x578.png 728w\" sizes=\"auto, (max-width: 1015px) 100vw, 1015px\" \/><\/a>\n<pre class=\"lang:default decode:true \">{\n  \"WorkgroupName\": \"test-redshiftserverless-wg\",\n  \"Database\": \"dev\",\n  \"Sql\": \"REFRESH MATERIALIZED VIEW mview_test_kinesis_datastream_shard_1;\",\n  \"SecretArn\": \"arn:aws:secretsmanager:ap-northeast-1:123456789012:secret:redshift_test_sm-testest\"\n}\n\nsql:\u306b\u306f\u3001\u5b9f\u884c\u3059\u308b\u30af\u30a8\u30ea\u3000\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u306e\u66f4\u65b0\u306e\u30af\u30a8\u30ea\u3092\u6307\u5b9a\u3057\u307e\u3057\u305f<\/pre>\n<p>\u4eca\u56de\u306e\u691c\u8a3c\u3067\u306f\u3001\uff15\u5206\u9593\u9694\u3067\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u306e\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u304c\u884c\u3046\u69d8\u306b\u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u3057\u307e\u3057\u305f\u3002<\/p>\n<h3>\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u306e\u78ba\u8a8d<\/h3>\n<p>5\u5206\u9593\u9694\u3067\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u306e\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u30af\u30a8\u30ea\u30fc\u304c\u5b9f\u884c\u3055\u308c\u307e\u3057\u305f\uff01<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/574f48e3754d023780fe757f6e1795cb.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-25035\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/574f48e3754d023780fe757f6e1795cb-1024x619.png\" alt=\"\" width=\"728\" height=\"440\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/574f48e3754d023780fe757f6e1795cb-1024x619.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/574f48e3754d023780fe757f6e1795cb-300x181.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/574f48e3754d023780fe757f6e1795cb-768x464.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/574f48e3754d023780fe757f6e1795cb-728x440.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/574f48e3754d023780fe757f6e1795cb.png 1029w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/a><br \/>\n\u30c7\u30fc\u30bf\u3082\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u3055\u308c\u307e\u3057\u305f<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/437d1350c4ed9a4d4d60fa2ad9188598.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-25036\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/437d1350c4ed9a4d4d60fa2ad9188598.png\" alt=\"\" width=\"431\" height=\"325\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/437d1350c4ed9a4d4d60fa2ad9188598.png 431w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2023\/11\/437d1350c4ed9a4d4d60fa2ad9188598-300x226.png 300w\" sizes=\"auto, (max-width: 431px) 100vw, 431px\" \/><\/a><\/p>\n<h3>\u82e6\u52b4\u3057\u305f\u3068\u3053\u308d<\/h3>\n<p>\u4eca\u56de\u306e\u691c\u8a3c\u3067\u3001DataStream\u306bKPL\u3092\u4f7f\u3063\u3066\u30c7\u30fc\u30bf\u3092PUT\u3001DataStream\u306e\u30c7\u30fc\u30bf\u30d3\u30e5\u30fc\u30ef\u30fc\u3067\u6295\u5165\u3057\u305f\u30ec\u30b3\u30fc\u30c9\u306e\u78ba\u8a8d\u3092\u3057\u3066\u3044\u307e\u3057\u305f\u304c\u3001\u7fcc\u65e5\u78ba\u8a8d\u3059\u308b\u3068\u30ec\u30b3\u30fc\u30c9\u304c\u8868\u793a\u3055\u308c\u307e\u305b\u3093...\u30c7\u30fc\u30bf\u4fdd\u6301\u671f\u9593\u306f1\u65e5\u306a\u306e\u306b...<\/p>\n<p>\u4e8b\u8c61\u3068\u3057\u3066\u306f\u3053\u3093\u306a\u611f\u3058\u306e\u3053\u3068\u304c\u304a\u304d\u307e\u3057\u305f\u3002<\/p>\n<ul>\n<li>DataStream\u4f5c\u6210\u306e\u5f53\u65e5\u5185\u3000\uff1aPUT\u3057\u305f\u30ec\u30b3\u30fc\u30c9\u306f\u8868\u793a\u3055\u308c\u308b\u3002<\/li>\n<li>DataStream\u4f5c\u6210\u306e\u7fcc\u65e5\u4ee5\u964d\uff1a\u300c\u3053\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u306e\u30ec\u30b3\u30fc\u30c9\u306f\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u300d\u304c\u8868\u793a\u3055\u308c\u3001\u30ec\u30b3\u30fc\u30c9\u304c\u8868\u793a\u3055\u308c\u306a\u3044\u3002<\/li>\n<li>\u5f53\u65e5\u3001\u7fcc\u65e5\u5171\u306b\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0\u306e\u300cPutRecord \u306e\u6210\u529f\u300d\u3067\u3001\u30c7\u30fc\u30bf\u306ePUT\u6210\u529f\u306f\u78ba\u8a8d\u51fa\u6765\u308b\u3002<\/li>\n<li>\u4f5c\u6210\u3057\u305f\u30c7\u30fc\u30bf\u30b9\u30c8\u30ea\u30fc\u30e0\u306e\u30c7\u30fc\u30bf\u4fdd\u6301\u671f\u9593\u306f1\u65e5<\/li>\n<li>KPL\u304b\u3089\u30c7\u30fc\u30bf\u6295\u5165\u6210\u529f\u3001\u6295\u5165\u3057\u305f\u30c7\u30fc\u30bf\u3092RedShift\u304b\u3089\u30c7\u30fc\u30bf\u53d6\u5f97\u306f\u6210\u529f<\/li>\n<li>KinesisDataStream\u4e0a\u306b\u6295\u5165\u30c7\u30fc\u30bf\u304c\u6b8b\u3063\u3066\u3044\u308b\u3053\u3068\u306f\u78ba\u8a8d\u6e08\u307f<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>\u8272\u3005\u8abf\u3079\u305f\u308a\u3001\u8a73\u3057\u3044\u65b9\u306b\u76f8\u8ac7\u3057\u305f\u308a\u3001AWS\u306e\u30b5\u30dd\u30fc\u30c8\u306b\u805e\u3044\u305f\u308a\u3057\u3066\u3001\u6295\u5165\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3057\u305f\u3002\u7686\u3055\u3093\u306b\u611f\u8b1d\u3067\u3059\uff01<\/p>\n<p>\u3069\u3046\u3084\u3089\u3001\u30c7\u30fc\u30bf\u30b9\u30c8\u30ea\u30fc\u30e0\u4e0a\u306b\u3001\u30c7\u30fc\u30bf\u306e\u4f4d\u7f6e\u7684\u306a\u60c5\u5831\u304c\u3042\u3063\u3066\u3001\u30c7\u30fc\u30bf\u30d3\u30e5\u30fc\u30ef\u3067\u306f\u3001\u305d\u306e\u30c7\u30fc\u30bf\u4f4d\u7f6e\u3092\u6761\u4ef6\u306b\u30c7\u30fc\u30bf\u53d6\u5f97\u3059\u308b\u3088\u3046\u3067\u3059\u3002<\/p>\n<p>\u6700\u65b0\u306e\u5834\u5408<\/p>\n<ul>\n<li>\u30c7\u30fc\u30bf\u6295\u5165\u3059\u308b\u3068\u30c7\u30fc\u30bf\u6700\u65b0\u4f4d\u7f6e\u304c\u66f4\u65b0\u3055\u308c\u308b<\/li>\n<li>\u30c7\u30fc\u30bf\u30d3\u30e5\u30fc\u30ef\u3067\u306f\u3001\u305d\u306e\u6700\u65b0\u4f4d\u7f6e\u4ee5\u964d\u306e\u30c7\u30fc\u30bf\u304c\u8868\u793a\u3055\u308c\u308b<\/li>\n<li>\u30c7\u30fc\u30bf\u3092\u898b\u308b\u5834\u5408\u3001\u6295\u5165\u524d\u306b\u30c7\u30fc\u30bf\u30d3\u30e5\u30fc\u30ef\u30fc\u306b\u6700\u65b0\u4f4d\u7f6e\u3092\u899a\u3048\u3055\u305b\u3066\u304a\u304f<\/li>\n<li>\u30ec\u30b3\u30fc\u30c9\u6295\u5165\u3067\u6700\u65b0\u4f4d\u7f6e\u304c\u66f4\u65b0\u3055\u308c\u308b<\/li>\n<li>\u6b21\u306e\u30ec\u30b3\u30fc\u30c9\u3067\u899a\u3048\u3066\u3044\u305f\u30ec\u30b3\u30fc\u30c9\u306e\u6700\u65b0\u4f4d\u7f6e\u4ee5\u964d\u306e\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3059\u308b<\/li>\n<\/ul>\n<p>\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u306e\u5834\u5408<\/p>\n<ul>\n<li>\u30c7\u30fc\u30bf\u6295\u5165\u6642\u523b\u306e\u8fd1\u304f\u306e\u6642\u523b\u3092\u6761\u4ef6\u306b\u6307\u5b9a\u3059\u308b<\/li>\n<li>\u30c7\u30fc\u30bf\u53d6\u5f97\u7bc4\u56f2\u304c\u5e83\u3059\u304e\u308b\u3068\u4e00\u56de\u306e\u30c7\u30fc\u30bf\u53d6\u5f97\u3067\u62fe\u3048\u305a\u306b\u8868\u793a\u3055\u308c\u306a\u3044<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2 id=\"matome\">\u307e\u3068\u3081<\/h2>\n<p>\u4eca\u56de\u306f\u3001Amazon Redshift\u3067Amazon Kinesis Data Stream\u306e\u30b9\u30c8\u30ea\u30fc\u30e0\u30c7\u30fc\u30bf\u3092\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30fb\u30d3\u30e5\u30fc\u7d4c\u7531\u3067\u30cb\u30a2\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306b\u30a4\u30f3\u30b8\u30a7\u30b9\u30c8\u3059\u308b\u691c\u8a3c\u3092\u3057\u3066\u307f\u307e\u3057\u305f\u3002<br \/>\n\u3053\u306e\u6a5f\u80fd\u3092\u4f7f\u3046\u3068\u3001\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30fb\u30d3\u30e5\u30fc\u306e\u66f4\u65b0\u30ec\u30a4\u30c6\u30f3\u30b7\u30fc\u304c\u767a\u751f\u3059\u308b\u3082\u306e\u306e\u3001\u30cb\u30a2\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306bKinesis Data Streams\u306e\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30b8\u30a7\u30b9\u30c8\u3067\u304d\u308b\u3053\u3068\u304c\u78ba\u8a8d\u51fa\u6765\u307e\u3057\u305f\u3002<br \/>\n\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306b\u5206\u6790\u3057\u3001\u5206\u6790\u7d50\u679c\u3092\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u3092\u901a\u3058\u3066\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u7b49\u3001\u65e2\u306b\u3044\u308d\u3093\u306a\u3068\u3053\u308d\u3067\u6d3b\u7528\u3055\u308c\u3066\u3044\u308b\u3093\u3060\u308d\u3046\u306a\u3068\u611f\u3058\u307e\u3057\u305f\u3002<\/p>\n<p>Redshift\u3082Kinesis Data Stream\u3082\u521d\u3081\u3066\u3060\u3063\u305f\u306e\u3067\u3001\u89e6\u308a\u306a\u304c\u3089\u3044\u308d\u3044\u308d\u306a\u767a\u898b\u304c\u3042\u308a\u3001\u3061\u3087\u3073\u3063\u3068\u6210\u9577\u3057\u305f\u304b\u306a\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u306f\u3058\u3081\u306b \u30b9\u30c8\u30ea\u30fc\u30df\u30f3\u30b0\u30a4\u30f3\u30b8\u30a7\u30b9\u30c8\u3068\u306f\uff1f \u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u751f\u6210\u3055\u308c\u308b\u30c7\u30fc\u30bf\u3092\u7d99\u7d9a\u7684\u306b\u53ce\u96c6\u3057\u3001\u5206\u6790\u3084\u51e6\u7406\u306e\u305f\u3081\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3084\u30c7\u30fc\u30bf\u30a6\u30a7\u30a2\u30cf\u30a6\u30b9\u306b\u9001\u4fe1\u3059\u308b\u30d7\u30ed\u30bb\u30b9\u3002 \u3053\u308c\u306b\u3088\u308a\u3001\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u8fbc\u307f\u3068\u5206\u6790\u304c\u307b\u307c\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u884c&#8230;<\/p>\n","protected":false},"author":212,"featured_media":25057,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"ja","_original_post":"https:\/\/www.skyarch.net\/blog\/?p=24765","footnotes":""},"categories":[20,1267,1266],"tags":[],"class_list":{"0":"post-24765","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-aws","8":"category-kinesis","9":"category-redshift","10":"ja"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/24765","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/users\/212"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/comments?post=24765"}],"version-history":[{"count":31,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/24765\/revisions"}],"predecessor-version":[{"id":25076,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/24765\/revisions\/25076"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/media\/25057"}],"wp:attachment":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/media?parent=24765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/categories?post=24765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/tags?post=24765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}