{"blog_url":"https://mactkg.hateblo.jp/","provider_name":"Hatena Blog","blog_title":"\u534a\u7a7a\u6d1e\u7537\u5973\u95a2\u4fc2","url":"https://mactkg.hateblo.jp/entry/2017/06/13/185637","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmactkg.hateblo.jp%2Fentry%2F2017%2F06%2F13%2F185637\" title=\"TreasureData\u3067\u51fa\u529b\u3057\u305fSpreadSheet\u3067\u30b0\u30e9\u30d5\u3092\u66f8\u304f - \u534a\u7a7a\u6d1e\u7537\u5973\u95a2\u4fc2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","image_url":null,"type":"rich","version":"1.0","height":"190","published":"2017-06-13 18:56:37","description":"tl;dr https://docs.google.com/spreadsheets/d/1y_gnVIvwuAQn2h8M5Gbf15MhCK2uzBjbJXCCbI_gMlw/pubhtml \u6982\u8981 Treasure Data\u3067\u306fQuery\u306e\u7d50\u679c\u3092Google SpreadSheet\u306b\u51fa\u529b\u3067\u304d\u308b\u306e\u3060\u304c\u3001\u51fa\u529b\u65b9\u5f0f\u306e\u554f\u984c\u3067\u66f8\u304d\u51fa\u3059\u305f\u3073\u306b\u30b7\u30fc\u30c8\u306eID\u304c\u5909\u308f\u3063\u3066\u3057\u307e\u3046\u3002\u66f8\u304d\u51fa\u3059\u30b7\u30fc\u30c8\u306e\u540d\u524d\u304cdata\u306e\u6642\u3001\u30b0\u30e9\u30d5\u306e\u7bc4\u56f2\u306b=data!A:A\u3068\u66f8\u304f\u3053\u3068\u3067data\u30b7\u30fc\u30c8\u306eA\u5217\u3092\u30b0\u30e9\u30d5\u306e\u30bd\u30fc\u30b9\u306b\u6307\u5b9a\u3067\u304d\u308b\u3082\u306e\u306e\u3001TD\u306eQuery\u3092Run\u3057\u3066\u30b7\u30fc\u30c8\u3092\u66f8\u304d\u63db\u3048\u308b\u3068\u30b0\u30e9\u30d5\u304c\u58ca\u308c\u308b\u3002 =data!A:A\u3068\u66f8\u3044\u305f\u5024\u306f\u3001\u2026","provider_url":"https://hatena.blog","title":"TreasureData\u3067\u51fa\u529b\u3057\u305fSpreadSheet\u3067\u30b0\u30e9\u30d5\u3092\u66f8\u304f","author_url":"https://blog.hatena.ne.jp/mactkg/","categories":["TreasureData"],"width":"100%","author_name":"mactkg"}