DynamoDBへのデータ投入

DynamoDBへのデータ投入:

投稿はブログにまとめてます。System Engineer Blog


はじめに

DynamoDBにテーブルを作成した。今回はデータをインポートする。

とりあえずDynamoDBにCSVファイルを直接は入れられない。いろいろな入れ方があるけど、今回はCLIを使って1件1件PUTする。


PUTコマンド

aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "001"},"Name": {"S": "間宮 国男"},"Ruby": {"S": "マミヤ クニオ"},"Mail": {"S": "xfDvUc@sample.co.jp"},"Pass": {"S": "PklNlcnF"},"City": {"S": "愛知県"},"Sex": {"S": "男"},"Birthday": {"S": "1985/11/19"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "002"},"Name": {"S": "菊川 靖子"},"Ruby": {"S": "キクカワ ヤスコ"},"Mail": {"S": "VO_FsEz855@test.net"},"Pass": {"S": "LQcibfvm"},"City": {"S": "熊本県"},"Sex": {"S": "女"},"Birthday": {"S": "1971/09/16"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "003"},"Name": {"S": "神保 正平"},"Ruby": {"S": "ジンポ ショウヘイ"},"Mail": {"S": "ImYjX14nw_@test.jp"},"Pass": {"S": "uR7RkP0h"},"City": {"S": "山形県"},"Sex": {"S": "男"},"Birthday": {"S": "2007/12/03"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "004"},"Name": {"S": "中原 信行"},"Ruby": {"S": "ナカハラ ノブユキ"},"Mail": {"S": "Dgu2fVllY@example.co.jp"},"Pass": {"S": "rMeW4Z7R"},"City": {"S": "岩手県"},"Sex": {"S": "男"},"Birthday": {"S": "1994/12/01"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "005"},"Name": {"S": "神戸 可憐"},"Ruby": {"S": "カンベ カレン"},"Mail": {"S": "SgtudNj4@test.co.jp"},"Pass": {"S": "m0yKjQ3M"},"City": {"S": "山口県"},"Sex": {"S": "女"},"Birthday": {"S": "1988/03/04"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "006"},"Name": {"S": "及川 一雄"},"Ruby": {"S": "オイカワ カズオ"},"Mail": {"S": "xUx7GL7G6@sample.jp"},"Pass": {"S": "clP4Ium3"},"City": {"S": "福岡県"},"Sex": {"S": "男"},"Birthday": {"S": "2009/05/04"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "007"},"Name": {"S": "土谷 知治"},"Ruby": {"S": "トヤ トモハル"},"Mail": {"S": "cCl5b@test.org"},"Pass": {"S": "UCRDlC8l"},"City": {"S": "鳥取県"},"Sex": {"S": "男"},"Birthday": {"S": "2003/02/03"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "008"},"Name": {"S": "江上 正毅"},"Ruby": {"S": "エガミ マサキ"},"Mail": {"S": "PPafabMn@example.org"},"Pass": {"S": "TubUhoqq"},"City": {"S": "山形県"},"Sex": {"S": "男"},"Birthday": {"S": "1995/04/13"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "009"},"Name": {"S": "小山内 遥香"},"Ruby": {"S": "コヤマウチ ハルカ"},"Mail": {"S": "uhqG0leX@sample.net"},"Pass": {"S": "VPnvwaYl"},"City": {"S": "北海道"},"Sex": {"S": "女"},"Birthday": {"S": "1992/04/17"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "010"},"Name": {"S": "菅野 優衣"},"Ruby": {"S": "カンノ ユイ"},"Mail": {"S": "ilCVxCw4@sample.jp"},"Pass": {"S": "Fz_eve8v"},"City": {"S": "富山県"},"Sex": {"S": "女"},"Birthday": {"S": "1987/07/02"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "011"},"Name": {"S": "野崎 崇"},"Ruby": {"S": "ノザキ タカシ"},"Mail": {"S": "WSpdzPhB@sample.co.jp"},"Pass": {"S": "X2fibfDY"},"City": {"S": "佐賀県"},"Sex": {"S": "男"},"Birthday": {"S": "1961/07/23"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "012"},"Name": {"S": "梅原 信之"},"Ruby": {"S": "ウメハラ ノブユキ"},"Mail": {"S": "A7Itbe@test.co.jp"},"Pass": {"S": "ENvozYzo"},"City": {"S": "栃木県"},"Sex": {"S": "男"},"Birthday": {"S": "1995/12/06"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "013"},"Name": {"S": "馬渕 美結"},"Ruby": {"S": "マブチ ミユ"},"Mail": {"S": "yItmSwx1e@sample.jp"},"Pass": {"S": "mCDjaMqk"},"City": {"S": "奈良県"},"Sex": {"S": "女"},"Birthday": {"S": "1957/10/07"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "014"},"Name": {"S": "松藤 美樹"},"Ruby": {"S": "マツフジ ミキ"},"Mail": {"S": "IlQ94g0p@sample.jp"},"Pass": {"S": "KrWYTlSu"},"City": {"S": "茨城県"},"Sex": {"S": "女"},"Birthday": {"S": "1954/10/12"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "015"},"Name": {"S": "信田 昭司"},"Ruby": {"S": "シノダ ショウジ"},"Mail": {"S": "Ave1QE8Y@test.net"},"Pass": {"S": "APxhhuFt"},"City": {"S": "茨城県"},"Sex": {"S": "男"},"Birthday": {"S": "1963/03/16"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "016"},"Name": {"S": "野本 勇夫"},"Ruby": {"S": "ノモト イサオ"},"Mail": {"S": "uhztdkBhj@test.net"},"Pass": {"S": "eD4Iez7p"},"City": {"S": "広島県"},"Sex": {"S": "男"},"Birthday": {"S": "1993/04/10"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "017"},"Name": {"S": "吉本 豊"},"Ruby": {"S": "ヨシモト ユタカ"},"Mail": {"S": "b8XNUB@test.org"},"Pass": {"S": "ip49K1qJ"},"City": {"S": "千葉県"},"Sex": {"S": "男"},"Birthday": {"S": "1983/07/17"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "018"},"Name": {"S": "岩本 礼子"},"Ruby": {"S": "イワモト レイコ"},"Mail": {"S": "LvLhYT@sample.net"},"Pass": {"S": "kjNrnbLM"},"City": {"S": "愛媛県"},"Sex": {"S": "女"},"Birthday": {"S": "1969/08/10"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "019"},"Name": {"S": "泉田 杏菜"},"Ruby": {"S": "センダ アンナ"},"Mail": {"S": "JSaM0@example.jp"},"Pass": {"S": "WUuWC8ZD"},"City": {"S": "福井県"},"Sex": {"S": "女"},"Birthday": {"S": "1970/03/28"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "020"},"Name": {"S": "滝本 信孝"},"Ruby": {"S": "タキモト ノブタカ"},"Mail": {"S": "Ys9ww7MxEd@example.org"},"Pass": {"S": "IcNiuerR"},"City": {"S": "静岡県"},"Sex": {"S": "男"},"Birthday": {"S": "1992/01/10"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "021"},"Name": {"S": "八島 陽花"},"Ruby": {"S": "ハチジマ ハルカ"},"Mail": {"S": "q8wLbK2Iob@test.com"},"Pass": {"S": "KFrYDe7p"},"City": {"S": "宮城県"},"Sex": {"S": "女"},"Birthday": {"S": "1977/03/06"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "022"},"Name": {"S": "佃 朋香"},"Ruby": {"S": "ツクダ トモカ"},"Mail": {"S": "fWiiht@example.org"},"Pass": {"S": "xPyt36b4"},"City": {"S": "福岡県"},"Sex": {"S": "女"},"Birthday": {"S": "1984/06/05"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "023"},"Name": {"S": "寺嶋 敬三"},"Ruby": {"S": "テラシマ ケイゾウ"},"Mail": {"S": "pZkYB@test.net"},"Pass": {"S": "DTc_GlU7"},"City": {"S": "長野県"},"Sex": {"S": "男"},"Birthday": {"S": "1964/06/25"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "024"},"Name": {"S": "阪上 章平"},"Ruby": {"S": "サカウエ ショウヘイ"},"Mail": {"S": "SBrwBz9@example.jp"},"Pass": {"S": "r8Cvi_yv"},"City": {"S": "長野県"},"Sex": {"S": "男"},"Birthday": {"S": "1981/10/04"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "025"},"Name": {"S": "原 貢"},"Ruby": {"S": "ハラ ミツグ"},"Mail": {"S": "Lpt0t3j33s@sample.net"},"Pass": {"S": "LitSVrcA"},"City": {"S": "奈良県"},"Sex": {"S": "男"},"Birthday": {"S": "1974/08/19"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "026"},"Name": {"S": "飯田 小晴"},"Ruby": {"S": "イイダ コハル"},"Mail": {"S": "RBC3Cl@sample.co.jp"},"Pass": {"S": "JQ8iiirp"},"City": {"S": "滋賀県"},"Sex": {"S": "女"},"Birthday": {"S": "1988/09/24"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "027"},"Name": {"S": "小嶋 和也"},"Ruby": {"S": "オジマ カズヤ"},"Mail": {"S": "icSqaW@sample.net"},"Pass": {"S": "RS3ZyBhp"},"City": {"S": "神奈川県"},"Sex": {"S": "男"},"Birthday": {"S": "1971/09/19"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "028"},"Name": {"S": "本郷 百香"},"Ruby": {"S": "ホンゴウ モモカ"},"Mail": {"S": "oCDBr0e@sample.co.jp"},"Pass": {"S": "t9M6mmiT"},"City": {"S": "奈良県"},"Sex": {"S": "女"},"Birthday": {"S": "1978/11/21"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "029"},"Name": {"S": "伊勢 陽菜"},"Ruby": {"S": "イセ ハルナ"},"Mail": {"S": "N7eqXyZuPH@example.com"},"Pass": {"S": "R02Le6OU"},"City": {"S": "岡山県"},"Sex": {"S": "女"},"Birthday": {"S": "1988/03/16"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "030"},"Name": {"S": "高本 実桜"},"Ruby": {"S": "コウモト ミオ"},"Mail": {"S": "b1eISWLv@sample.jp"},"Pass": {"S": "hRnQlVF5"},"City": {"S": "奈良県"},"Sex": {"S": "女"},"Birthday": {"S": "1962/01/23"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "031"},"Name": {"S": "戸川 安弘"},"Ruby": {"S": "トガワ ヤスヒロ"},"Mail": {"S": "dOmf_@test.com"},"Pass": {"S": "C3oCnuaK"},"City": {"S": "静岡県"},"Sex": {"S": "男"},"Birthday": {"S": "1955/05/03"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "032"},"Name": {"S": "下野 浩寿"},"Ruby": {"S": "カバタ ヒロヒサ"},"Mail": {"S": "md98jVZz@example.jp"},"Pass": {"S": "b3ujawBu"},"City": {"S": "京都府"},"Sex": {"S": "男"},"Birthday": {"S": "1996/02/15"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "033"},"Name": {"S": "高嶋 昌利"},"Ruby": {"S": "タカシマ マサトシ"},"Mail": {"S": "cBPWa@sample.com"},"Pass": {"S": "mvunPm2L"},"City": {"S": "京都府"},"Sex": {"S": "男"},"Birthday": {"S": "1975/01/27"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "034"},"Name": {"S": "岩元 篤"},"Ruby": {"S": "イワモト アツシ"},"Mail": {"S": "tMGemJgi@test.co.jp"},"Pass": {"S": "vkwzVIpf"},"City": {"S": "岐阜県"},"Sex": {"S": "男"},"Birthday": {"S": "1996/04/12"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "035"},"Name": {"S": "前 仁"},"Ruby": {"S": "マエ ヒトシ"},"Mail": {"S": "oLEICtDR2I@sample.co.jp"},"Pass": {"S": "mC3i4Ig5"},"City": {"S": "群馬県"},"Sex": {"S": "男"},"Birthday": {"S": "1973/09/26"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "036"},"Name": {"S": "塚越 真樹"},"Ruby": {"S": "ツカゴシ マキ"},"Mail": {"S": "CDES4K8@example.jp"},"Pass": {"S": "bl1TOY47"},"City": {"S": "奈良県"},"Sex": {"S": "女"},"Birthday": {"S": "1968/12/19"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "037"},"Name": {"S": "末永 仁"},"Ruby": {"S": "マツエ ヒトシ"},"Mail": {"S": "au52Vm@example.jp"},"Pass": {"S": "n0WEMrP8"},"City": {"S": "熊本県"},"Sex": {"S": "男"},"Birthday": {"S": "1991/04/09"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "038"},"Name": {"S": "奈良 季衣"},"Ruby": {"S": "ナラ トシエ"},"Mail": {"S": "DCq_H3a@test.org"},"Pass": {"S": "tFRmnFNt"},"City": {"S": "秋田県"},"Sex": {"S": "女"},"Birthday": {"S": "1988/10/23"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "039"},"Name": {"S": "長島 絢香"},"Ruby": {"S": "ナガシマ アヤカ"},"Mail": {"S": "ABwH9m@test.jp"},"Pass": {"S": "iMDMoN0v"},"City": {"S": "長崎県"},"Sex": {"S": "女"},"Birthday": {"S": "1974/09/20"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "040"},"Name": {"S": "若狭 哲朗"},"Ruby": {"S": "ワカセ テツロウ"},"Mail": {"S": "fLAQckZ@sample.jp"},"Pass": {"S": "JpZned9G"},"City": {"S": "兵庫県"},"Sex": {"S": "男"},"Birthday": {"S": "1989/03/20"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "041"},"Name": {"S": "吉沢 一二三"},"Ruby": {"S": "ヨシザワ ヒフミ"},"Mail": {"S": "F2KWFDyP@example.com"},"Pass": {"S": "XMRvMbm2"},"City": {"S": "北海道"},"Sex": {"S": "女"},"Birthday": {"S": "1994/11/26"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "042"},"Name": {"S": "神保 文子"},"Ruby": {"S": "ジンポ アヤコ"},"Mail": {"S": "dT0ZEZ@sample.com"},"Pass": {"S": "S_ID9hkt"},"City": {"S": "京都府"},"Sex": {"S": "女"},"Birthday": {"S": "1977/02/11"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "043"},"Name": {"S": "小野塚 昌嗣"},"Ruby": {"S": "オノヅカ マサシ"},"Mail": {"S": "nRVvH4Q@test.org"},"Pass": {"S": "J5xCaW6h"},"City": {"S": "鹿児島県"},"Sex": {"S": "男"},"Birthday": {"S": "2006/08/21"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "044"},"Name": {"S": "日比 杏菜"},"Ruby": {"S": "ヒビ アンナ"},"Mail": {"S": "OYI1VTvi@test.net"},"Pass": {"S": "HRy5be86"},"City": {"S": "兵庫県"},"Sex": {"S": "女"},"Birthday": {"S": "1980/03/25"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "045"},"Name": {"S": "津島 幸三"},"Ruby": {"S": "ツシマ コウゾウ"},"Mail": {"S": "Q4yxKry6@example.net"},"Pass": {"S": "leBlEKEo"},"City": {"S": "宮城県"},"Sex": {"S": "男"},"Birthday": {"S": "2008/03/10"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "046"},"Name": {"S": "坂東 心愛"},"Ruby": {"S": "バンドウ ココア"},"Mail": {"S": "tmoU8bMQE@example.co.jp"},"Pass": {"S": "TZkNt3va"},"City": {"S": "山梨県"},"Sex": {"S": "女"},"Birthday": {"S": "1979/05/17"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "047"},"Name": {"S": "布施 岩夫"},"Ruby": {"S": "フセ イワオ"},"Mail": {"S": "G86u_iZ7H@example.com"},"Pass": {"S": "JWuv7e5Q"},"City": {"S": "兵庫県"},"Sex": {"S": "男"},"Birthday": {"S": "1996/11/04"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "048"},"Name": {"S": "樋渡 祥治"},"Ruby": {"S": "ヒワタシ ショウジ"},"Mail": {"S": "FMCldCUYFJ@sample.com"},"Pass": {"S": "SBnZWnv9"},"City": {"S": "大分県"},"Sex": {"S": "男"},"Birthday": {"S": "1982/01/02"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "049"},"Name": {"S": "芝田 理香"},"Ruby": {"S": "シバタ リカ"},"Mail": {"S": "FTq4Kl7y@example.net"},"Pass": {"S": "R6guMJfH"},"City": {"S": "佐賀県"},"Sex": {"S": "女"},"Birthday": {"S": "1996/12/07"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "050"},"Name": {"S": "矢田 幸次"},"Ruby": {"S": "ヤダ コウジ"},"Mail": {"S": "BK2QXSSJl@test.jp"},"Pass": {"S": "BAwG1qhB"},"City": {"S": "群馬県"},"Sex": {"S": "男"},"Birthday": {"S": "1987/09/06"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "051"},"Name": {"S": "進藤 陳雄"},"Ruby": {"S": "シンドウ ノブオ"},"Mail": {"S": "XaaCzP@sample.jp"},"Pass": {"S": "BtwnHR4v"},"City": {"S": "秋田県"},"Sex": {"S": "男"},"Birthday": {"S": "1977/08/06"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "052"},"Name": {"S": "吉元 里咲"},"Ruby": {"S": "ヨシモト リサ"},"Mail": {"S": "NgH0yK_V2@example.net"},"Pass": {"S": "RogOWUpq"},"City": {"S": "栃木県"},"Sex": {"S": "女"},"Birthday": {"S": "1986/03/21"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "053"},"Name": {"S": "浦川 晃子"},"Ruby": {"S": "ウラカワ アキコ"},"Mail": {"S": "oKlgLKCgr@example.co.jp"},"Pass": {"S": "ibsZxG5c"},"City": {"S": "長野県"},"Sex": {"S": "女"},"Birthday": {"S": "1990/06/09"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "054"},"Name": {"S": "曾根 智子"},"Ruby": {"S": "ソネ トモコ"},"Mail": {"S": "kTab4mk@sample.net"},"Pass": {"S": "tNlrxZ0c"},"City": {"S": "愛媛県"},"Sex": {"S": "女"},"Birthday": {"S": "1985/09/09"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "055"},"Name": {"S": "守屋 里佳"},"Ruby": {"S": "モリヤ リカ"},"Mail": {"S": "W56Foch@example.jp"},"Pass": {"S": "LHVeiHrS"},"City": {"S": "神奈川県"},"Sex": {"S": "女"},"Birthday": {"S": "1976/06/09"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "056"},"Name": {"S": "福士 華絵"},"Ruby": {"S": "フクシ カエ"},"Mail": {"S": "sxIRN@example.com"},"Pass": {"S": "AzpDlRja"},"City": {"S": "長崎県"},"Sex": {"S": "女"},"Birthday": {"S": "2000/02/19"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "057"},"Name": {"S": "熊木 光正"},"Ruby": {"S": "クマキ ミツマサ"},"Mail": {"S": "O7ihpMQZ@sample.jp"},"Pass": {"S": "x4kNeBFI"},"City": {"S": "熊本県"},"Sex": {"S": "男"},"Birthday": {"S": "2002/01/06"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "058"},"Name": {"S": "助川 穂香"},"Ruby": {"S": "スケガワ ホノカ"},"Mail": {"S": "dhG7lwk@sample.org"},"Pass": {"S": "Fa1jEzaO"},"City": {"S": "富山県"},"Sex": {"S": "女"},"Birthday": {"S": "2003/08/16"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "059"},"Name": {"S": "鶴岡 真美"},"Ruby": {"S": "ツルオカ マミ"},"Mail": {"S": "oX3QhlT@sample.org"},"Pass": {"S": "N9hcIRpC"},"City": {"S": "鳥取県"},"Sex": {"S": "女"},"Birthday": {"S": "2004/03/19"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "060"},"Name": {"S": "宮本 正昭"},"Ruby": {"S": "ミヤモト マサアキ"},"Mail": {"S": "esSH2JsfrC@test.com"},"Pass": {"S": "un37eLjJ"},"City": {"S": "高知県"},"Sex": {"S": "男"},"Birthday": {"S": "1965/02/19"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "061"},"Name": {"S": "船田 花凛"},"Ruby": {"S": "フナダ カリン"},"Mail": {"S": "orrUl@sample.co.jp"},"Pass": {"S": "oPnBlTgc"},"City": {"S": "北海道"},"Sex": {"S": "女"},"Birthday": {"S": "1976/02/17"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "062"},"Name": {"S": "三野 美樹"},"Ruby": {"S": "サンノ ミキ"},"Mail": {"S": "bNP7G@example.net"},"Pass": {"S": "fSE3TSCG"},"City": {"S": "鳥取県"},"Sex": {"S": "女"},"Birthday": {"S": "1961/03/11"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "063"},"Name": {"S": "赤沢 朋花"},"Ruby": {"S": "アカザワ トモカ"},"Mail": {"S": "jGwId59X5@example.jp"},"Pass": {"S": "xDMgdeyH"},"City": {"S": "宮崎県"},"Sex": {"S": "女"},"Birthday": {"S": "2012/05/22"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "064"},"Name": {"S": "落合 拓哉"},"Ruby": {"S": "オチアイ タクヤ"},"Mail": {"S": "EZa4_gJf@example.net"},"Pass": {"S": "dmNS_E1j"},"City": {"S": "大分県"},"Sex": {"S": "男"},"Birthday": {"S": "1984/07/03"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "065"},"Name": {"S": "下地 栄三"},"Ruby": {"S": "シタジ エイゾウ"},"Mail": {"S": "rNUPsfs8Vv@example.com"},"Pass": {"S": "BifeO1Zr"},"City": {"S": "埼玉県"},"Sex": {"S": "男"},"Birthday": {"S": "2008/10/18"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "066"},"Name": {"S": "秋本 幸作"},"Ruby": {"S": "アキモト コウサク"},"Mail": {"S": "lNpUktt@example.org"},"Pass": {"S": "Kt7ptUSn"},"City": {"S": "埼玉県"},"Sex": {"S": "男"},"Birthday": {"S": "1979/02/01"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "067"},"Name": {"S": "片岡 百恵"},"Ruby": {"S": "カタオカ モモエ"},"Mail": {"S": "iM80AgzDLb@example.co.jp"},"Pass": {"S": "QT_2KDVI"},"City": {"S": "青森県"},"Sex": {"S": "女"},"Birthday": {"S": "1997/04/22"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "068"},"Name": {"S": "竹山 仁一"},"Ruby": {"S": "タケヤマ ジンイチ"},"Mail": {"S": "Vc_cvuklq@example.net"},"Pass": {"S": "eFDftHUW"},"City": {"S": "岩手県"},"Sex": {"S": "男"},"Birthday": {"S": "1987/04/25"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "069"},"Name": {"S": "沖 知里"},"Ruby": {"S": "オキ チサト"},"Mail": {"S": "c1NxjdyE@test.jp"},"Pass": {"S": "LzDG80j7"},"City": {"S": "岩手県"},"Sex": {"S": "女"},"Birthday": {"S": "1986/05/15"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "070"},"Name": {"S": "船木 秀明"},"Ruby": {"S": "フナキ ヒデアキ"},"Mail": {"S": "fO37Ma@sample.co.jp"},"Pass": {"S": "yhGKQTQb"},"City": {"S": "群馬県"},"Sex": {"S": "男"},"Birthday": {"S": "1985/08/05"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "071"},"Name": {"S": "高久 一行"},"Ruby": {"S": "タカク カズユキ"},"Mail": {"S": "oacuYbt@test.com"},"Pass": {"S": "JyNsZzEz"},"City": {"S": "佐賀県"},"Sex": {"S": "男"},"Birthday": {"S": "1994/01/05"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "072"},"Name": {"S": "泉谷 光"},"Ruby": {"S": "イズミタニ アキラ"},"Mail": {"S": "Uwz2Ai@sample.com"},"Pass": {"S": "t6eUbVpW"},"City": {"S": "富山県"},"Sex": {"S": "男"},"Birthday": {"S": "1988/08/14"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "073"},"Name": {"S": "野崎 保雄"},"Ruby": {"S": "ノザキ ヤスオ"},"Mail": {"S": "YRyOuZ@sample.net"},"Pass": {"S": "kUAVgBge"},"City": {"S": "徳島県"},"Sex": {"S": "男"},"Birthday": {"S": "1977/02/01"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "074"},"Name": {"S": "浜野 奈菜"},"Ruby": {"S": "ハマノ ナナ"},"Mail": {"S": "QvJjJJ7AOA@test.jp"},"Pass": {"S": "QWZkkKq7"},"City": {"S": "広島県"},"Sex": {"S": "女"},"Birthday": {"S": "1990/02/20"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "075"},"Name": {"S": "福富 恵一"},"Ruby": {"S": "フクトミ ケイイチ"},"Mail": {"S": "AxVinGMXa@example.co.jp"},"Pass": {"S": "lJWx5Zo5"},"City": {"S": "熊本県"},"Sex": {"S": "男"},"Birthday": {"S": "1978/11/23"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "076"},"Name": {"S": "黒岩 莉歩"},"Ruby": {"S": "クロイワ リホ"},"Mail": {"S": "cR_NoQRaI@example.co.jp"},"Pass": {"S": "JxeGjpdw"},"City": {"S": "大阪府"},"Sex": {"S": "女"},"Birthday": {"S": "2007/07/10"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "077"},"Name": {"S": "堀部 靖子"},"Ruby": {"S": "ホリベ ヤスコ"},"Mail": {"S": "SuKk8@sample.jp"},"Pass": {"S": "GX4mdH_s"},"City": {"S": "島根県"},"Sex": {"S": "女"},"Birthday": {"S": "1977/06/09"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "078"},"Name": {"S": "乾 宏行"},"Ruby": {"S": "イヌイ ヒロユキ"},"Mail": {"S": "SNwll@sample.com"},"Pass": {"S": "E8tzHifa"},"City": {"S": "宮城県"},"Sex": {"S": "男"},"Birthday": {"S": "1999/09/10"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "079"},"Name": {"S": "春日 登"},"Ruby": {"S": "カスガ ノボル"},"Mail": {"S": "lzsrT@example.net"},"Pass": {"S": "gBFG8dek"},"City": {"S": "鳥取県"},"Sex": {"S": "男"},"Birthday": {"S": "1972/08/06"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "080"},"Name": {"S": "金山 天音"},"Ruby": {"S": "カナヤマ アマネ"},"Mail": {"S": "eLNgL8F7d@test.org"},"Pass": {"S": "RpLPZTY5"},"City": {"S": "兵庫県"},"Sex": {"S": "女"},"Birthday": {"S": "2001/11/22"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "081"},"Name": {"S": "河野 晶"},"Ruby": {"S": "コウノ アキラ"},"Mail": {"S": "E6i8aNPv@sample.net"},"Pass": {"S": "Rm2Jsf2D"},"City": {"S": "福島県"},"Sex": {"S": "男"},"Birthday": {"S": "1957/12/04"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "082"},"Name": {"S": "大槻 棟上"},"Ruby": {"S": "オオツキ トウジョウ"},"Mail": {"S": "ER5EgCxIzS@sample.jp"},"Pass": {"S": "GWlztiq_"},"City": {"S": "埼玉県"},"Sex": {"S": "女"},"Birthday": {"S": "1981/06/18"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "083"},"Name": {"S": "奥井 幹雄"},"Ruby": {"S": "オクイ ミキオ"},"Mail": {"S": "o4gKtAr1DI@sample.net"},"Pass": {"S": "L58CXV61"},"City": {"S": "愛知県"},"Sex": {"S": "男"},"Birthday": {"S": "1995/12/21"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "084"},"Name": {"S": "山西 奈保美"},"Ruby": {"S": "ヤマニシ ナホミ"},"Mail": {"S": "LiJPnotPCm@sample.com"},"Pass": {"S": "KVR_cyoj"},"City": {"S": "岐阜県"},"Sex": {"S": "女"},"Birthday": {"S": "1977/04/09"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "085"},"Name": {"S": "猪野 幸作"},"Ruby": {"S": "イノ コウサク"},"Mail": {"S": "QpXak@sample.co.jp"},"Pass": {"S": "cDmpWxhU"},"City": {"S": "鳥取県"},"Sex": {"S": "男"},"Birthday": {"S": "1979/08/09"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "086"},"Name": {"S": "中瀬 美沙"},"Ruby": {"S": "ナカセ ミサ"},"Mail": {"S": "Indudx@test.net"},"Pass": {"S": "X0Z4DgCX"},"City": {"S": "山口県"},"Sex": {"S": "女"},"Birthday": {"S": "1982/08/14"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "087"},"Name": {"S": "野呂 健夫"},"Ruby": {"S": "ノロ タケオ"},"Mail": {"S": "Gie19i@example.jp"},"Pass": {"S": "nl315BPU"},"City": {"S": "佐賀県"},"Sex": {"S": "男"},"Birthday": {"S": "1970/03/16"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "088"},"Name": {"S": "浦川 比呂"},"Ruby": {"S": "ウラカワ ヒロ"},"Mail": {"S": "AuDSLTO7@test.co.jp"},"Pass": {"S": "WFFWEBVW"},"City": {"S": "長野県"},"Sex": {"S": "男"},"Birthday": {"S": "1969/10/07"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "089"},"Name": {"S": "小俣 依子"},"Ruby": {"S": "オマタ ヨリコ"},"Mail": {"S": "sluVxzXPym@test.co.jp"},"Pass": {"S": "SZPvkp4o"},"City": {"S": "栃木県"},"Sex": {"S": "女"},"Birthday": {"S": "2010/06/08"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "090"},"Name": {"S": "鹿島 瑞姫"},"Ruby": {"S": "カシマ ミズキ"},"Mail": {"S": "NjwKtWqVG@sample.org"},"Pass": {"S": "WzKYssWv"},"City": {"S": "長崎県"},"Sex": {"S": "女"},"Birthday": {"S": "1999/11/14"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "091"},"Name": {"S": "副島 善太郎"},"Ruby": {"S": "ソエジマ ゼンタロウ"},"Mail": {"S": "cdoo6P59@sample.org"},"Pass": {"S": "TolZdMIx"},"City": {"S": "山口県"},"Sex": {"S": "男"},"Birthday": {"S": "1991/04/10"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "092"},"Name": {"S": "黒須 瑞稀"},"Ruby": {"S": "クロス ミズキ"},"Mail": {"S": "E73_n@example.co.jp"},"Pass": {"S": "VCVNWGKh"},"City": {"S": "徳島県"},"Sex": {"S": "女"},"Birthday": {"S": "1965/09/13"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "093"},"Name": {"S": "長山 幸彦"},"Ruby": {"S": "チョウヤマ ユキヒコ"},"Mail": {"S": "tXpvD45JdK@sample.co.jp"},"Pass": {"S": "Ldo7F6xC"},"City": {"S": "高知県"},"Sex": {"S": "男"},"Birthday": {"S": "2003/12/24"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "094"},"Name": {"S": "村中 江介"},"Ruby": {"S": "ムラナカ コウスケ"},"Mail": {"S": "G_9WQ56@sample.org"},"Pass": {"S": "OlcYMBjo"},"City": {"S": "愛媛県"},"Sex": {"S": "男"},"Birthday": {"S": "1961/06/26"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "095"},"Name": {"S": "住吉 小梅"},"Ruby": {"S": "スミヨシ コウメ"},"Mail": {"S": "B78Ly4UfY@sample.net"},"Pass": {"S": "mlVWivFG"},"City": {"S": "兵庫県"},"Sex": {"S": "女"},"Birthday": {"S": "1952/03/22"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "096"},"Name": {"S": "高田 昭男"},"Ruby": {"S": "タカダ アキオ"},"Mail": {"S": "rktXoHAZpe@test.com"},"Pass": {"S": "eZWy3BE2"},"City": {"S": "高知県"},"Sex": {"S": "男"},"Birthday": {"S": "1976/05/10"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "097"},"Name": {"S": "松元 満"},"Ruby": {"S": "マツモト ミツル"},"Mail": {"S": "dFbHY@sample.net"},"Pass": {"S": "N81EEivD"},"City": {"S": "宮崎県"},"Sex": {"S": "男"},"Birthday": {"S": "1974/06/07"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "098"},"Name": {"S": "米原 愛菜"},"Ruby": {"S": "コメハラ アイナ"},"Mail": {"S": "h7_gcGkr@sample.com"},"Pass": {"S": "eMUy_DKl"},"City": {"S": "徳島県"},"Sex": {"S": "女"},"Birthday": {"S": "2006/12/22"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "099"},"Name": {"S": "日野 隆三"},"Ruby": {"S": "ヒノ リュウゾウ"},"Mail": {"S": "n__sOi@sample.com"},"Pass": {"S": "ECZrZ4z3"},"City": {"S": "京都府"},"Sex": {"S": "男"},"Birthday": {"S": "2000/08/30"}}' 
aws dynamodb put-item --table-name user_tbl --item '{"Id": {"S": "100"},"Name": {"S": "日比 俊治"},"Ruby": {"S": "ヒビ トシハル"},"Mail": {"S": "MFMqmS@sample.com"},"Pass": {"S": "ay7wGAhd"},"City": {"S": "群馬県"},"Sex": {"S": "男"},"Birthday": {"S": "1980/09/01"}}' 
とりあえず全部データを突っ込めた。これでグローバルテーブルは使えない。(空にすればまた使えるけど。。。)



image.png



まとめ

データを作るのが思ったより面倒くさい。何かしら簡単な方法を検討したほうがいいなぁ。

コメント

このブログの人気の投稿

投稿時間:2021-06-17 05:05:34 RSSフィード2021-06-17 05:00 分まとめ(1274件)

投稿時間:2021-06-20 02:06:12 RSSフィード2021-06-20 02:00 分まとめ(3871件)

投稿時間:2024-02-12 22:08:06 RSSフィード2024-02-12 22:00分まとめ(7件)