{"id":93109,"date":"2025-01-15T19:35:41","date_gmt":"2025-01-15T16:05:41","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/%da%98%d9%86%d8%b1%d8%a7%d8%aa%d9%88%d8%b1-%d8%b3%d8%a7%d8%af%d9%87-sql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-aws-bedrock\/"},"modified":"2025-01-15T19:35:41","modified_gmt":"2025-01-15T16:05:41","slug":"%da%98%d9%86%d8%b1%d8%a7%d8%aa%d9%88%d8%b1-%d8%b3%d8%a7%d8%af%d9%87-sql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-aws-bedrock","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/%da%98%d9%86%d8%b1%d8%a7%d8%aa%d9%88%d8%b1-%d8%b3%d8%a7%d8%af%d9%87-sql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-aws-bedrock\/","title":{"rendered":"\u0698\u0646\u0631\u0627\u062a\u0648\u0631 \u0633\u0627\u062f\u0647 SQL \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 AWS Bedrock"},"content":{"rendered":"<div data-article-id=\"2211447\" id=\"article-body\">\n<p>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0639\u0648\u0627\u0645\u0644 AWS Bedrock \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631 \u0628\u0647 \u0639\u0628\u0627\u0631\u0627\u062a SQL \u0634\u0627\u0645\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062f\u0644 \u0647\u0627\u06cc \u0632\u0628\u0627\u0646 \u0628\u0632\u0631\u06af Bedrock (LLM) \u0648 \u0637\u0631\u0627\u062d\u06cc \u0633\u06cc\u0633\u062a\u0645\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0637\u0631\u062d\u0648\u0627\u0631\u0647\u060c \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u06a9\u0627\u0631\u0628\u0631 \u0648 \u0641\u0631\u0622\u06cc\u0646\u062f \u062a\u0648\u0644\u06cc\u062f SQL \u0631\u0627 \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u0645\u06cc \u06a9\u0646\u062f. \u062f\u0631 \u0632\u06cc\u0631 \u06cc\u06a9 \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06af\u0627\u0645 \u0628\u0647 \u06af\u0627\u0645 \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u06cc\u0627\u0628\u06cc \u0628\u0647 \u0627\u06cc\u0646 \u0627\u0645\u0631 \u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<hr\/>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/%da%98%d9%86%d8%b1%d8%a7%d8%aa%d9%88%d8%b1-%d8%b3%d8%a7%d8%af%d9%87-sql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-aws-bedrock\/#1-%D9%85%D8%B4%DA%A9%D9%84_%D8%B1%D8%A7_%D8%AA%D8%B9%D8%B1%DB%8C%D9%81_%DA%A9%D9%86%DB%8C%D8%AF\" >1-\u0645\u0634\u06a9\u0644 \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/%da%98%d9%86%d8%b1%d8%a7%d8%aa%d9%88%d8%b1-%d8%b3%d8%a7%d8%af%d9%87-sql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-aws-bedrock\/#2_AWS_Bedrock_%D8%B1%D8%A7_%D8%B1%D8%A7%D9%87_%D8%A7%D9%86%D8%AF%D8%A7%D8%B2%DB%8C_%DA%A9%D9%86%DB%8C%D8%AF\" >2. AWS Bedrock \u0631\u0627 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/%da%98%d9%86%d8%b1%d8%a7%d8%aa%d9%88%d8%b1-%d8%b3%d8%a7%d8%af%d9%87-sql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-aws-bedrock\/#3_%D9%85%D8%AD%DB%8C%D8%B7_%D8%B1%D8%A7_%D8%A2%D9%85%D8%A7%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\" >3. \u0645\u062d\u06cc\u0637 \u0631\u0627 \u0622\u0645\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/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\/%da%98%d9%86%d8%b1%d8%a7%d8%aa%d9%88%d8%b1-%d8%b3%d8%a7%d8%af%d9%87-sql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-aws-bedrock\/#4_Input_Schema_%D8%B1%D8%A7_%D8%AA%D8%B9%D8%B1%DB%8C%D9%81_%DA%A9%D9%86%DB%8C%D8%AF\" >4. Input Schema \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f<\/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\/%da%98%d9%86%d8%b1%d8%a7%d8%aa%d9%88%d8%b1-%d8%b3%d8%a7%d8%af%d9%87-sql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-aws-bedrock\/#5_%D8%A7%D8%B2_Bedrock_%D8%A8%D8%B1%D8%A7%DB%8C_%D8%AA%D9%88%D9%84%DB%8C%D8%AF_SQL_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\" >5. \u0627\u0632 Bedrock \u0628\u0631\u0627\u06cc \u062a\u0648\u0644\u06cc\u062f SQL \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/%da%98%d9%86%d8%b1%d8%a7%d8%aa%d9%88%d8%b1-%d8%b3%d8%a7%d8%af%d9%87-sql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-aws-bedrock\/#%D9%85%D8%AB%D8%A7%D9%84_%DA%A9%D8%AF_%D9%BE%D8%A7%DB%8C%D8%AA%D9%88%D9%86\" >\u0645\u062b\u0627\u0644 \u06a9\u062f \u067e\u0627\u06cc\u062a\u0648\u0646:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nabfollower.com\/blog\/%da%98%d9%86%d8%b1%d8%a7%d8%aa%d9%88%d8%b1-%d8%b3%d8%a7%d8%af%d9%87-sql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-aws-bedrock\/#6_%D8%A7%D8%B9%D8%AA%D8%A8%D8%A7%D8%B1%D8%B3%D9%86%D8%AC%DB%8C_%D9%88_%D8%A2%D8%B2%D9%85%D8%A7%DB%8C%D8%B4\" >6. \u0627\u0639\u062a\u0628\u0627\u0631\u0633\u0646\u062c\u06cc \u0648 \u0622\u0632\u0645\u0627\u06cc\u0634<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nabfollower.com\/blog\/%da%98%d9%86%d8%b1%d8%a7%d8%aa%d9%88%d8%b1-%d8%b3%d8%a7%d8%af%d9%87-sql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-aws-bedrock\/#7_%D8%A7%D8%AE%D8%AA%DB%8C%D8%A7%D8%B1%DB%8C_%D8%A8%D9%87_%D8%B9%D9%86%D9%88%D8%A7%D9%86_%DB%8C%DA%A9_API_%D9%85%D8%B3%D8%AA%D9%82%D8%B1_%D8%B4%D9%88%D8%AF\" >7. (\u0627\u062e\u062a\u06cc\u0627\u0631\u06cc) \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 API \u0645\u0633\u062a\u0642\u0631 \u0634\u0648\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/nabfollower.com\/blog\/%da%98%d9%86%d8%b1%d8%a7%d8%aa%d9%88%d8%b1-%d8%b3%d8%a7%d8%af%d9%87-sql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-aws-bedrock\/#8_%D8%A8%D8%A7_%DB%8C%D8%A7%D8%AF%DA%AF%DB%8C%D8%B1%DB%8C_%DA%86%D9%86%D8%AF_%D8%B4%D8%A7%D8%AA_%D8%AA%D9%82%D9%88%DB%8C%D8%AA_%DA%A9%D9%86%DB%8C%D8%AF\" >8. \u0628\u0627 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0686\u0646\u062f \u0634\u0627\u062a \u062a\u0642\u0648\u06cc\u062a \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/nabfollower.com\/blog\/%da%98%d9%86%d8%b1%d8%a7%d8%aa%d9%88%d8%b1-%d8%b3%d8%a7%d8%af%d9%87-sql-%d8%a8%d8%a7-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-aws-bedrock\/#9_%D9%86%D8%B8%D8%A7%D8%B1%D8%AA_%D9%88_%D8%AA%DA%A9%D8%B1%D8%A7%D8%B1\" >9. \u0646\u0638\u0627\u0631\u062a \u0648 \u062a\u06a9\u0631\u0627\u0631<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"1-%D9%85%D8%B4%DA%A9%D9%84_%D8%B1%D8%A7_%D8%AA%D8%B9%D8%B1%DB%8C%D9%81_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  <strong>1-\u0645\u0634\u06a9\u0644 \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f<\/strong><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0647\u062f\u0641 \u0634\u0645\u0627 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u06cc\u06a9 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u06a9\u0627\u0631\u0628\u0631 (\u0628\u0647 \u0632\u0628\u0627\u0646 \u0637\u0628\u06cc\u0639\u06cc) \u0631\u0627 \u0628\u0647 \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 SQL \u0628\u0631 \u0627\u0633\u0627\u0633 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u0632 \u067e\u06cc\u0634 \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u06cc\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:<\/p>\n<ul>\n<li>\n<strong>\u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0627\u0631\u0628\u0631<\/strong>: &#8220;\u0646\u0627\u0645 \u0647\u0645\u0647 \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646 \u0628\u062e\u0634 \u0641\u0631\u0648\u0634 \u0631\u0627 \u0628\u06cc\u0627\u0628\u06cc\u062f.&#8221;<\/li>\n<li>\n<strong>\u0637\u0631\u062d \u0648\u0627\u0631\u0647 \u062c\u062f\u0648\u0644<\/strong>:\n<\/li>\n<\/ul>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight json\"><code><span class=\"p\">{<\/span><span class=\"w\">\n  <\/span><span class=\"nl\">\"table_name\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"employees\"<\/span><span class=\"p\">,<\/span><span class=\"w\">\n  <\/span><span class=\"nl\">\"columns\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"p\">[<\/span><span class=\"w\">\n    <\/span><span class=\"p\">{<\/span><span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"id\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"type\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"INTEGER\"<\/span><span class=\"p\">},<\/span><span class=\"w\">\n    <\/span><span class=\"p\">{<\/span><span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"name\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"type\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"VARCHAR\"<\/span><span class=\"p\">},<\/span><span class=\"w\">\n    <\/span><span class=\"p\">{<\/span><span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"department\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"type\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"VARCHAR\"<\/span><span class=\"p\">},<\/span><span class=\"w\">\n    <\/span><span class=\"p\">{<\/span><span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"salary\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"type\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"FLOAT\"<\/span><span class=\"p\">}<\/span><span class=\"w\">\n  <\/span><span class=\"p\">]<\/span><span class=\"w\">\n<\/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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span> <span class=\"n\">name<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">employees<\/span> <span class=\"k\">WHERE<\/span> <span class=\"n\">department<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'Sales'<\/span><span class=\"p\">;<\/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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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<hr\/>\n<h3><span class=\"ez-toc-section\" id=\"2_AWS_Bedrock_%D8%B1%D8%A7_%D8%B1%D8%A7%D9%87_%D8%A7%D9%86%D8%AF%D8%A7%D8%B2%DB%8C_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  <strong>2. AWS Bedrock \u0631\u0627 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f<\/strong><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>AWS Bedrock \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0628\u062f\u0648\u0646 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0632\u06cc\u0631\u0633\u0627\u062e\u062a \u0628\u0647 \u0645\u062f\u0644 \u0647\u0627\u06cc \u067e\u0627\u06cc\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u0648 \u0627\u0632 \u0622\u0646\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0646\u062d\u0648\u0647 \u0627\u062f\u0627\u0645\u0647 \u06a9\u0627\u0631 \u0622\u0645\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<ol>\n<li>\n<strong>Bedrock \u0631\u0627 \u062f\u0631 \u062d\u0633\u0627\u0628 AWS \u062e\u0648\u062f \u0641\u0639\u0627\u0644 \u06a9\u0646\u06cc\u062f<\/strong>.<\/li>\n<li>\n<strong>\u06cc\u06a9 \u0645\u062f\u0644 \u0641\u0648\u0646\u062f\u0627\u0633\u06cc\u0648\u0646 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f<\/strong> \u0627\u0632 \u06af\u0632\u06cc\u0646\u0647 \u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f Bedrock (\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c Anthropic\u060c Cohere\u060c \u06cc\u0627 \u062f\u06cc\u06af\u0631\u0627\u0646).<\/li>\n<li>\n<strong>\u0628\u0647 Bedrock SDK \u062f\u0633\u062a\u0631\u0633\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f<\/strong> \u0627\u0632 \u0637\u0631\u06cc\u0642 AWS CLI\u060c SDK \u06cc\u0627 \u06a9\u0646\u0633\u0648\u0644.<\/li>\n<\/ol>\n<hr\/>\n<h3><span class=\"ez-toc-section\" id=\"3_%D9%85%D8%AD%DB%8C%D8%B7_%D8%B1%D8%A7_%D8%A2%D9%85%D8%A7%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  <strong>3. \u0645\u062d\u06cc\u0637 \u0631\u0627 \u0622\u0645\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/strong><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>\n<strong>SDK \u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f<\/strong>: AWS SDK \u0631\u0627 \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u062a\u0648\u0646 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f (<code>boto3<\/code>) \u0628\u0631\u0627\u06cc \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u062e\u062f\u0645\u0627\u062a AWS:\n<\/li>\n<\/ol>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code>   pip <span class=\"nb\">install <\/span>boto3\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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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<ol>\n<li>\n<strong>\u0646\u0642\u0634 \u0647\u0627\u06cc IAM \u0631\u0627 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f<\/strong>: \u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u0646\u0642\u0634 \u0634\u0645\u0627 \u062f\u0627\u0631\u0627\u06cc \u0645\u062c\u0648\u0632 \u0628\u0631\u0627\u06cc Bedrock \u0627\u0633\u062a:<\/p>\n<ul>\n<li><code>bedrock:InvokeModel<\/code><\/li>\n<li><code>bedrock:ListModels<\/code><\/li>\n<li><code>bedrock:ListFoundationModels<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<hr\/>\n<h3><span class=\"ez-toc-section\" id=\"4_Input_Schema_%D8%B1%D8%A7_%D8%AA%D8%B9%D8%B1%DB%8C%D9%81_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  <strong>4. Input Schema \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f<\/strong><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0637\u0631\u062d \u0648\u0631\u0648\u062f\u06cc \u0634\u0645\u0627 \u0634\u0627\u0645\u0644 \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n<ul>\n<li>\n<strong>\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0632\u0628\u0627\u0646 \u0637\u0628\u06cc\u0639\u06cc<\/strong>: \u06cc\u06a9 \u067e\u06cc\u0627\u0645 \u0645\u062a\u0646\u06cc \u0627\u0631\u0627\u0626\u0647 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u06a9\u0627\u0631\u0628\u0631.<\/li>\n<li>\n<strong>\u0637\u0631\u062d \u0648\u0627\u0631\u0647 \u062c\u062f\u0648\u0644<\/strong>: JSON \u0637\u0631\u062d\u0648\u0627\u0631\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u062a\u0648\u0635\u06cc\u0641 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<\/ul>\n<p>\u0648\u0631\u0648\u062f\u06cc \u0646\u0645\u0648\u0646\u0647 \u0628\u0631\u0627\u06cc LLM:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight json\"><code><span class=\"p\">{<\/span><span class=\"w\">\n  <\/span><span class=\"nl\">\"query\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"Find the names of all employees in the Sales department.\"<\/span><span class=\"p\">,<\/span><span class=\"w\">\n  <\/span><span class=\"nl\">\"schema\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"p\">{<\/span><span class=\"w\">\n    <\/span><span class=\"nl\">\"table_name\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"employees\"<\/span><span class=\"p\">,<\/span><span class=\"w\">\n    <\/span><span class=\"nl\">\"columns\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"p\">[<\/span><span class=\"w\">\n      <\/span><span class=\"p\">{<\/span><span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"id\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"type\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"INTEGER\"<\/span><span class=\"p\">},<\/span><span class=\"w\">\n      <\/span><span class=\"p\">{<\/span><span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"name\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"type\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"VARCHAR\"<\/span><span class=\"p\">},<\/span><span class=\"w\">\n      <\/span><span class=\"p\">{<\/span><span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"department\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"type\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"VARCHAR\"<\/span><span class=\"p\">},<\/span><span class=\"w\">\n      <\/span><span class=\"p\">{<\/span><span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"salary\"<\/span><span class=\"p\">,<\/span><span class=\"w\"> <\/span><span class=\"nl\">\"type\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"FLOAT\"<\/span><span class=\"p\">}<\/span><span class=\"w\">\n    <\/span><span class=\"p\">]<\/span><span class=\"w\">\n  <\/span><span class=\"p\">}<\/span><span class=\"w\">\n<\/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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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<hr\/>\n<h3><span class=\"ez-toc-section\" id=\"5_%D8%A7%D8%B2_Bedrock_%D8%A8%D8%B1%D8%A7%DB%8C_%D8%AA%D9%88%D9%84%DB%8C%D8%AF_SQL_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  <strong>5. \u0627\u0632 Bedrock \u0628\u0631\u0627\u06cc \u062a\u0648\u0644\u06cc\u062f SQL \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/strong><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0646\u062d\u0648\u0647 \u0627\u0631\u0633\u0627\u0644 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0648 \u0637\u0631\u062d\u0648\u0627\u0631\u0647 \u0628\u0647 Bedrock \u0622\u0645\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"%D9%85%D8%AB%D8%A7%D9%84_%DA%A9%D8%AF_%D9%BE%D8%A7%DB%8C%D8%AA%D9%88%D9%86\"><\/span>\n<p>  <strong>\u0645\u062b\u0627\u0644 \u06a9\u062f \u067e\u0627\u06cc\u062a\u0648\u0646<\/strong>:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight python\"><code><span class=\"kn\">import<\/span> <span class=\"n\">boto3<\/span>\n<span class=\"kn\">import<\/span> <span class=\"n\">json<\/span>\n\n<span class=\"c1\"># Initialize Bedrock client\n<\/span><span class=\"n\">bedrock_client<\/span> <span class=\"o\">=<\/span> <span class=\"n\">boto3<\/span><span class=\"p\">.<\/span><span class=\"nf\">client<\/span><span class=\"p\">(<\/span><span class=\"sh\">'<\/span><span class=\"s\">bedrock<\/span><span class=\"sh\">'<\/span><span class=\"p\">,<\/span> <span class=\"n\">region_name<\/span><span class=\"o\">=<\/span><span class=\"sh\">'<\/span><span class=\"s\">us-east-1<\/span><span class=\"sh\">'<\/span><span class=\"p\">)<\/span>\n\n<span class=\"c1\"># Input schema and user query\n<\/span><span class=\"n\">input_data<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{<\/span>\n    <span class=\"sh\">\"<\/span><span class=\"s\">query<\/span><span class=\"sh\">\"<\/span><span class=\"p\">:<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">Find the names of all employees in the Sales department.<\/span><span class=\"sh\">\"<\/span><span class=\"p\">,<\/span>\n    <span class=\"sh\">\"<\/span><span class=\"s\">schema<\/span><span class=\"sh\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\n        <span class=\"sh\">\"<\/span><span class=\"s\">table_name<\/span><span class=\"sh\">\"<\/span><span class=\"p\">:<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">employees<\/span><span class=\"sh\">\"<\/span><span class=\"p\">,<\/span>\n        <span class=\"sh\">\"<\/span><span class=\"s\">columns<\/span><span class=\"sh\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\n            <span class=\"p\">{<\/span><span class=\"sh\">\"<\/span><span class=\"s\">name<\/span><span class=\"sh\">\"<\/span><span class=\"p\">:<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">id<\/span><span class=\"sh\">\"<\/span><span class=\"p\">,<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">type<\/span><span class=\"sh\">\"<\/span><span class=\"p\">:<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">INTEGER<\/span><span class=\"sh\">\"<\/span><span class=\"p\">},<\/span>\n            <span class=\"p\">{<\/span><span class=\"sh\">\"<\/span><span class=\"s\">name<\/span><span class=\"sh\">\"<\/span><span class=\"p\">:<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">name<\/span><span class=\"sh\">\"<\/span><span class=\"p\">,<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">type<\/span><span class=\"sh\">\"<\/span><span class=\"p\">:<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">VARCHAR<\/span><span class=\"sh\">\"<\/span><span class=\"p\">},<\/span>\n            <span class=\"p\">{<\/span><span class=\"sh\">\"<\/span><span class=\"s\">name<\/span><span class=\"sh\">\"<\/span><span class=\"p\">:<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">department<\/span><span class=\"sh\">\"<\/span><span class=\"p\">,<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">type<\/span><span class=\"sh\">\"<\/span><span class=\"p\">:<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">VARCHAR<\/span><span class=\"sh\">\"<\/span><span class=\"p\">},<\/span>\n            <span class=\"p\">{<\/span><span class=\"sh\">\"<\/span><span class=\"s\">name<\/span><span class=\"sh\">\"<\/span><span class=\"p\">:<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">salary<\/span><span class=\"sh\">\"<\/span><span class=\"p\">,<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">type<\/span><span class=\"sh\">\"<\/span><span class=\"p\">:<\/span> <span class=\"sh\">\"<\/span><span class=\"s\">FLOAT<\/span><span class=\"sh\">\"<\/span><span class=\"p\">}<\/span>\n        <span class=\"p\">]<\/span>\n    <span class=\"p\">}<\/span>\n<span class=\"p\">}<\/span>\n\n<span class=\"c1\"># Prepare prompt for the LLM\n<\/span><span class=\"n\">prompt<\/span> <span class=\"o\">=<\/span> <span class=\"sa\">f<\/span><span class=\"sh\">\"\"\"<\/span><span class=\"s\">\nGenerate an SQL query based on the following table schema and user request:\n\nTable Schema:\n<\/span><span class=\"si\">{<\/span><span class=\"n\">json<\/span><span class=\"p\">.<\/span><span class=\"nf\">dumps<\/span><span class=\"p\">(<\/span><span class=\"n\">input_data<\/span><span class=\"p\">[<\/span><span class=\"sh\">'<\/span><span class=\"s\">schema<\/span><span class=\"sh\">'<\/span><span class=\"p\">],<\/span> <span class=\"n\">indent<\/span><span class=\"o\">=<\/span><span class=\"mi\">2<\/span><span class=\"p\">)<\/span><span class=\"si\">}<\/span><span class=\"s\">\n\nUser Query:\n<\/span><span class=\"si\">{<\/span><span class=\"n\">input_data<\/span><span class=\"p\">[<\/span><span class=\"sh\">'<\/span><span class=\"s\">query<\/span><span class=\"sh\">'<\/span><span class=\"p\">]<\/span><span class=\"si\">}<\/span><span class=\"s\">\n\nSQL Query:\n<\/span><span class=\"sh\">\"\"\"<\/span>\n\n<span class=\"c1\"># Invoke the Bedrock model\n<\/span><span class=\"n\">response<\/span> <span class=\"o\">=<\/span> <span class=\"n\">bedrock_client<\/span><span class=\"p\">.<\/span><span class=\"nf\">invoke_model<\/span><span class=\"p\">(<\/span>\n    <span class=\"n\">modelId<\/span><span class=\"o\">=<\/span><span class=\"sh\">'<\/span><span class=\"s\">your-chosen-model-id<\/span><span class=\"sh\">'<\/span><span class=\"p\">,<\/span>  <span class=\"c1\"># Replace with the specific model ID from Bedrock\n<\/span>    <span class=\"n\">body<\/span><span class=\"o\">=<\/span><span class=\"n\">json<\/span><span class=\"p\">.<\/span><span class=\"nf\">dumps<\/span><span class=\"p\">({<\/span><span class=\"sh\">\"<\/span><span class=\"s\">prompt<\/span><span class=\"sh\">\"<\/span><span class=\"p\">:<\/span> <span class=\"n\">prompt<\/span><span class=\"p\">}),<\/span>\n    <span class=\"n\">contentType<\/span><span class=\"o\">=<\/span><span class=\"sh\">'<\/span><span class=\"s\">application\/json<\/span><span class=\"sh\">'<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">accept<\/span><span class=\"o\">=<\/span><span class=\"sh\">'<\/span><span class=\"s\">application\/json<\/span><span class=\"sh\">'<\/span>\n<span class=\"p\">)<\/span>\n\n<span class=\"c1\"># Extract the SQL query\n<\/span><span class=\"n\">model_output<\/span> <span class=\"o\">=<\/span> <span class=\"n\">json<\/span><span class=\"p\">.<\/span><span class=\"nf\">loads<\/span><span class=\"p\">(<\/span><span class=\"n\">response<\/span><span class=\"p\">[<\/span><span class=\"sh\">'<\/span><span class=\"s\">body<\/span><span class=\"sh\">'<\/span><span class=\"p\">])<\/span>\n<span class=\"n\">sql_query<\/span> <span class=\"o\">=<\/span> <span class=\"n\">model_output<\/span><span class=\"p\">[<\/span><span class=\"sh\">'<\/span><span class=\"s\">completions<\/span><span class=\"sh\">'<\/span><span class=\"p\">][<\/span><span class=\"mi\">0<\/span><span class=\"p\">][<\/span><span class=\"sh\">'<\/span><span class=\"s\">data<\/span><span class=\"sh\">'<\/span><span class=\"p\">][<\/span><span class=\"sh\">'<\/span><span class=\"s\">text<\/span><span class=\"sh\">'<\/span><span class=\"p\">]<\/span>\n\n<span class=\"nf\">print<\/span><span class=\"p\">(<\/span><span class=\"sh\">\"<\/span><span class=\"s\">Generated SQL Query:<\/span><span class=\"sh\">\"<\/span><span class=\"p\">)<\/span>\n<span class=\"nf\">print<\/span><span class=\"p\">(<\/span><span class=\"n\">sql_query<\/span><span class=\"p\">)<\/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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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<hr\/>\n<h3><span class=\"ez-toc-section\" id=\"6_%D8%A7%D8%B9%D8%AA%D8%A8%D8%A7%D8%B1%D8%B3%D9%86%D8%AC%DB%8C_%D9%88_%D8%A2%D8%B2%D9%85%D8%A7%DB%8C%D8%B4\"><\/span>\n<p>  <strong>6. \u0627\u0639\u062a\u0628\u0627\u0631\u0633\u0646\u062c\u06cc \u0648 \u0622\u0632\u0645\u0627\u06cc\u0634<\/strong><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>\n<strong>\u0639\u0627\u0645\u0644 \u0631\u0627 \u062a\u0633\u062a \u06a9\u0646\u06cc\u062f<\/strong>:<\/p>\n<ul>\n<li>\u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u062f\u0647\u06cc\u062f \u0648 SQL \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647 \u0631\u0627 \u062a\u0623\u06cc\u06cc\u062f \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<\/li>\n<li>\n<strong>\u0642\u0648\u0627\u0646\u06cc\u0646 \u0627\u0639\u062a\u0628\u0627\u0631 \u0633\u0646\u062c\u06cc \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f<\/strong>:<\/p>\n<ul>\n<li>\u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u062d\u0627\u0635\u0644 \u06a9\u0646\u06cc\u062f \u06a9\u0647 SQL \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647 \u0628\u0627 \u0637\u0631\u062d \u0634\u0645\u0627 \u0647\u0645\u0627\u0647\u0646\u06af \u0627\u0633\u062a \u0648 \u0627\u0632 \u062a\u0632\u0631\u06cc\u0642 SQL \u0645\u062d\u0627\u0641\u0638\u062a \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<hr\/>\n<h3><span class=\"ez-toc-section\" id=\"7_%D8%A7%D8%AE%D8%AA%DB%8C%D8%A7%D8%B1%DB%8C_%D8%A8%D9%87_%D8%B9%D9%86%D9%88%D8%A7%D9%86_%DB%8C%DA%A9_API_%D9%85%D8%B3%D8%AA%D9%82%D8%B1_%D8%B4%D9%88%D8%AF\"><\/span>\n<p>  <strong>7. (\u0627\u062e\u062a\u06cc\u0627\u0631\u06cc) \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 API \u0645\u0633\u062a\u0642\u0631 \u0634\u0648\u062f<\/strong><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0631\u0627\u0647 \u062d\u0644 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 API \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 AWS Lambda \u0648 API Gateway \u0645\u0633\u062a\u0642\u0631 \u06a9\u0646\u06cc\u062f:<\/p>\n<ol>\n<li>\u06cc\u06a9 \u062a\u0627\u0628\u0639 Lambda \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u0648\u0631\u0648\u062f\u06cc \u0648 \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u0645\u062f\u0644 Bedrock \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u0627\u0632 API Gateway \u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062a\u0627\u0628\u0639 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0646\u0642\u0637\u0647 \u067e\u0627\u06cc\u0627\u0646\u06cc HTTP \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ol>\n<hr\/>\n<h3><span class=\"ez-toc-section\" id=\"8_%D8%A8%D8%A7_%DB%8C%D8%A7%D8%AF%DA%AF%DB%8C%D8%B1%DB%8C_%DA%86%D9%86%D8%AF_%D8%B4%D8%A7%D8%AA_%D8%AA%D9%82%D9%88%DB%8C%D8%AA_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  <strong>8. \u0628\u0627 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0686\u0646\u062f \u0634\u0627\u062a \u062a\u0642\u0648\u06cc\u062a \u06a9\u0646\u06cc\u062f<\/strong><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0631\u0627\u06cc \u0628\u0647\u0628\u0648\u062f \u062f\u0642\u062a:<\/p>\n<ol>\n<li>\u0686\u0646\u062f \u0645\u062b\u0627\u0644 (\u0627\u0639\u0644\u0627\u0645 \u0628\u0627 \u062e\u0631\u0648\u062c\u06cc \u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0627\u0646\u062a\u0638\u0627\u0631 SQL) \u062f\u0631 \u0627\u0639\u0644\u0627\u0646 Bedrock \u0627\u0631\u0627\u0626\u0647 \u062f\u0647\u06cc\u062f.<\/li>\n<li>\u0646\u0638\u0631\u0627\u062a\u06cc \u0631\u0627 \u062f\u0631 \u062a\u0648\u0636\u06cc\u062d \u0642\u0648\u0627\u0646\u06cc\u0646 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ol>\n<p>\u0627\u0639\u0644\u0627\u0646 \u0645\u062b\u0627\u0644:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>Generate an SQL query based on the schema and request.\n\nExample 1:\nTable Schema:\n{\n  \"table_name\": \"employees\",\n  \"columns\": [\n    {\"name\": \"id\", \"type\": \"INTEGER\"},\n    {\"name\": \"name\", \"type\": \"VARCHAR\"},\n    {\"name\": \"department\", \"type\": \"VARCHAR\"},\n    {\"name\": \"salary\", \"type\": \"FLOAT\"}\n  ]\n}\nUser Query: Find employees in the Sales department.\nSQL Query: SELECT * FROM employees WHERE department=\"Sales\";\n\nExample 2:\nTable Schema:\n{...}\n\nNow generate an SQL query for this schema and request:\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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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<hr\/>\n<h3><span class=\"ez-toc-section\" id=\"9_%D9%86%D8%B8%D8%A7%D8%B1%D8%AA_%D9%88_%D8%AA%DA%A9%D8%B1%D8%A7%D8%B1\"><\/span>\n<p>  <strong>9. \u0646\u0638\u0627\u0631\u062a \u0648 \u062a\u06a9\u0631\u0627\u0631<\/strong><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>\n<strong>\u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645<\/strong>: \u062b\u0628\u062a \u0647\u0645\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627 \u0648 \u062a\u0648\u0644\u06cc\u062f SQL \u0628\u0631\u0627\u06cc \u0627\u0634\u06a9\u0627\u0644 \u0632\u062f\u0627\u06cc\u06cc \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644.<\/li>\n<li>\n<strong>\u062a\u0646\u0638\u06cc\u0645 \u062f\u0642\u06cc\u0642<\/strong>: \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0639\u0645\u0644\u06a9\u0631\u062f \u0645\u062f\u0644 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ol>\n<p>\u0627\u06cc\u0646 \u0641\u0631\u0622\u06cc\u0646\u062f \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0642\u0648\u06cc \u0648 \u0645\u0642\u06cc\u0627\u0633 \u067e\u0630\u06cc\u0631 \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631 \u0628\u0647 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0639\u0648\u0627\u0645\u0644 AWS Bedrock \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f. <\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0639\u0648\u0627\u0645\u0644 AWS Bedrock \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631 \u0628\u0647 \u0639\u0628\u0627\u0631\u0627\u062a SQL \u0634\u0627\u0645\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062f\u0644 \u0647\u0627\u06cc \u0632\u0628\u0627\u0646 \u0628\u0632\u0631\u06af Bedrock (LLM) \u0648 \u0637\u0631\u0627\u062d\u06cc \u0633\u06cc\u0633\u062a\u0645\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0637\u0631\u062d\u0648\u0627\u0631\u0647\u060c \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u06a9\u0627\u0631\u0628\u0631 \u0648 \u0641\u0631\u0622\u06cc\u0646\u062f \u062a\u0648\u0644\u06cc\u062f SQL \u0631\u0627 \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u0645\u06cc \u06a9\u0646\u062f. \u062f\u0631 \u0632\u06cc\u0631 \u06cc\u06a9 \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06af\u0627\u0645 \u0628\u0647 \u06af\u0627\u0645 \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u06cc\u0627\u0628\u06cc \u0628\u0647 \u0627\u06cc\u0646 \u0627\u0645\u0631 \u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a: 1-\u0645\u0634\u06a9\u0644 &hellip;<\/p>\n","protected":false},"author":2,"featured_media":93110,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/media2.dev.to\/dynamic\/image\/width=1000,height=500,fit=cover,gravity=auto,format=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Ff53w35i8aci10t914zj5.png","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-93109","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\/93109","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=93109"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/93109\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/93110"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=93109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=93109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=93109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}