投稿時間:2023-05-18 16:21:45 RSSフィード2023-05-18 16:00 分まとめ(31件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
フリーソフト	新着ソフトレビュー - Vector	ユーザーの声から新機能を搭載したインターネットラジオ再生録音ソフト「ネットラジオ録音 X2」	https://www.vector.co.jp/magazine/softnews/200417/n2004171.html?ref=rss	録音	2023-05-18 17:00:00
IT	ITmedia 総合記事一覧	[ITmedia ビジネスオンライン] アダストリア、メタバースファッションを発売　リアルで販売している服を3Dアバター化	https://www.itmedia.co.jp/business/articles/2305/18/news167.html	itmedia	2023-05-18 15:38:00
IT	ITmedia 総合記事一覧	[ITmedia ビジネスオンライン] ドミノ・ピザ、人気サイドメニュー「ジューシーからあげ」をリニューアル　これまでとの違いは？	https://www.itmedia.co.jp/business/articles/2305/18/news150.html	itmedia	2023-05-18 15:37:00
IT	ITmedia 総合記事一覧	[ITmedia Mobile] ゲオ、内部が見える透明構造のワイヤレスイヤフォン　最大5時間再生で2178円	https://www.itmedia.co.jp/mobile/articles/2305/18/news166.html	hidisc	2023-05-18 15:34:00
IT	ITmedia 総合記事一覧	[ITmedia PC USER] LGエレ、同社製モバイルノートのWi-Fi 6E対応状況を告知	https://www.itmedia.co.jp/pcuser/articles/2305/18/news163.html	itmediapcuserlg	2023-05-18 15:20:00
AWS	AWS Japan Blog	Bottlerocket を利用した Amazon EKS 上の Deployment を KubeArmor でよりセキュアにしよう	https://aws.amazon.com/jp/blogs/news/secure-aws-bottlerocket-deployments-on-amazon-eks-with-kubearmor/	deploymentsonamazonekswit	2023-05-18 06:52:09
python	Pythonタグが付けられた新着投稿 - Qiita	【異常検知】入門: センサーデータの異常検知をやってみた	https://qiita.com/sergicalsix/items/7d53cd273451c178e4f7	教師あり学習	2023-05-18 15:52:53
python	Pythonタグが付けられた新着投稿 - Qiita	CyberAgentが公開した日本語LLMをGoogle Colabで動かす方法	https://qiita.com/edi_t/items/21694c918b78a34877a4	cyberagent	2023-05-18 15:13:48
Ruby	Rubyタグが付けられた新着投稿 - Qiita	★ 7 ステップで完了 ★ Ruby で Discord Bot 作成	https://qiita.com/RabbitAATS/items/31c98b0896f57194ef6b	discordbot	2023-05-18 15:41:44
Docker	dockerタグが付けられた新着投稿 - Qiita	クラウド技術Ⅱ	https://qiita.com/Pichu/items/574e993043b2f3d3468f	docker	2023-05-18 15:01:51
GCP	gcpタグが付けられた新着投稿 - Qiita	Cloud Function&Cloud Run 別プロジェクトCloud SQLの接続方法	https://qiita.com/Match3a/items/65b4a11d35d1102d5887	cloudrunorcloud	2023-05-18 15:09:28
技術ブログ	Developers.IO	もめんと会（Momentoユーザーグループ)がスタートしました	https://dev.classmethod.jp/articles/momento-kai/	momento	2023-05-18 06:04:28
海外TECH	DEV Community	Snowflake Views Vs. Materialized Views: What's the Difference?	https://dev.to/chaos-genius/snowflake-views-vs-materialized-views-whats-the-difference-2pg	Snowflake Views Vs Materialized Views What x s the Difference In this article we will explore the powerful capabilities of Snowflake views to simplify complex tables and streamline query workflows We ll begin by introducing what Snowflake views are outlining their key differences and discussing the pros and cons of each type Additionally we ll delve into various use cases that highlight how Snowflake non materialized and materialized views can enhance query performance and address common workflow challenges So if you re tired of struggling with unwieldy tables and lengthy query times read on to discover how Snowflake views can make your life easier What Is a View and What Are the Different Types of Snowflake Views A view in Snowflake is a database object that allows you to see the results of a query as if it were a table It s a virtual table that can be used just like a regular table in queries joins subqueriesーand various other operations Views serve various purposes including combining segregating and protecting data You can use the CREATE VIEW command to create a view in Snowflake The basic syntax for creating a view is CREATE VIEW AS Here s a simple example CREATE VIEW my custom view ASSELECT column columnFROM my tableWHERE column value What are the types of Views in Snowflake Non Materialized  referred to as “views Materialized ViewsSecure Views What is a Non Materialized View Snowflake views Non materialized view is a virtual table whose results are generated by running a simple SQL query whenever the view is accessed The query is executed dynamically each time the view is referenced in a query so the results are not stored for later future use Non materialized views are very useful in simplifying complex queries and reducing redundancy It can help you remove unnecessary columns refine and filter out unwanted rows and rename columns in a table making it easier to work with the data Non materialized views are commonly referred to as simply views in Snowflake The benefit of non materialized views is that they are really very easy to create and they do not consume storage space because the results are not stored for later But remember that they may result in slower query performance as the underlying query must be executed each time the view is referenced Non materialized views have a variety of use cases including making complex queries simpler creating reusable views for frequently used queries and ensuring secure access to data by limiting the columns and rows that particular users can see or access Now let s create one simple example of a non materialized view in Snowflake So to do that let s first create one sample demo table and insert some dummy data into it CREATE TABLE employees id INTEGER name VARCHAR department VARCHAR salary INTEGER INSERT INTO employees id name department salary VALUES User HR User IT User Sales User IT User Marketing Now let s create a view called it employees that only includes the employees from the IT department CREATE VIEW it employees ASSELECT id name salaryFROM employeesWHERE department IT So when we query the it employees view we ll only see the data for the IT department employees SELECT FROM it employees What are Snowflake Materialized Views A Snowflake materialized view is a precomputed view of data stored in a table like structure It is used to improve query performance and reduce resource usage by precomputing the results of complex queries and storing them as cached result sets Whenever subsequent queries are executed against the same data Snowflake can access these materialized views directly rather than recomputing the query from scratch each time However it s important to note that the actual query using the materialized view is run on both the materialized data and any new data added to the table since the view was last refreshed Overall Snowflake materialized views can help improve query speed and optimize costs Note Snowflake materialized views are exclusively accessible to users with an Enterprise Edition subscription How to Create a Materialized View Creating a materialized view in Snowflake is easy Here is a step by step example of how to create a materialized view in SnowflakeStep  let s create a table “employees table and insert some dummy data CREATE TABLE employees table id INTEGER name VARCHAR department VARCHAR salary INTEGER INSERT INTO employees table VALUES User Sales User Marketing User Sales User Marketing User Sales Step Create a materialized view that aggregates the salaries by department CREATE MATERIALIZED VIEW materalized view employee salariesAS SELECT department SUM salary AS total salaryFROM employees tableGROUP BY department Creating snowflake materialized view for employee salaries by departmentThe above query will create a materialized view called “materalized view employee salaries  that calculates the total salaries for each department by aggregating the salaries in the “employees table  table Note GROUP BY clause is required in the query definition of the materialized view Step You can then query the materialized view just like you would a regular table SELECT FROM materalized view employee salaries The output should show you the total salaries for each department computed using the materialized view And that is how simple it is to create a Materialized view What are the benefits amp limitations of Using a Snowflake Materialized View A Snowflake materialized view offers several benefits and limitations to consider when deciding whether to use it Benefits of using a Snowflake materialized view include Accelerated query performance for complex queries that require significant processing time Reduced query latency by providing pre computed results for frequently executed queries Efficient incremental updates of large datasets Minimized resource usage and reduced compute costs by executing queries only against new data added to a table rather than the entire dataset A consistent interface for users to access frequently used data while shielding them from the underlying complexity of the database schema Faster query performance for geospatial and time series data which may require specialized indexing and querying techniques that can benefit from pre computed results However it s important to note that Snowflake materialized views also come with some limitations including The ability to query only a single table No support for joins including self joins The inability to query materialized views non materialized views or user defined table functions The inability to include user defined functions window functions HAVING clauses ORDER BY clauses LIMIT clauses or GROUP BY keys that are not within the SELECT list The inability to use GROUP BY GROUPING SETS GROUP BY ROLLUP or GROUP BY CUBE The inability to include nested subqueries within a Snowflake materialized view The limited set of allowed aggregate functions with no support for nested aggregate functions or combining DISTINCT with aggregate functions The inability to use aggregate functions AVG COUNT MIN MAX and SUM as window functions The requirement that all functions used in a Snowflake materialized view must be deterministic The inability to create a Snowflake materialized view using the Time Travel feature While Snowflake materialized views can provide significant performance benefits it s important to consider their limitations when deciding whether to use them What are the key differences between Snowflake Views and Materialized Views Here are some key main differences between Snowflake non materialized View and Materialized View FeatureSnowflake Materialized ViewsNon Materialized ViewsQuery from multiple tablesNoYesSupport for self joinsNoYesPre computed datasetYesNoComputes result on the flyNoYesQuery speedFasterSlowerCompute costCharged on base table updateCharged on queryStorage costIncurs costNo costSuitable for complex queriesYesNoSuitable for simple queriesNoYes What are the cost differences between Snowflake views and Snowflake materialized views There are significant differences between the costs of Snowflake Views and Snowflake Materialized views as noted below Snowflake Non Materialized ViewsSnowflake Materialized ViewsCompute costCharged when queriedCharged when base table is updatedStorage costNoneIncurs a cost for storing the pre computed outputSuitable forFrequently changing dataInfrequently changing dataCompute cost frequency of updates More suitable for tables with constant streaming updatesLess suitable for frequently updated tablesOverall compute costDirectly proportional to the size of the underlying base tableDirectly proportional to the size of the underlying base table and frequency of updates What are Snowflake Secure Views Snowflake secure views are a type of view in Snowflake that provides enhanced data privacy and security These views prevent unauthorized users from accessing the underlying data in the base tables and restrict the visibility of the view definition to authorized users only Secure views are created using the SECURE keyword in the CREATE VIEW or CREATE MATERIALIZED VIEW command and are recommended for use when limiting access to sensitive data BUT remember that they may execute more slowly than non secure views so the trade off between data privacy security and query performance should be carefully considered You can refer to this official Snowflake documentation to learn more about secure views ConclusionIn conclusion both Snowflake non materialized views and Snowflake materialized views offer benefits and drawbacks and choosing between the two depends on the specific use case Non materialized views are suitable for ad hoc queries or constantly changing data while materialized views are ideal for frequently queried data that is relatively static Materialized views can provide significant performance gains but come at the cost of increased storage and compute usage as well as additional costs each time the base table is updated It s important to carefully evaluate your needs and use cases before selecting a view type to ensure optimal query performance and cost efficiency	2023-05-18 06:32:49
海外TECH	Engadget	Twitter faces lawsuit for allegedly getting a Saudi dissident imprisoned	https://www.engadget.com/twitter-faces-lawsuit-for-allegedly-getting-a-saudi-dissident-imprisoned-061457663.html?src=rss	Twitter faces lawsuit for allegedly getting a Saudi dissident imprisonedIn December former Twitter employee Ahmad Abouammo was found guilty of taking bribes from Saudi Crown Prince Mohammed bin Salman in return for sensitive account information on dissidents using the website Now the sister of Abdulrahman al Sadhan who was allegedly kidnapped and tortured for operating a Twitter account critical of Saudi Arabia has filed a lawsuit accusing Twitter of breaking the law for letting its employees reveal his identity nbsp Areej al Sadhan filed the complaint on her and her brother s behalf under the Racketeer Influenced and Corrupt Organizations RICO statute Her brother Abdulrahman was sentenced to years in prison for supporting terrorism In her complaint Areej accuses Twitter of giving her brother s quot identifying information to the government of Saudi Arabia which blatantly violates its terms and conditions quot She continued quot This puts every Twitter user at risk As a result Saudi Arabia kidnapped tortured imprisoned and ーthrough a sham trial ーsentenced my brother to years in prison simply for criticizing Saudi repression on his Twitter account quot The Saudi government has apparently denied Abdulrahman contact with his family who has no idea whether he s still alive nbsp Abouammo and another former Twitter employee named Ali Alzabarah accessed confidential Twitter user data times in the lawsuit states They then allegedly handed Saudi Arabia identifying information for Twitter user accounts including names birthdates device identifiers phone numbers IP addresses and session IP histories associated with user accounts nbsp While Twitter will likely defend itself by saying that it didn t approve or wasn t aware of Saudi s espionage activities the lawsuit also states that US intelligence agencies warned the company about Alzabarah giving Saudi Arabia user information in late Six months after the warning Jack Dorsey who was Twitter s CEO back then met with Mohammed bin Salman quot despite knowing full well Saudi Arabia s malign activities and various crimes quot the complaint reads nbsp As The Washington Post notes Twitter faced two other lawsuits related to Saudi s spying activities on its website However one was dismissed after it failed to establish a connection between the leak of information and the hacking of the plaintiff s phone three years later which had led to his family and friends getting imprisoned Saudi also isn t the only country conducting espionage on the website Twitter s former security chief turned whistleblower Peiter Zatko revealed last year that the company was also previously warned that it had Chinese intelligence agents on its payroll nbsp This article originally appeared on Engadget at	2023-05-18 06:14:57
海外科学	BBC News - Science & Environment	River sewage: England's water firms issue apology	https://www.bbc.co.uk/news/science-environment-65626241?at_medium=RSS&at_campaign=KARANGA	impact	2023-05-18 06:41:11
医療系	医療介護 CBnews	在宅自己注の対象薬、新薬以外も年4回収載時に追加へ-厚労省、運用基準見直し	https://www.cbnews.jp/news/entry/20230518153827	中央社会保険医療協議会	2023-05-18 16:00:00
金融	RSS FILE - 日本証券業協会	株券等貸借取引状況（週間）	https://www.jsda.or.jp/shiryoshitsu/toukei/kabu-taiw/index.html	貸借	2023-05-18 06:30:00
金融	JPX マーケットニュース	[東証]新規上場の承認（グロース市場）：（株）シーユーシー	https://www.jpx.co.jp/listing/stocks/new/index.html	新規上場	2023-05-18 15:30:00
金融	日本銀行：RSS	貸出支援基金の運営として行う貸出増加を支援するための資金供給の対象先公募の結果について	http://www.boj.or.jp/mopo/measures/select/s_release/srel230518a.pdf	資金供給	2023-05-18 16:00:00
海外ニュース	Japan Times latest articles	At the G7 summit in Hiroshima, all eyes will be on ‘Ukraine, Ukraine, Ukraine’	https://www.japantimes.co.jp/news/2023/05/18/world/g7-hiroshima-ukraine-top-agenda/	At the G summit in Hiroshima all eyes will be on Ukraine Ukraine Ukraine Discussions on the issue will come at a crucial time for the G grouping itself which has struggled to define its purpose and goals in	2023-05-18 15:45:24
海外ニュース	Japan Times latest articles	Imports fall for first time in two years, easing impact as exports slow	https://www.japantimes.co.jp/news/2023/05/18/business/economy-business/import-value-fell/	Imports fall for first time in two years easing impact as exports slowThe trend cushions the hit of a global economic slowdown weighing on exports reflecting a fall in prices for commodities including crude oil and liquid	2023-05-18 15:32:47
海外ニュース	Japan Times latest articles	Hong Kong libraries remove books about Tiananmen protest ahead of anniversary	https://www.japantimes.co.jp/news/2023/05/18/asia-pacific/hong-kong-libraries-tiananmen-square/	Hong Kong libraries remove books about Tiananmen protest ahead of anniversaryHong Kong once a haven for information about taboo topics in mainland China has removed books about the Tiananmen Square protest from its library shelves	2023-05-18 15:22:19
海外ニュース	Japan Times latest articles	Shiga Prefecture hopes Austria-shaped Lake Biwa can create tourism splash	https://www.japantimes.co.jp/news/2023/05/18/national/shiga-biwa-austria/	Shiga Prefecture hopes Austria shaped Lake Biwa can create tourism splashLake Biwa is one of the world s oldest lakes with a surface area of square kilometers and rich biodiversity of around or more	2023-05-18 15:15:11
ニュース	BBC News - Home	River sewage: England's water firms issue apology	https://www.bbc.co.uk/news/science-environment-65626241?at_medium=RSS&at_campaign=KARANGA	impact	2023-05-18 06:41:11
ニュース	BBC News - Home	BT to cut up to 55,000 jobs by end of decade	https://www.bbc.co.uk/news/business-65631168?at_medium=RSS&at_campaign=KARANGA	decadethe	2023-05-18 06:51:44
IT	週刊アスキー	【来週発売】マジすごい「ファンタ」を生放送で一足先に飲む。プレゼント情報もあるよ！ 金曜12時～アスキーグルメNEWS見てね	https://weekly.ascii.jp/elem/000/004/137/4137222/	youtube	2023-05-18 15:45:00
IT	週刊アスキー	メープルスイーツ専門店「ザ・メープルマニア」が新宿に戻ってくる！　5月25日 京王百貨店新宿店にオープン	https://weekly.ascii.jp/elem/000/004/137/4137184/	京王百貨店	2023-05-18 15:40:00
IT	週刊アスキー	「横浜開港記念日」（6月2日）の花火を船上から見物する特別クルーズ	https://weekly.ascii.jp/elem/000/004/137/4137181/	開港記念日	2023-05-18 15:30:00
IT	週刊アスキー	『LOOP8（ループエイト）』人気配信者による計8時間の実況配信が決定！	https://weekly.ascii.jp/elem/000/004/137/4137193/	配信	2023-05-18 15:30:00
マーケティング	AdverTimes	JAGDA主催の学生向け国際ポスターコンペ募集始まる テーマは「Share」	https://www.advertimes.com/20230518/article419597/	jagda	2023-05-18 06:15:41
ニュース	THE BRIDGE	テスラが開発中のヒト型ロボット、ようやくモノを掴めるように【訓練動画公開】	https://thebridge.jp/2023/05/tesla-bot-becomes-less-of-a-sideshow-as-impressive-new-footage-of-the-robots-emerge-pickupnews	テスラが開発中のヒト型ロボット、ようやくモノを掴めるように【訓練動画公開】ピックアップTeslaBotbecomeslessofasideshowasimpressivenewfootageoftherobotsemergeTeslaが昨年月にお披露目した人型ロボット「OptimusTeslabot・テスラボット」のプロトタイプがアップデートしていました。	2023-05-18 06:15:05