{"id":108856,"date":"2025-05-13T20:47:11","date_gmt":"2025-05-13T17:17:11","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/build-a-real-time-geolocation-analytics-api-with-tinybird-3eb9\/"},"modified":"2025-05-13T20:47:11","modified_gmt":"2025-05-13T17:17:11","slug":"build-a-real-time-geolocation-analytics-api-with-tinybird-3eb9","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/build-a-real-time-geolocation-analytics-api-with-tinybird-3eb9\/","title":{"rendered":"\u06cc\u06a9 API \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0628\u0627 Tinybird \u0628\u0633\u0627\u0632\u06cc\u062f"},"content":{"rendered":"<div data-article-id=\"2485017\" id=\"article-body\">\n<p>\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062d\u0631\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u0631\u062f\u06cc\u0627\u0628\u06cc \u0645\u06cc \u06a9\u0646\u0646\u062f \u060c \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0627\u0644\u06af\u0648\u0647\u0627\u06cc \u0645\u06a9\u0627\u0646\u06cc \u06cc\u0627 \u0627\u0631\u0627\u0626\u0647 \u062e\u062f\u0645\u0627\u062a \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0645\u0648\u0642\u0639\u06cc\u062a \u0645\u06a9\u0627\u0646\u06cc \u0645\u062d\u0648\u0631\u06cc \u0627\u0633\u062a. \u0627\u06cc\u0646 \u06a9\u0647 \u0622\u06cc\u0627 \u0627\u06cc\u0646 \u0628\u0631\u0627\u06cc \u0631\u062f\u06cc\u0627\u0628\u06cc \u0648\u0633\u0627\u06cc\u0644 \u0646\u0642\u0644\u06cc\u0647 \u062a\u062d\u0648\u06cc\u0644 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u060c \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062a\u0631\u0627\u0641\u06cc\u06a9 \u067e\u0627 \u062f\u0631 \u06cc\u06a9 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062e\u0631\u062f\u0647 \u0641\u0631\u0648\u0634\u06cc \u06cc\u0627 \u062a\u0647\u06cc\u0647 \u0645\u062d\u062a\u0648\u0627\u06cc \u0634\u062e\u0635\u06cc \u0628\u0631 \u0627\u0633\u0627\u0633 \u0645\u06a9\u0627\u0646 \u06a9\u0627\u0631\u0628\u0631 \u0627\u0633\u062a \u060c \u0627\u0645\u06a9\u0627\u0646 \u067e\u0631\u062f\u0627\u0632\u0634 \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u0628\u0647 \u0637\u0648\u0631 \u0645\u0624\u062b\u0631 \u0628\u0633\u06cc\u0627\u0631 \u0645\u0647\u0645 \u0627\u0633\u062a. \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u060c \u06cc\u0627\u062f \u0645\u06cc \u06af\u06cc\u0631\u06cc\u062f \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u06cc\u06a9 API \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0628\u0631\u0627\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Tinybird \u0628\u0633\u0627\u0632\u06cc\u062f. Tinybird \u06cc\u06a9 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u0648\u0633\u0639\u0647 \u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 \u0627\u0633\u062a. \u0634\u0645\u0627 \u0627\u0632 Tinybird \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a\u0646 API \u0647\u0627\u06cc \u062a\u062d\u0644\u06cc\u0644\u06cc \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f \u0628\u062f\u0648\u0646 \u0627\u06cc\u0646\u06a9\u0647 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06cc\u0627 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0632\u06cc\u0631\u0633\u0627\u062e\u062a \u0647\u0627\u06cc \u0627\u0633\u0627\u0633\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f. Tinybird \u06cc\u06a9 \u06af\u0631\u062f\u0634 \u06a9\u0627\u0631 \u0645\u062d\u0644\u06cc \u0628\u0631\u0627\u06cc \u062a\u0648\u0633\u0639\u0647 \u0645\u062d\u0644\u06cc \u060c \u0627\u0633\u062a\u0642\u0631\u0627\u0631 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 GIT \u060c \u062a\u0639\u0627\u0631\u06cc\u0641 \u0645\u0646\u0627\u0628\u0639 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06a9\u062f \u0648 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u0648\u0633\u0639\u0647 \u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0628\u0648\u0645\u06cc \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f. \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u0646\u0627\u0628\u0639 \u0648 \u0644\u0648\u0644\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 Tinybird \u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 API \u0647\u0627\u06cc \u0628\u0627 \u06a9\u0627\u0631\u0627\u06cc\u06cc \u0628\u0627\u0644\u0627 \u0645\u0635\u0631\u0641 \u060c \u062a\u0628\u062f\u06cc\u0644 \u0648 \u0633\u0631\u0648 \u06a9\u0646\u06cc\u062f. \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0634\u0645\u0627 \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u06cc\u062c\u0627\u062f \u0645\u0646\u0627\u0628\u0639 \u062f\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0631\u0648\u06cc\u062f\u0627\u062f\u0647\u0627\u06cc \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u060c \u062a\u0628\u062f\u06cc\u0644 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0628\u06cc\u0646\u0634 \u0647\u0627\u06cc \u0645\u0639\u0646\u06cc \u062f\u0627\u0631 \u0648 \u062f\u0631 \u0622\u062e\u0631 \u060c \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 API \u0647\u0627\u06cc \u0645\u0642\u06cc\u0627\u0633 \u067e\u0630\u06cc\u0631 \u0628\u0631\u0627\u06cc \u0631\u062f\u06cc\u0627\u0628\u06cc \u0645\u06a9\u0627\u0646 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631 \u060c \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0645\u06a9\u0627\u0646 \u06a9\u0627\u0631\u0628\u0631 \u060c \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u06a9\u0627\u0646 \u062f\u0631 \u0637\u0648\u0644 \u0632\u0645\u0627\u0646 \u0648 \u06cc\u0627\u0641\u062a\u0646 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u0637\u0631\u0627\u0641 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0645\u062e\u062a\u0635\u0627\u062a \u0631\u0627\u0647\u0646\u0645\u0627\u06cc\u06cc \u0645\u06cc \u06a9\u0646\u062f. \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u0627 Tinybird \u0628\u0647 \u062f\u0646\u06cc\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0634\u06cc\u0631\u062c\u0647 \u0628\u0632\u0646\u06cc\u0645. <\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/build-a-real-time-geolocation-analytics-api-with-tinybird-3eb9\/#%D8%AF%D8%B1%DA%A9_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7\" >\u062f\u0631\u06a9 \u062f\u0627\u062f\u0647 \u0647\u0627<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/build-a-real-time-geolocation-analytics-api-with-tinybird-3eb9\/#%D8%AA%D8%BA%DB%8C%DB%8C%D8%B1_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D9%88_%D8%A7%D9%86%D8%AA%D8%B4%D8%A7%D8%B1_API\" >\u062a\u063a\u06cc\u06cc\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u0627\u0646\u062a\u0634\u0627\u0631 API<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/build-a-real-time-geolocation-analytics-api-with-tinybird-3eb9\/#%D8%B3%D8%A7%D8%A8%D9%82%D9%87_%D9%85%DA%A9%D8%A7%D9%86_%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1\" >\u0633\u0627\u0628\u0642\u0647 \u0645\u06a9\u0627\u0646 \u06a9\u0627\u0631\u0628\u0631<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/build-a-real-time-geolocation-analytics-api-with-tinybird-3eb9\/#%D8%AA%D8%AC%D8%B2%DB%8C%D9%87_%D9%88_%D8%AA%D8%AD%D9%84%DB%8C%D9%84_%D9%85%DA%A9%D8%A7%D9%86\" >\u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u06a9\u0627\u0646<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/build-a-real-time-geolocation-analytics-api-with-tinybird-3eb9\/#%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1%D8%A7%D9%86_%D8%A7%D8%B7%D8%B1%D8%A7%D9%81\" >\u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u0637\u0631\u0627\u0641<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/build-a-real-time-geolocation-analytics-api-with-tinybird-3eb9\/#%D8%A7%D8%B9%D8%B2%D8%A7%D9%85_%D8%A8%D9%87_%D8%AA%D9%88%D9%84%DB%8C%D8%AF\" >\u0627\u0639\u0632\u0627\u0645 \u0628\u0647 \u062a\u0648\u0644\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nabfollower.com\/blog\/build-a-real-time-geolocation-analytics-api-with-tinybird-3eb9\/#%D9%BE%D8%A7%DB%8C%D8%A7%D9%86\" >\u067e\u0627\u06cc\u0627\u0646<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D8%AF%D8%B1%DA%A9_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7\"><\/span>\n<p>  \u062f\u0631\u06a9 \u062f\u0627\u062f\u0647 \u0647\u0627<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062a\u0635\u0648\u0631 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0634\u0645\u0627 \u0628\u0647 \u0627\u06cc\u0646 \u0634\u06a9\u0644 \u0627\u0633\u062a:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight json\"><code><span class=\"p\">{<\/span><span class=\"nl\">\"user_id\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"user_396\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"latitude\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"mf\">2023638.396<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"longitude\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"mf\">2023548.396<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"accuracy\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"mi\">11<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"event_type\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"departed\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"device_id\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"device_396\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"timestamp\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"2025-04-13 09:32:45\"<\/span><span class=\"p\">}<\/span><span class=\"w\">\n<\/span><span class=\"p\">{<\/span><span class=\"nl\">\"user_id\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"user_169\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"latitude\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"mf\">1828226.169<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"longitude\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"mf\">1828136.169<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"accuracy\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"mi\">64<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"event_type\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"exited_region\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"device_id\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"device_169\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"timestamp\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"2025-04-13 19:46:15\"<\/span><span class=\"p\">}<\/span><span class=\"w\">\n<\/span><\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0646\u0634\u0627\u0646\u06af\u0631 \u0631\u0648\u06cc\u062f\u0627\u062f\u0647\u0627\u06cc \u0645\u06a9\u0627\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0627\u0632 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0636\u0628\u0637 \u0634\u062f\u0647 \u0627\u0633\u062a \u060c \u0627\u0632 \u062c\u0645\u0644\u0647 \u0634\u0646\u0627\u0633\u0647 \u0647\u0627\u06cc \u0622\u0646\u0647\u0627 \u060c \u0645\u062e\u062a\u0635\u0627\u062a (\u0639\u0631\u0636 \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u0648 \u0637\u0648\u0644 \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc) \u060c \u0635\u062d\u062a \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u06a9\u0627\u0646 \u060c \u0646\u0648\u0639 \u0631\u0648\u06cc\u062f\u0627\u062f (\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u060c \u0686\u06a9 \u060c \u0639\u0632\u06cc\u0645\u062a) \u060c \u0634\u0646\u0627\u0633\u0647 \u062f\u0633\u062a\u06af\u0627\u0647 \u0648 \u0632\u0645\u0627\u0646 \u0628\u0646\u062f\u06cc \u0627\u06cc\u0646 \u0631\u0648\u06cc\u062f\u0627\u062f. \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 Tinybird \u060c \u0634\u0645\u0627 \u06cc\u06a9 \u0645\u0646\u0628\u0639 \u062f\u0627\u062f\u0647 \u0628\u0627 \u0637\u0631\u062d \u0632\u06cc\u0631 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight json\"><code><span class=\"err\">DESCRIPTION<\/span><span class=\"w\"> <\/span><span class=\"err\">&gt;<\/span><span class=\"w\">\n    <\/span><span class=\"err\">Stores<\/span><span class=\"w\"> <\/span><span class=\"err\">location<\/span><span class=\"w\"> <\/span><span class=\"err\">events<\/span><span class=\"w\"> <\/span><span class=\"err\">with<\/span><span class=\"w\"> <\/span><span class=\"err\">user<\/span><span class=\"w\"> <\/span><span class=\"err\">IDs,<\/span><span class=\"w\"> <\/span><span class=\"err\">coordinates,<\/span><span class=\"w\"> <\/span><span class=\"err\">and<\/span><span class=\"w\"> <\/span><span class=\"err\">timestamps<\/span><span class=\"w\">\n\n<\/span><span class=\"err\">SCHEMA<\/span><span class=\"w\"> <\/span><span class=\"err\">&gt;<\/span><span class=\"w\">\n    <\/span><span class=\"err\">`user_id`<\/span><span class=\"w\"> <\/span><span class=\"err\">String<\/span><span class=\"w\"> <\/span><span class=\"err\">`json:$.user_id`,<\/span><span class=\"w\">\n    <\/span><span class=\"err\">`latitude`<\/span><span class=\"w\"> <\/span><span class=\"err\">Float<\/span><span class=\"mi\">64<\/span><span class=\"w\"> <\/span><span class=\"err\">`json:$.latitude`,<\/span><span class=\"w\">\n    <\/span><span class=\"err\">`longitude`<\/span><span class=\"w\"> <\/span><span class=\"err\">Float<\/span><span class=\"mi\">64<\/span><span class=\"w\"> <\/span><span class=\"err\">`json:$.longitude`,<\/span><span class=\"w\">\n    <\/span><span class=\"err\">`accuracy`<\/span><span class=\"w\"> <\/span><span class=\"err\">Float<\/span><span class=\"mi\">32<\/span><span class=\"w\"> <\/span><span class=\"err\">`json:$.accuracy`,<\/span><span class=\"w\">\n    <\/span><span class=\"err\">`event_type`<\/span><span class=\"w\"> <\/span><span class=\"err\">String<\/span><span class=\"w\"> <\/span><span class=\"err\">`json:$.event_type`,<\/span><span class=\"w\">\n    <\/span><span class=\"err\">`device_id`<\/span><span class=\"w\"> <\/span><span class=\"err\">String<\/span><span class=\"w\"> <\/span><span class=\"err\">`json:$.device_id`,<\/span><span class=\"w\">\n    <\/span><span class=\"err\">`timestamp`<\/span><span class=\"w\"> <\/span><span class=\"err\">DateTime<\/span><span class=\"w\"> <\/span><span class=\"err\">`json:$.timestamp`<\/span><span class=\"w\">\n\n<\/span><span class=\"err\">ENGINE<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"MergeTree\"<\/span><span class=\"w\">\n<\/span><span class=\"err\">ENGINE_PARTITION_KEY<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"toYYYYMM(timestamp)\"<\/span><span class=\"w\">\n<\/span><span class=\"err\">ENGINE_SORTING_KEY<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"timestamp, user_id, event_type\"<\/span><span class=\"w\">\n<\/span><\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0637\u0631\u062d \u0628\u0631\u0627\u06cc \u0628\u0647\u06cc\u0646\u0647 \u0633\u0627\u0632\u06cc \u0639\u0645\u0644\u06a9\u0631\u062f \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0628\u0627 \u0645\u0631\u062a\u0628 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0637\u0631\u0627\u062d\u06cc \u0634\u062f\u0647 \u0627\u0633\u062a <code>timestamp<\/code>\u0628\u0627 <code>user_id<\/code>\u0648\u062a <code>event_type<\/code>\u0628\u0634\u0631 \u062f\u0631 <code>MergeTree<\/code> \u0645\u0648\u062a\u0648\u0631 \u060c \u0647\u0645\u0631\u0627\u0647 \u0628\u0627 \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc \u067e\u0627\u0631\u062a\u06cc\u0634\u0646 \u0628\u0646\u062f\u06cc \u0648 \u0645\u0631\u062a\u0628 \u0633\u0627\u0632\u06cc \u0645\u0646\u0627\u0633\u0628 \u060c \u0630\u062e\u06cc\u0631\u0647 \u0648 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0622\u0645\u062f \u0631\u0627 \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc \u06a9\u0646\u062f. \u0628\u0631\u0627\u06cc \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0646\u0628\u0639 \u062f\u0627\u062f\u0647 \u060c API \u0631\u0648\u06cc\u062f\u0627\u062f\u0647\u0627\u06cc Tinybird \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0631\u0648\u06cc\u062f\u0627\u062f\u0647\u0627\u06cc JSON\/NDJSON \u0631\u0627 \u0627\u0632 \u062c\u0644\u0648\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u062e\u0648\u062f \u06cc\u0627 \u067e\u0633 \u0632\u0645\u06cc\u0646\u0647 \u0628\u0627 \u06cc\u06a9 \u062f\u0631\u062e\u0648\u0627\u0633\u062a HTTP \u0633\u0627\u062f\u0647 \u067e\u062e\u0634 \u06a9\u0646\u06cc\u062f. \u0645\u0627\u0647\u06cc\u062a \u0648\u0627\u0642\u0639\u06cc API \u0631\u0648\u06cc\u062f\u0627\u062f\u0647\u0627 \u0648 \u062a\u0623\u062e\u06cc\u0631 \u06a9\u0645 \u0622\u0646 \u060c \u0622\u0646 \u0631\u0627 \u0628\u0631\u0627\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u0627\u06cc\u062f\u0647 \u0622\u0644 \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code>curl <span class=\"nt\">-X<\/span> POST <span class=\"s2\">\"https:\/\/api.europe-west2.gcp.tinybird.co\/v0\/events?name=location_events&amp;utm_source=DEV&amp;utm_campaign=tb+create+--prompt+DEV\"<\/span> <span class=\"se\">\\<\/span>\n     <span class=\"nt\">-H<\/span> <span class=\"s2\">\"Authorization: Bearer <\/span><span class=\"nv\">$TB_ADMIN_TOKEN<\/span><span class=\"s2\">\"<\/span> <span class=\"se\">\\<\/span>\n     <span class=\"nt\">-d<\/span> <span class=\"s1\">'{\n       \"user_id\": \"user_123\",\n       \"latitude\": 40.7128,\n       \"longitude\": -74.0060,\n       \"accuracy\": 15.5,\n       \"event_type\": \"check_in\",\n       \"device_id\": \"device_abc\",\n       \"timestamp\": \"2023-10-15 14:30:00\"\n     }'<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0631\u0648\u06cc\u062f\u0627\u062f\/\u062c\u0631\u06cc\u0627\u0646 \u060c \u06a9\u0627\u0646\u06a9\u062a\u0648\u0631 Kafka \u06af\u0632\u06cc\u0646\u0647 \u0627\u06cc \u0642\u0648\u06cc \u0628\u0631\u0627\u06cc \u0627\u062f\u063a\u0627\u0645 \u0628\u0627 \u062c\u0631\u06cc\u0627\u0646 \u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f Kafka \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f. \u0628\u0631\u0627\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062f\u0633\u062a\u0647 \u0627\u06cc \u06cc\u0627 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u067e\u0631\u0648\u0646\u062f\u0647 \u060c Connector \u0645\u0646\u0627\u0628\u0639 \u062f\u0627\u062f\u0647 API \u0648 S3 \u0631\u0648\u0634\u0647\u0627\u06cc \u0645\u0635\u0631\u0641 \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631 \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u0646\u062f. <\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D8%AA%D8%BA%DB%8C%DB%8C%D8%B1_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D9%88_%D8%A7%D9%86%D8%AA%D8%B4%D8%A7%D8%B1_API\"><\/span>\n<p>  \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u0627\u0646\u062a\u0634\u0627\u0631 API<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tinybird \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0644\u0648\u0644\u0647 \u0647\u0627 \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0627\u0645\u06a9\u0627\u0646 \u062a\u062d\u0648\u0644\u0627\u062a \u062f\u0633\u062a\u0647 \u0627\u06cc \u060c \u062a\u062d\u0648\u0644\u0627\u062a \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc (\u0646\u0645\u0627\u0647\u0627\u06cc \u0645\u0627\u062f\u06cc) \u0648 \u0627\u06cc\u062c\u0627\u062f \u0646\u0642\u0627\u0637 \u067e\u0627\u06cc\u0627\u0646\u06cc API \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f. <\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%B3%D8%A7%D8%A8%D9%82%D9%87_%D9%85%DA%A9%D8%A7%D9%86_%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1\"><\/span>\n<p>  \u0633\u0627\u0628\u0642\u0647 \u0645\u06a9\u0627\u0646 \u06a9\u0627\u0631\u0628\u0631<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062f\u0631 <code>user_location_history<\/code> \u0646\u0642\u0637\u0647 \u067e\u0627\u06cc\u0627\u0646 \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0645\u06a9\u0627\u0646 \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u0645\u062d\u062f\u0648\u062f\u0647 \u0632\u0645\u0627\u0646\u06cc \u0645\u0634\u062e\u0635 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">DESCRIPTION<\/span> <span class=\"o\">&gt;<\/span>\n    <span class=\"n\">Retrieve<\/span> <span class=\"k\">location<\/span> <span class=\"n\">history<\/span> <span class=\"k\">for<\/span> <span class=\"n\">a<\/span> <span class=\"k\">specific<\/span> <span class=\"k\">user<\/span> <span class=\"n\">within<\/span> <span class=\"n\">a<\/span> <span class=\"nb\">time<\/span> <span class=\"k\">range<\/span>\n\n<span class=\"n\">NODE<\/span> <span class=\"n\">user_location_history_node<\/span>\n<span class=\"k\">SQL<\/span> <span class=\"o\">&gt;<\/span>\n    <span class=\"k\">SELECT<\/span> \n        <span class=\"n\">user_id<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">latitude<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">longitude<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">accuracy<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">event_type<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">device_id<\/span><span class=\"p\">,<\/span>\n        <span class=\"nb\">timestamp<\/span>\n    <span class=\"k\">FROM<\/span> <span class=\"n\">location_events<\/span>\n    <span class=\"k\">WHERE<\/span> \n        <span class=\"n\">user_id<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{{<\/span><span class=\"n\">String<\/span><span class=\"p\">(<\/span><span class=\"n\">user_id<\/span><span class=\"p\">,<\/span> <span class=\"s1\">''<\/span><span class=\"p\">)}}<\/span>\n        <span class=\"k\">AND<\/span> <span class=\"nb\">timestamp<\/span> <span class=\"o\">&gt;=<\/span> <span class=\"p\">{{<\/span><span class=\"nb\">DateTime<\/span><span class=\"p\">(<\/span><span class=\"n\">start_time<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'2023-01-01 00:00:00'<\/span><span class=\"p\">)}}<\/span>\n        <span class=\"k\">AND<\/span> <span class=\"nb\">timestamp<\/span> <span class=\"o\">&lt;=<\/span> <span class=\"p\">{{<\/span><span class=\"nb\">DateTime<\/span><span class=\"p\">(<\/span><span class=\"n\">end_time<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'2023-12-31 23:59:59'<\/span><span class=\"p\">)}}<\/span>\n    <span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"nb\">timestamp<\/span> <span class=\"k\">DESC<\/span>\n    <span class=\"k\">LIMIT<\/span> <span class=\"p\">{{<\/span><span class=\"n\">Int32<\/span><span class=\"p\">(<\/span><span class=\"k\">limit<\/span><span class=\"p\">,<\/span> <span class=\"mi\">1000<\/span><span class=\"p\">)}}<\/span>\n\n<span class=\"k\">TYPE<\/span> <span class=\"n\">endpoint<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0644\u0648\u0644\u0647 \u0631\u0648\u06cc\u062f\u0627\u062f\u0647\u0627\u06cc \u0645\u0648\u0642\u0639\u06cc\u062a \u0645\u06a9\u0627\u0646\u06cc \u0631\u0627 \u062a\u0648\u0633\u0637 <code>user_id<\/code> \u0648 \u06cc\u06a9 \u0645\u062d\u062f\u0648\u062f\u0647 \u062a\u0627\u0631\u06cc\u062e\/\u0632\u0645\u0627\u0646 \u060c \u0646\u062a\u0627\u06cc\u062c \u0631\u0627 \u062a\u0648\u0633\u0637 <code>timestamp<\/code>\u060c \u0648 \u062e\u0631\u0648\u062c\u06cc \u0631\u0627 \u0645\u062d\u062f\u0648\u062f \u0645\u06cc \u06a9\u0646\u062f. \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648 (<code>user_id<\/code>\u0628\u0627 <code>start_time<\/code>\u0628\u0627 <code>end_time<\/code>\u0628\u0627 <code>limit<\/code>) API \u0631\u0627 \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0627\u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062a\u0646\u0627\u0633\u0628 \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f. <\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%AA%D8%AC%D8%B2%DB%8C%D9%87_%D9%88_%D8%AA%D8%AD%D9%84%DB%8C%D9%84_%D9%85%DA%A9%D8%A7%D9%86\"><\/span>\n<p>  \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u06a9\u0627\u0646<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062f\u0631 <code>location_analytics<\/code> \u0645\u0635\u0627\u0644\u062d \u0627\u0646\u062a\u0647\u0627\u06cc\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0631\u0648\u06cc\u062f\u0627\u062f \u0645\u06a9\u0627\u0646 \u0631\u0627 \u062f\u0631 \u062f\u0648\u0631\u0647 \u0647\u0627\u06cc \u0632\u0645\u0627\u0646\u06cc \u0645\u062e\u062a\u0644\u0641:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">DESCRIPTION<\/span> <span class=\"o\">&gt;<\/span>\n    <span class=\"k\">Get<\/span> <span class=\"n\">analytics<\/span> <span class=\"k\">on<\/span> <span class=\"k\">location<\/span> <span class=\"n\">events<\/span> <span class=\"k\">by<\/span> <span class=\"n\">aggregating<\/span> <span class=\"k\">data<\/span> <span class=\"n\">over<\/span> <span class=\"n\">different<\/span> <span class=\"nb\">time<\/span> <span class=\"n\">periods<\/span>\n\n<span class=\"n\">NODE<\/span> <span class=\"n\">location_analytics_node<\/span>\n<span class=\"k\">SQL<\/span> <span class=\"o\">&gt;<\/span>\n    <span class=\"k\">SELECT<\/span> \n        <span class=\"p\">{{<\/span><span class=\"n\">String<\/span><span class=\"p\">(<\/span><span class=\"n\">time_bucket<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'hour'<\/span><span class=\"p\">)}}<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">time_bucket<\/span><span class=\"p\">,<\/span>\n        <span class=\"k\">CASE<\/span> \n            <span class=\"k\">WHEN<\/span> <span class=\"p\">{{<\/span><span class=\"n\">String<\/span><span class=\"p\">(<\/span><span class=\"n\">time_bucket<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'hour'<\/span><span class=\"p\">)}}<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'hour'<\/span> <span class=\"k\">THEN<\/span> <span class=\"n\">toStartOfHour<\/span><span class=\"p\">(<\/span><span class=\"nb\">timestamp<\/span><span class=\"p\">)<\/span>\n            <span class=\"k\">WHEN<\/span> <span class=\"p\">{{<\/span><span class=\"n\">String<\/span><span class=\"p\">(<\/span><span class=\"n\">time_bucket<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'hour'<\/span><span class=\"p\">)}}<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'day'<\/span> <span class=\"k\">THEN<\/span> <span class=\"n\">toStartOfDay<\/span><span class=\"p\">(<\/span><span class=\"nb\">timestamp<\/span><span class=\"p\">)<\/span>\n            <span class=\"k\">WHEN<\/span> <span class=\"p\">{{<\/span><span class=\"n\">String<\/span><span class=\"p\">(<\/span><span class=\"n\">time_bucket<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'hour'<\/span><span class=\"p\">)}}<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'week'<\/span> <span class=\"k\">THEN<\/span> <span class=\"n\">toStartOfWeek<\/span><span class=\"p\">(<\/span><span class=\"nb\">timestamp<\/span><span class=\"p\">)<\/span>\n            <span class=\"k\">WHEN<\/span> <span class=\"p\">{{<\/span><span class=\"n\">String<\/span><span class=\"p\">(<\/span><span class=\"n\">time_bucket<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'hour'<\/span><span class=\"p\">)}}<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'month'<\/span> <span class=\"k\">THEN<\/span> <span class=\"n\">toStartOfMonth<\/span><span class=\"p\">(<\/span><span class=\"nb\">timestamp<\/span><span class=\"p\">)<\/span>\n            <span class=\"k\">ELSE<\/span> <span class=\"n\">toStartOfHour<\/span><span class=\"p\">(<\/span><span class=\"nb\">timestamp<\/span><span class=\"p\">)<\/span>\n        <span class=\"k\">END<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">bucket_start<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">event_type<\/span><span class=\"p\">,<\/span>\n        <span class=\"k\">count<\/span><span class=\"p\">()<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">event_count<\/span><span class=\"p\">,<\/span>\n        <span class=\"k\">count<\/span><span class=\"p\">(<\/span><span class=\"k\">DISTINCT<\/span> <span class=\"n\">user_id<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">unique_users<\/span><span class=\"p\">,<\/span>\n        <span class=\"k\">avg<\/span><span class=\"p\">(<\/span><span class=\"n\">accuracy<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">avg_accuracy<\/span>\n    <span class=\"k\">FROM<\/span> <span class=\"n\">location_events<\/span>\n    <span class=\"k\">WHERE<\/span> \n        <span class=\"nb\">timestamp<\/span> <span class=\"o\">&gt;=<\/span> <span class=\"p\">{{<\/span><span class=\"nb\">DateTime<\/span><span class=\"p\">(<\/span><span class=\"n\">start_time<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'2023-01-01 00:00:00'<\/span><span class=\"p\">)}}<\/span>\n        <span class=\"k\">AND<\/span> <span class=\"nb\">timestamp<\/span> <span class=\"o\">&lt;=<\/span> <span class=\"p\">{{<\/span><span class=\"nb\">DateTime<\/span><span class=\"p\">(<\/span><span class=\"n\">end_time<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'2023-12-31 23:59:59'<\/span><span class=\"p\">)}}<\/span>\n        <span class=\"k\">AND<\/span> <span class=\"n\">event_type<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{{<\/span><span class=\"n\">String<\/span><span class=\"p\">(<\/span><span class=\"n\">event_type<\/span><span class=\"p\">,<\/span> <span class=\"s1\">''<\/span><span class=\"p\">)}}<\/span>\n    <span class=\"k\">GROUP<\/span> <span class=\"k\">BY<\/span> \n        <span class=\"n\">time_bucket<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">bucket_start<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">event_type<\/span>\n    <span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">bucket_start<\/span> <span class=\"k\">DESC<\/span>\n\n<span class=\"k\">TYPE<\/span> <span class=\"n\">endpoint<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0644\u0648\u0644\u0647 \u0627\u0645\u06a9\u0627\u0646 \u062a\u062c\u0645\u0639 \u067e\u0648\u06cc\u0627 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0645\u0634\u062e\u0635 \u0634\u062f\u0647 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f <code>time_bucket<\/code> (\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u060c \u0633\u0627\u0639\u062a \u060c \u0631\u0648\u0632 \u060c \u0647\u0641\u062a\u0647 \u060c \u0645\u0627\u0647) \u0648 \u0631\u0648\u06cc\u062f\u0627\u062f\u0647\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0646\u0648\u0639 \u0648 \u0645\u062d\u062f\u0648\u062f\u0647 \u0632\u0645\u0627\u0646\u06cc. \u0627\u06cc\u0646 \u062a\u0639\u062f\u0627\u062f \u0648\u0642\u0627\u06cc\u0639 \u060c \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0648 \u062f\u0642\u062a \u0645\u062a\u0648\u0633\u0637 \u200b\u200b\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u06a9\u0627\u0646 \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc \u06a9\u0646\u062f. <\/p>\n<h3><span class=\"ez-toc-section\" id=\"%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1%D8%A7%D9%86_%D8%A7%D8%B7%D8%B1%D8%A7%D9%81\"><\/span>\n<p>  \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u0637\u0631\u0627\u0641<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062f\u0631 <code>nearby_users<\/code> \u0646\u0642\u0637\u0647 \u067e\u0627\u06cc\u0627\u0646\u06cc \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0631\u0627 \u062f\u0631 \u0634\u0639\u0627\u0639 \u0645\u0634\u062e\u0635\u06cc \u0627\u0632 \u0645\u062e\u062a\u0635\u0627\u062a \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u067e\u06cc\u062f\u0627 \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"n\">DESCRIPTION<\/span> <span class=\"o\">&gt;<\/span>\n    <span class=\"n\">Find<\/span> <span class=\"n\">users<\/span> <span class=\"n\">within<\/span> <span class=\"n\">a<\/span> <span class=\"n\">specified<\/span> <span class=\"n\">radius<\/span> <span class=\"k\">of<\/span> <span class=\"n\">a<\/span> <span class=\"n\">given<\/span> <span class=\"n\">coordinate<\/span>\n\n<span class=\"n\">NODE<\/span> <span class=\"n\">nearby_users_node<\/span>\n<span class=\"k\">SQL<\/span> <span class=\"o\">&gt;<\/span>\n    <span class=\"k\">SELECT<\/span> \n        <span class=\"n\">user_id<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">latitude<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">longitude<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">event_type<\/span><span class=\"p\">,<\/span>\n        <span class=\"nb\">timestamp<\/span><span class=\"p\">,<\/span>\n        <span class=\"mi\">111<\/span><span class=\"p\">.<\/span><span class=\"mi\">111<\/span> <span class=\"o\">*<\/span> \n        <span class=\"n\">SQRT<\/span><span class=\"p\">(<\/span>\n            <span class=\"n\">POW<\/span><span class=\"p\">(<\/span><span class=\"n\">latitude<\/span> <span class=\"o\">-<\/span> <span class=\"p\">{{<\/span><span class=\"n\">Float64<\/span><span class=\"p\">(<\/span><span class=\"n\">target_lat<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">0<\/span><span class=\"p\">)}},<\/span> <span class=\"mi\">2<\/span><span class=\"p\">)<\/span> <span class=\"o\">+<\/span> \n            <span class=\"n\">POW<\/span><span class=\"p\">(<\/span><span class=\"n\">longitude<\/span> <span class=\"o\">*<\/span> <span class=\"n\">COS<\/span><span class=\"p\">(<\/span><span class=\"n\">PI<\/span><span class=\"p\">()<\/span> <span class=\"o\">*<\/span> <span class=\"n\">latitude<\/span> <span class=\"o\">\/<\/span> <span class=\"mi\">180<\/span><span class=\"p\">.<\/span><span class=\"mi\">0<\/span><span class=\"p\">)<\/span> <span class=\"o\">-<\/span> <span class=\"p\">{{<\/span><span class=\"n\">Float64<\/span><span class=\"p\">(<\/span><span class=\"n\">target_lon<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">0<\/span><span class=\"p\">)}}<\/span> <span class=\"o\">*<\/span> <span class=\"n\">COS<\/span><span class=\"p\">(<\/span><span class=\"n\">PI<\/span><span class=\"p\">()<\/span> <span class=\"o\">*<\/span> <span class=\"p\">{{<\/span><span class=\"n\">Float64<\/span><span class=\"p\">(<\/span><span class=\"n\">target_lat<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">0<\/span><span class=\"p\">)}}<\/span> <span class=\"o\">\/<\/span> <span class=\"mi\">180<\/span><span class=\"p\">.<\/span><span class=\"mi\">0<\/span><span class=\"p\">),<\/span> <span class=\"mi\">2<\/span><span class=\"p\">)<\/span>\n        <span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">distance_km<\/span>\n    <span class=\"k\">FROM<\/span> <span class=\"n\">location_events<\/span>\n    <span class=\"k\">WHERE<\/span> \n        <span class=\"nb\">timestamp<\/span> <span class=\"o\">&gt;=<\/span> <span class=\"p\">{{<\/span><span class=\"nb\">DateTime<\/span><span class=\"p\">(<\/span><span class=\"n\">start_time<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'2023-01-01 00:00:00'<\/span><span class=\"p\">)}}<\/span> <span class=\"k\">AND<\/span> \n        <span class=\"nb\">timestamp<\/span> <span class=\"o\">&lt;=<\/span> <span class=\"p\">{{<\/span><span class=\"nb\">DateTime<\/span><span class=\"p\">(<\/span><span class=\"n\">end_time<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'2023-12-31 23:59:59'<\/span><span class=\"p\">)}}<\/span>\n        <span class=\"k\">AND<\/span> <span class=\"mi\">111<\/span><span class=\"p\">.<\/span><span class=\"mi\">111<\/span> <span class=\"o\">*<\/span> \n        <span class=\"n\">SQRT<\/span><span class=\"p\">(<\/span>\n            <span class=\"n\">POW<\/span><span class=\"p\">(<\/span><span class=\"n\">latitude<\/span> <span class=\"o\">-<\/span> <span class=\"p\">{{<\/span><span class=\"n\">Float64<\/span><span class=\"p\">(<\/span><span class=\"n\">target_lat<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">0<\/span><span class=\"p\">)}},<\/span> <span class=\"mi\">2<\/span><span class=\"p\">)<\/span> <span class=\"o\">+<\/span> \n            <span class=\"n\">POW<\/span><span class=\"p\">(<\/span><span class=\"n\">longitude<\/span> <span class=\"o\">*<\/span> <span class=\"n\">COS<\/span><span class=\"p\">(<\/span><span class=\"n\">PI<\/span><span class=\"p\">()<\/span> <span class=\"o\">*<\/span> <span class=\"n\">latitude<\/span> <span class=\"o\">\/<\/span> <span class=\"mi\">180<\/span><span class=\"p\">.<\/span><span class=\"mi\">0<\/span><span class=\"p\">)<\/span> <span class=\"o\">-<\/span> <span class=\"p\">{{<\/span><span class=\"n\">Float64<\/span><span class=\"p\">(<\/span><span class=\"n\">target_lon<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">0<\/span><span class=\"p\">)}}<\/span> <span class=\"o\">*<\/span> <span class=\"n\">COS<\/span><span class=\"p\">(<\/span><span class=\"n\">PI<\/span><span class=\"p\">()<\/span> <span class=\"o\">*<\/span> <span class=\"p\">{{<\/span><span class=\"n\">Float64<\/span><span class=\"p\">(<\/span><span class=\"n\">target_lat<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">0<\/span><span class=\"p\">)}}<\/span> <span class=\"o\">\/<\/span> <span class=\"mi\">180<\/span><span class=\"p\">.<\/span><span class=\"mi\">0<\/span><span class=\"p\">),<\/span> <span class=\"mi\">2<\/span><span class=\"p\">)<\/span>\n        <span class=\"p\">)<\/span> <span class=\"o\">&lt;=<\/span> <span class=\"p\">{{<\/span><span class=\"n\">Float64<\/span><span class=\"p\">(<\/span><span class=\"n\">radius_km<\/span><span class=\"p\">,<\/span> <span class=\"mi\">1<\/span><span class=\"p\">.<\/span><span class=\"mi\">0<\/span><span class=\"p\">)}}<\/span>\n    <span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">distance_km<\/span> <span class=\"k\">ASC<\/span>\n    <span class=\"k\">LIMIT<\/span> <span class=\"p\">{{<\/span><span class=\"n\">Int32<\/span><span class=\"p\">(<\/span><span class=\"k\">limit<\/span><span class=\"p\">,<\/span> <span class=\"mi\">100<\/span><span class=\"p\">)}}<\/span>\n\n<span class=\"k\">TYPE<\/span> <span class=\"n\">endpoint<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0644\u0648\u0644\u0647 \u0641\u0627\u0635\u0644\u0647 \u0628\u06cc\u0646 \u06cc\u06a9 \u0645\u06a9\u0627\u0646 \u0647\u062f\u0641 \u0648 \u0645\u062e\u062a\u0635\u0627\u062a \u0647\u0631 \u0631\u0648\u06cc\u062f\u0627\u062f \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc \u06a9\u0646\u062f \u060c \u0646\u062a\u0627\u06cc\u062c \u0641\u06cc\u0644\u062a\u0631 \u0631\u0627 \u0628\u0627 \u0641\u0627\u0635\u0644\u0647 \u060c \u0632\u0645\u0627\u0646 \u0648 \u0645\u062d\u062f\u0648\u062f \u06a9\u0631\u062f\u0646 \u062a\u0639\u062f\u0627\u062f \u0646\u062a\u0627\u06cc\u062c \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc \u06a9\u0646\u062f. \u0627\u06cc\u0646 \u06cc\u06a9 \u0631\u0648\u0634 \u06a9\u0627\u0631\u0622\u0645\u062f \u0628\u0631\u0627\u06cc \u06cc\u0627\u0641\u062a\u0646 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0645\u062c\u0627\u0648\u0631 \u062f\u0631 \u0634\u0639\u0627\u0639 \u0645\u0639\u06cc\u0646 \u0627\u0633\u062a. <\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B9%D8%B2%D8%A7%D9%85_%D8%A8%D9%87_%D8%AA%D9%88%D9%84%DB%8C%D8%AF\"><\/span>\n<p>  \u0627\u0639\u0632\u0627\u0645 \u0628\u0647 \u062a\u0648\u0644\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u0633\u062a\u0642\u0631\u0627\u0631 \u067e\u0631\u0648\u0698\u0647 \u062e\u0648\u062f \u0628\u0647 Tinybird Cloud \u0633\u0627\u062f\u0647 \u0628\u0627 <code>tb --cloud deploy<\/code> \u0641\u0631\u0645\u0627\u0646 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0646\u0642\u0627\u0637 \u067e\u0627\u06cc\u0627\u0646\u06cc API \u0622\u0645\u0627\u062f\u0647 \u062a\u0648\u0644\u06cc\u062f \u0648 \u0645\u0642\u06cc\u0627\u0633 \u067e\u0630\u06cc\u0631 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f. Tinybird \u0645\u0646\u0627\u0628\u0639 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06a9\u062f \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc \u06a9\u0646\u062f \u060c \u06a9\u0647 \u0628\u0627 \u0627\u062c\u0627\u0632\u0647 \u0627\u0633\u062a\u0642\u0631\u0627\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0648 \u06a9\u0646\u062a\u0631\u0644 \u0646\u0633\u062e\u0647 \u062e\u0637\u0648\u0637 \u0644\u0648\u0644\u0647 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0634\u0645\u0627 \u060c \u06af\u0631\u062f\u0634 \u06a9\u0627\u0631 CI\/CD \u0631\u0627 \u062a\u06a9\u0645\u06cc\u0644 \u0645\u06cc \u06a9\u0646\u062f. \u062a\u0623\u0645\u06cc\u0646 \u0627\u0645\u0646\u06cc\u062a API \u0647\u0627\u06cc \u0634\u0645\u0627 \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a \u060c \u0648 Tinybird \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u062a\u0648\u06a9\u0646 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u0627\u06cc\u0646\u06a9\u0647 \u0641\u0642\u0637 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0647\u0627\u06cc \u0645\u062c\u0627\u0632 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0646\u0642\u0627\u0637 \u067e\u0627\u06cc\u0627\u0646\u06cc \u0634\u0645\u0627 \u062f\u0633\u062a\u0631\u0633\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0646\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0646\u062d\u0648\u0647 \u062a\u0645\u0627\u0633 \u0628\u0627 \u06cc\u06a9\u06cc \u0627\u0632 \u0646\u0642\u0627\u0637 \u067e\u0627\u06cc\u0627\u0646\u06cc \u0645\u0633\u062a\u0642\u0631 \u0622\u0645\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code>curl <span class=\"nt\">-X<\/span> GET <span class=\"s2\">\"https:\/\/api.europe-west2.gcp.tinybird.co\/v0\/pipes\/user_location_history.json?token=%24TB_ADMIN_TOKEN&amp;user_id=user_123&amp;start_time=2023-01-01+00%3A00%3A00&amp;end_time=2023-12-31+23%3A59%3A59&amp;limit=500&amp;utm_source=DEV&amp;utm_campaign=tb+create+--prompt+DEV\"<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D9%BE%D8%A7%DB%8C%D8%A7%D9%86\"><\/span>\n<p>  \u067e\u0627\u06cc\u0627\u0646<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u060c \u0634\u0645\u0627 \u06cc\u06a9 API \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0628\u0627 Tinybird \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f. \u0634\u0645\u0627 \u0622\u0645\u0648\u062e\u062a\u0647 \u0627\u06cc\u062f \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f \u060c \u0622\u0646 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0628\u06cc\u0646\u0634 \u0647\u0627\u06cc \u0645\u0639\u0646\u06cc \u062f\u0627\u0631 \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u06cc\u062f \u0648 API \u0647\u0627\u06cc \u0645\u0642\u06cc\u0627\u0633 \u067e\u0630\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0645\u0648\u0627\u0631\u062f \u0645\u062e\u062a\u0644\u0641 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0698\u0626\u0648\u0644\u06cc\u0627\u06a9 \u0645\u0633\u062a\u0642\u0631 \u06a9\u0646\u06cc\u062f. Tinybird \u0631\u0648\u0646\u062f \u0633\u0627\u062e\u062a \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062e\u0637\u0648\u0637 \u0644\u0648\u0644\u0647 \u062f\u0627\u062f\u0647 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0631\u0627 \u0633\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u062a\u0627 \u0631\u0648\u06cc \u0627\u06cc\u062c\u0627\u062f \u0627\u0631\u0632\u0634 \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0648\u062f \u062a\u0645\u0631\u06a9\u0632 \u06a9\u0646\u06cc\u062f. \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a \u0648 \u0627\u0633\u062a\u0642\u0631\u0627\u0631 \u0627\u0648\u0644\u06cc\u0646 API \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u062e\u0648\u062f \u062f\u0631 \u0686\u0646\u062f \u062f\u0642\u06cc\u0642\u0647 \u062f\u0631 Tinybird \u062b\u0628\u062a \u0646\u0627\u0645 \u06a9\u0646\u06cc\u062f. Tinybird \u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639 \u06a9\u0627\u0631 \u0631\u0627\u06cc\u06af\u0627\u0646 \u0627\u0633\u062a \u060c \u0628\u062f\u0648\u0646 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a \u0632\u0645\u0627\u0646\u06cc \u0648 \u06a9\u0627\u0631\u062a \u0627\u0639\u062a\u0628\u0627\u0631\u06cc \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u060c \u0634\u0645\u0627 \u0631\u0627 \u0642\u0627\u062f\u0631 \u0645\u06cc \u0633\u0627\u0632\u062f \u062a\u0627 \u067e\u0631\u0648\u0698\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u06a9\u0627\u0631\u0622\u0645\u062f \u0622\u0632\u0645\u0627\u06cc\u0634 \u0648 \u0645\u0642\u06cc\u0627\u0633 \u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062d\u0631\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u0631\u062f\u06cc\u0627\u0628\u06cc \u0645\u06cc \u06a9\u0646\u0646\u062f \u060c \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0627\u0644\u06af\u0648\u0647\u0627\u06cc \u0645\u06a9\u0627\u0646\u06cc \u06cc\u0627 \u0627\u0631\u0627\u0626\u0647 \u062e\u062f\u0645\u0627\u062a \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0645\u0648\u0642\u0639\u06cc\u062a \u0645\u06a9\u0627\u0646\u06cc \u0645\u062d\u0648\u0631\u06cc \u0627\u0633\u062a. \u0627\u06cc\u0646 \u06a9\u0647 \u0622\u06cc\u0627 \u0627\u06cc\u0646 \u0628\u0631\u0627\u06cc \u0631\u062f\u06cc\u0627\u0628\u06cc \u0648\u0633\u0627\u06cc\u0644 \u0646\u0642\u0644\u06cc\u0647 \u062a\u062d\u0648\u06cc\u0644 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u060c \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062a\u0631\u0627\u0641\u06cc\u06a9 \u067e\u0627 \u062f\u0631 \u06cc\u06a9 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062e\u0631\u062f\u0647 \u0641\u0631\u0648\u0634\u06cc \u06cc\u0627 \u062a\u0647\u06cc\u0647 \u0645\u062d\u062a\u0648\u0627\u06cc \u0634\u062e\u0635\u06cc &hellip;<\/p>\n","protected":false},"author":2,"featured_media":108857,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-108856","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/108856","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=108856"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/108856\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/108857"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=108856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=108856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=108856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}