{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftech.enigmo.co.jp%2Fentry%2F2024%2F10%2F03%2F101158\" title=\"INSERT SELECT\u3084CREATE TABLE AS\u3067WITH\u53e5\u3092\u4f7f\u3046\u6642\u306e\u6ce8\u610f\u70b9 - \u30a8\u30cb\u30b0\u30e2\u958b\u767a\u8005\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"INSERT SELECT\u3084CREATE TABLE AS\u3067WITH\u53e5\u3092\u4f7f\u3046\u6642\u306e\u6ce8\u610f\u70b9","published":"2024-10-03 10:11:58","author_name":"enigmo7","blog_url":"https://tech.enigmo.co.jp/","width":"100%","provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/enigmo7/","height":"190","version":"1.0","categories":["SQL","BigQuery"],"blog_title":"\u30a8\u30cb\u30b0\u30e2\u958b\u767a\u8005\u30d6\u30ed\u30b0","url":"https://tech.enigmo.co.jp/entry/2024/10/03/101158","provider_name":"Hatena Blog","image_url":null,"description":"\u3053\u3093\u306b\u3061\u306f\u3001\u30a8\u30cb\u30b0\u30e2 \u5609\u677e\u3067\u3059\u3002 BUYMA\u306e\u30d7\u30ed\u30e2\u30fc\u30b7\u30e7\u30f3\u3084\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u3092\u62c5\u5f53\u3057\u3066\u3044\u308b\u4e8b\u696d\u90e8\u306b\u6240\u5c5e\u3057\u3066\u304a\u308a\u3001\u305d\u306e\u4e2d\u306e\u30c7\u30fc\u30bf\u6d3b\u7528\u63a8\u9032\u5ba4\u3068\u3044\u3046\u90e8\u7f72\u3067\u4f1a\u793e\u306e\u30c7\u30fc\u30bf\u6d3b\u7528\u306e\u63a8\u9032\u3084\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u30fb\u30aa\u30fc\u30c8\u30e1\u30fc\u30b7\u30e7\u30f3\u30c4\u30fc\u30eb\uff08MA\u30c4\u30fc\u30eb\uff09\u3092\u6d3b\u7528\u3057\u305f\u8ca9\u4fc3\u652f\u63f4\u3001CRM\u306a\u3069\u3092\u62c5\u5f53\u3057\u3066\u3044\u307e\u3059\u3002 \u3055\u3066\u3001SELECT\u6587\u3067\u5f97\u305f\u7d50\u679c\u306e\u30c7\u30fc\u30bf\u3092\uff08\u305d\u306e\u307e\u307e\u3001\u76f4\u63a5\uff09\u30c6\u30fc\u30d6\u30eb\u306b\u633f\u5165\u3059\u308b INSERT SELECT \u3084\u3001SELECT\u6587\u3067\u5f97\u305f\u7d50\u679c\u304b\u3089\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3066\u66f4\u306b\u30c7\u30fc\u30bf\u307e\u3067\u633f\u5165\u3059\u308bCREATE TABLE AS\u306f\u4f55\u304b\u3068\u4fbf\u5229\u306a\u6a5f\u80fd\uff08\u6587\u6cd5\u3001\u6280\uff1f\uff09\u3067\u3059\u304c\u3001WITH\u53e5\uff08SELECT\u6587\u306b\u3088\u308b\u7d50\u679c\u3092\u4e00\u6642\u7684\u306b\u540d\u524d\u3092\u4ed8\u3051\u3066\u30c6\u30fc\u30d6\u30eb\u306e\u3088\u3046\u306b\u5229\u7528\u2026","type":"rich"}