投稿時間:2023-03-23 11:25:47 RSSフィード2023-03-23 11:00 分まとめ(30件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
ROBOT	ロボスタ	NVIDIAがアマゾンロボティクスの物流倉庫等のデジタルツイン事例を紹介「Omniverse Cloud」をMicrosoft Azureで提供へ	https://robotstart.info/2023/03/23/omniverse-cloud-microsoft-azure.html		2023-03-23 01:35:06
IT	ITmedia 総合記事一覧	[ITmedia Mobile] タフボディーの「Galaxy Xcover6 Pro」は業務用にも使えるプロ向けスマホ	https://www.itmedia.co.jp/mobile/articles/2303/23/news098.html	galaxyxcoverpro	2023-03-23 10:49:00
IT	ITmedia 総合記事一覧	[ITmedia ビジネスオンライン] 化粧品業界の「未来」はどうなるか	https://www.itmedia.co.jp/business/articles/2303/23/news097.html	itmedia	2023-03-23 10:43:00
IT	ITmedia 総合記事一覧	[ITmedia News] WBC優勝の号外配布で大混乱　スマホで読める「電子号外」へのシフト進むか	https://www.itmedia.co.jp/news/articles/2303/23/news094.html	itmedianewswbc	2023-03-23 10:38:00
IT	ITmedia 総合記事一覧	[ITmedia ビジネスオンライン] 卵不足の逆風下、モスバーガーが卵使用の「テリヤキバーガー」　独壇場なるか？	https://www.itmedia.co.jp/business/articles/2303/23/news089.html	itmedia	2023-03-23 10:21:00
IT	ITmedia 総合記事一覧	[ITmedia ビジネスオンライン] 岩手日報、侍ジャパン優勝号外を無料公開　“MVP男”大谷翔平選手の地元紙	https://www.itmedia.co.jp/business/articles/2303/22/news202.html	itmedia	2023-03-23 10:19:00
TECH	Techable（テッカブル）	ビジネス課題をAIで即解決！ChatGPTのAPIを搭載した「CalqWorks」β版公開	https://techable.jp/archives/200852	calqworks	2023-03-23 01:00:54
AWS	lambdaタグが付けられた新着投稿 - Qiita	【AWS】API Gateway→Lambda→AppSync→DynamoDBを実装したい ~ Amplifyを添えて ~ Part2	https://qiita.com/yoshi1007/items/491c3bb8e1bbbfd84ed8	amplify	2023-03-23 10:23:49
python	Pythonタグが付けられた新着投稿 - Qiita	新卒エンジニアが【Pythonエンジニアデータ分析試験】の模試を受けてみたら、、、	https://qiita.com/asukitt/items/ecd9d49d4f9ea7ac827c	通り	2023-03-23 10:32:58
js	JavaScriptタグが付けられた新着投稿 - Qiita	メソッドの命名は甘いものじゃない——二つの JavaScript プロポーザルが歩んだ道のり	https://qiita.com/graphemecluster/items/9e3d6ef8dc346e557961	ecmascript	2023-03-23 10:34:10
js	JavaScriptタグが付けられた新着投稿 - Qiita	JavaScriptにRustの良いところをちょい足ししてみた: match編	https://qiita.com/uzawa-sorich/items/cb70ffa14575adb7ae17	javascript	2023-03-23 10:24:08
Ruby	Rubyタグが付けられた新着投稿 - Qiita	Ruby randとshuffleを使って占いプログラムを作成	https://qiita.com/ta--i/items/7606d5d536a564ef17a7	rubyrand	2023-03-23 10:47:32
Ruby	Rubyタグが付けられた新着投稿 - Qiita	sumメソッドについて	https://qiita.com/ryuuya0921/items/874516a390877d7f85a7	配列	2023-03-23 10:24:50
GCP	gcpタグが付けられた新着投稿 - Qiita	Google DomainsでAレコードをAPI経由で自動設定する【グーグルドメイン】	https://qiita.com/logger/items/077b284f4c6d3154f85c	usernamepassworddomains	2023-03-23 10:29:23
Ruby	Railsタグが付けられた新着投稿 - Qiita	Ruby randとshuffleを使って占いプログラムを作成	https://qiita.com/ta--i/items/7606d5d536a564ef17a7	rubyrand	2023-03-23 10:47:32
Ruby	Railsタグが付けられた新着投稿 - Qiita	【Rails】投稿文章にURLが含まれていたら自動的にリンク化し、文章の改行もする	https://qiita.com/yato_minagumo/items/1d53382e40d909cd2647	httpsqiita	2023-03-23 10:37:55
技術ブログ	Developers.IO	複数部門をまたがる業務のプロセスを可視化し、議論の土台にする	https://dev.classmethod.jp/articles/process-map-and-conversation/	部門	2023-03-23 01:09:44
海外TECH	DEV Community	An ETL Job using AWS Glue Studio to inner join DynamoDB tables, Apply Queries and Store the result in S3	https://dev.to/aws-builders/an-etl-job-using-aws-glue-studio-to-inner-join-dynamodb-tables-apply-queries-and-store-the-result-in-s3-5gb6	An ETL Job using AWS Glue Studio to inner join DynamoDB tables Apply Queries and Store the result in S ETL JobsETL stands for extract transform and load And this is the most common paradigm for combining data from various systems into a single database data store or warehouse for legacy storage or analytics ExtractionExtraction is the process of retrieving data from one or more sources Following data retrieval ETL is to compute work that loads the data into a staging area and prepares it for the next phase TransformationTransformation is the process of mapping reformatting and other operations to prepare data for consumption LoadingLoading involves successfully inserting the transformed data into the target database data store or data warehouse All of this work is processed in what the business intelligent developers call an ETL job AWS GlueAWS Glue is the key service that integrates data over a data lake data warehouse and purpose built data stores which simplifies data movements from multiple sources AWS Glue StudioAWS Glue Studio is an easy to use graphical interface for creating running and monitoring AWS Glue extract transform and load ETL jobs Olive wants to purchase a finger ring with her birth stone The details of Birth stones and ring prices are stored in two DynamoDB tables Now We are going to create an ETL job using AWS Glue Studio which inner joins two DynamoDB tables Birthstone and RingsTable on condition RingsTable RingStoneName Birthstone Stone NameAfter that apply a Query on the result table to find the ring stone and its price matching to Olive s Birth Month and then save the result to the s bucket named gemstonejobresult We use git for the source code management so finally we are going to create a remote git repository on AWS Code Commit and push the job to the git repository PrerequisitesTwo tables created using AWS DynamoDB Service Birthstone RingsTable Recipe S Bucket to store the result gemstonejobresultA git repository on AWS Code commit gemstone job repositoryAn IAM role AWSGlueServiceRoledemo with permission to your Amazon S sources targets temporary directory scripts and any libraries used by the job Lets set up the Prerequisites first DynamoDB TablesHere I have created two Tables named Birthstone and Birthstone and some items to themMake sure to enable PITR on both the tablesThe Table schema details provided belowTable Data S Bucket for Storing the Query Result Navigate to S consoleClick Create Bucket button You will be navigated to bucket creation pageSpecify a unique name to the bucket Leave the rest of the fields to default values Scroll down and click create bucket buttonYou will be navigated back to bucket list page on S Console and the newly created bucket will be listed here A git repository on AWS Code commit AWS Code commitAWS CodeCommit is a fully managed source control service that makes it easy for companies to host secure and highly scalable private Git repositories CodeCommit eliminates the need to operate your own source control system or worry about scaling its infrastructure RepositoryIn CodeCommit the fundamental version control object is a repository It s where you keep your project s code and files safe It also keeps track of your project s history from the first commit to the most recent changes You can collaborate on a project by sharing your repository with other users Before you can push changes to a CodeCommit repository you must configure an IAM user in your Amazon Web Services account or set up access for federated access or temporary credentials DO NOT USE ROOT USERNavigate to code commit console Click Create Repository button to create a git repository for storing our code Specify the repository name I am naming it as gemstone job repository and click create repository buttonLets Create a Readme md file and commit it to the repository Click Create file buttonAdd some data to the file and save the file as ReadMe mdThe file will be saved to the main branch Specify the Author name Email address and commit message Though optional its a good practice to provide commit message Click the button commit changesBranches in git Branches can be used to develop new features save a specific version of your project from a specific commit and much more When you create your first commit in aws code commit console a default branch main is created for youNow we have created a repository on aws console made a first commit to it by saving a ReadMe file to the main branch IAM roleNavigate to IAM Console Click on Roles link on Left PaneClick Create Role button to create a roleSelect AWS Service as Trusted entity type Select glue option from Use cases for other services dropdownAdd the below permissions to the role and click Next buttonSpecify a role name AWSGlueServiceRoledemo and Click Create Role button Create an ETL job using AWS Glue Studio to inner join DynamoDB TablesNavigate to AWS Glue Studio from aws consoleClick Jobs from Left paneYou will be navigated to Jobs page where you can create ETL JobsBy default Visual with source and target option would be selectedSelect Source as DynamoDB and Target as Amazon S in Create job Click Create buttonAn untitled job with the source as DynamoDB and target as Amazon S will be created for you And You will be navigated to the page of untitled job where you will be able to edit the configuratonsVisual TabFirst You will be on the Visual tabCustomers can create data integration jobs using the Amazon Glue API from a JSON object that displays a visual step by step workflow thanks to the API offered by AWS Glue Clients can then work with these jobs using the visual editor in Amazon Glue Studio Now we are going to create a job which reads data from two dynamodb tables BirthStone table and Ring table We are going to inner join these two tables based on name attribute and apply a query to find birtstone suitable for Olive and its priceFirst we will add the required Source blocks Action blocks and Target BlocksStore the Query result in S bucketNodes Required Two DataSource DynamoDB RingsTable Birthstone Transfrom Join For applying inner join SQL Query For querying the result table Data target S BucketClick on the Source and add one more DynamoDB tableRemove the ApplyMapping Block if its already there since we don t need it for this job Click on the ApplyMapping Block and Click Remove From the Action Select Join and Add itFrom the Action Select SQL Query and Add itS bucket will be there on the flow as target leave it as it is Now Lets Configure the flowSource NodesClick on One of the Data Source DynamoDB nodes On the Right pane configure the node properties as shown in the picture belowSelect the option Choose the Dynamodb Table directly radio button for DynamoDB sourceSelect the Birthstone table from the Dropdown Make sure PITR is enabled for the Birth stone table if not the table will not be populated on the dropdown If you do not see the table in the dropdown Go to the Dynamodb service enable PITR for the Birthstone table and Ring Table Then Refresh this page to get the tables on this dropdown Click on the second DynamoTable Data source node On the Right pane configure the node properties as shown in the picture belowNow We have configured the Source Nodes successfullyAction Nodes Click on the Transform join node On the Right pane Click on the Node Properties TabSelect the two DynamoDB tables as Node ParentsClick on the Transform Tab Make sure Inner join is selected as Join Type Click Add Condition buttonSpecify the inner join condition as shown in the image belowClick on Transform SQL Query node On the Right pane Click on the Node Properties TabSelect Transform Check box from the Node Parents dropdown list You can see Join node getting selected Click on the Transform Tab to specify the query on the Inner joined TableAs You see here Inner Joined table is alised as myDataSourceNow Lets Write the SQL Query to generate the Birth Stone name and Price of the Birst stone matching to olive s Birth MonthOlive s Birth Month is December since she is born on a christmas day Lets Create a query to get the Birth Stone gem and its price matching to the month select RingStoneName Price from myDataSource where BirthMonth December limit Yes Now we have configured Transform nodes successfully Target NodeWe need to store the query result in the s bucket Click on the Data target S bucket nodeOn the Right pane Click on the Node Properties TabClick on Data Target Properies S TabConfigure it as shown in the below imageAs you see Format should be Parquet The bucket location should be selected from s so that a Parquet file with the result data will be saved on the S bucket once the job execution is completed successfullyAfter all the configurations The Visual Tab will be seen as below imageScript TabBased on the Job Configuration Python script will be generated on the Script tabJob detailsNow Navigate to Job details tab to specify the job detailsBy default Job name would be Untitled Specify a job name in the Name Field Specify a description as wellSelect the AWSGlueServiceRole demo which we already created as a part of prerequisitesLeave the remaining to default settings Click Save button to save the JobVersion Control TabNavigate to Version Control TabHere You need to do the git configurations Select AWS Code commit option for git service In the Repository Configuration section choose the git repository that we created in aws code commit Refer Prerequisites Choose the branch as mainClick Save button on the top rightClick the Actions Button Choose Push to repository optionThe job will be pushed to the repository and a JSON file will be saved on to the code repository Navigate to aws code commit and verify if files are saved on to the repository Executing the ETL Job and Verifying the result in S bucketOnce you have saved the job its time to Run the job Click the Run button on the Top Right pane You will be getting the following messageNavigate to Runs Tab to see the job statusOnce the Run status becomes succeeded Navigate to S Console and click on the gemstonejobresult bucketYou will be able to see the result saved as a parquet fileDownload the Parquet file and save the file locally by clicking the buttonOpen the website to read results from parquet fileNow You will be able to view the result Yaay We found it Olive needs to purchase a Turquoise ring and its price is And that was Olive s story Challenge TaskSet up an ETL job by following the above instructions Find out the month corresponding to the Birth stone which is priced highestPost a screenshot of the answer in comment section	2023-03-23 01:27:26
Apple	AppleInsider - Frontpage News	Unlock up to $700 off MacBook Pro laptops, plus $70 off AppleCare	https://appleinsider.com/articles/23/03/23/unlock-up-to-700-off-macbook-pro-laptops-plus-70-off-applecare?utm_medium=rss	Unlock up to off MacBook Pro laptops plus off AppleCareAppleInsider readers have exclusive access to unlock up to in discounts on MacBook Pro inch laptops equipped with the M Pro or M Max chip Save with blowout deals on MacBook ProTo activate the exclusive deals visit Adorama com and enter promo code APINSIDER during Step of checkout Detailed activation instructions can be found below and on this help page Read more	2023-03-23 01:54:11
海外科学	NYT > Science	Wyoming Judge Temporarily Blocks the State’s New Abortion Ban	https://www.nytimes.com/2023/03/22/health/wyoming-abortion-ban.html	Wyoming Judge Temporarily Blocks the State s New Abortion BanWyoming s Constitution guarantees a right to make individual health care decisions The new ban attempts to circumvent that right by declaring that abortion is not health care	2023-03-23 01:12:54
海外科学	NYT > Science	Centuries of Stargazing Leave Jesuit Names Written in the Heavens	https://www.nytimes.com/2023/03/22/world/europe/asteroid-names-jesuits.html	Centuries of Stargazing Leave Jesuit Names Written in the HeavensThe latest list of approved labels for asteroids includes nods to three more scholars of the order as well as a pope challenging the idea that science and religion make awkward partners	2023-03-23 01:42:42
金融	ニッセイ基礎研究所	山田哲人「聞き入っちゃってしまって・・・」－WBC日本代表選手の応援歌の歌詞の傾向	https://www.nli-research.co.jp/topics_detail1/id=74306?site=nli	前述した通り、多くの選手がその選手をイメージしたオリジナルの歌詞とメロディの応援歌を擁しており、その応援歌を聞くこともプロ野球観戦の醍醐味のひとつともいえるわけだが、各応援歌にはどのようなメッセージが込められているのだろうか。	2023-03-23 10:56:40
金融	日本銀行：RSS	時系列統計データ検索サイトのサービス停止について（4月15日（土）18時30分～19時）	http://www.boj.or.jp/statistics/outline/notice_2023/not230323a.htm	検索サイト	2023-03-23 11:00:00
海外ニュース	Japan Times latest articles	Tokyo gets on board the virtual YouTuber hype train	https://www.japantimes.co.jp/life/2023/03/23/digital/tokyo-tourism-vtubers/	Tokyo gets on board the virtual YouTuber hype trainThe local government s move to recruit Gawr Gura Mori Calliope and Miko Sakura to help promote tourism speaks to just how big the VTuber industry	2023-03-23 10:30:23
ニュース	BBC News - Home	Chris Mason: Boris Johnson's political future hangs in balance	https://www.bbc.co.uk/news/uk-politics-65047566?at_medium=RSS&at_campaign=KARANGA	editor	2023-03-23 01:02:51
ビジネス	ダイヤモンド・オンライン - 新着記事	【社説】FRBは難事を成し遂げられるか - WSJ発	https://diamond.jp/articles/-/319977	難事	2023-03-23 10:13:00
ビジネス	東洋経済オンライン	太宰治､予想以上に多い｢盗作疑惑｣の興味深い中身 ｢生れて､すみません｣の言葉も元ネタがある | 明日の仕事に役立つ 教養としての｢名著｣ | 東洋経済オンライン	https://toyokeizai.net/articles/-/661197?utm_source=rss&utm_medium=http&utm_campaign=link_back	東洋経済オンライン	2023-03-23 10:30:00
マーケティング	MarkeZine	アドビ、AIモデル「Adobe Firefly」発表　商業利用の安全性を考慮したコンテンツ生成が可能	http://markezine.jp/article/detail/41741	adobefirefly	2023-03-23 10:15:00
IT	週刊アスキー	質問！ドリンクバーでブレンド。コーラ×メロンソーダ、コーラ×カルピス……どれがおいしそう？	https://weekly.ascii.jp/elem/000/004/129/4129662/	質問	2023-03-23 10:20:00
IT	週刊アスキー	春だ！ すしだ！ 生放送ですしを回そう!! プラレール組み立て＆すし回しチャレンジ！ 金曜12時～アスキーグルメNEWS見てね	https://weekly.ascii.jp/elem/000/004/129/4129660/	youtube	2023-03-23 10:15:00