LoginSignup
1
1

More than 3 years have passed since last update.

DynamoDBへのデータ投入

Last updated at Posted at 2019-01-13

はじめに

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

まとめ

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

1
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1
1