{"id":3531,"date":"2024-03-30T17:47:44","date_gmt":"2024-03-30T08:47:44","guid":{"rendered":"https:\/\/blue-bear.jp\/kb\/?p=3531"},"modified":"2025-04-26T09:58:46","modified_gmt":"2025-04-26T00:58:46","slug":"snowflake%e3%82%b3%e3%83%b3%e3%83%86%e3%83%8a%e3%81%a7stable-diffusion-webui%e3%82%92%e8%b5%b7%e5%8b%95%e3%81%95%e3%81%9b%e3%81%a6%e3%81%bf%e3%81%9f","status":"publish","type":"post","link":"https:\/\/blue-bear.jp\/kb\/snowflake%e3%82%b3%e3%83%b3%e3%83%86%e3%83%8a%e3%81%a7stable-diffusion-webui%e3%82%92%e8%b5%b7%e5%8b%95%e3%81%95%e3%81%9b%e3%81%a6%e3%81%bf%e3%81%9f\/","title":{"rendered":"Snowflake\u30b3\u30f3\u30c6\u30ca\u3067Stable Diffusion WebUI\u3092\u8d77\u52d5\u3055\u305b\u3066\u307f\u305f"},"content":{"rendered":"\n<p>Snowflake\u30b3\u30f3\u30c6\u30ca\uff1dSnowpark Container Services\u3067GPU\u4ed8\u304d\u306e\u30b3\u30f3\u30c6\u30ca\u304c\u52d5\u304b\u305b\u308b\u3068\u3044\u3046\u3053\u3068\u3067\u3001AI\u753b\u50cf\u751f\u6210\u30c4\u30fc\u30eb\u306eStable Diffusion WebUI(AUTOMATIC1111\u7248)\u304c\u52d5\u4f5c\u3067\u304d\u308b\u306e\u304b\u691c\u8a3c\u3057\u3066\u307f\u305f\u3002<\/p>\n\n\n\n<p>\u7d50\u679c\u3068\u3057\u3066\u306f\u3001\u666e\u901a\u306b\u52d5\u3044\u3066\u7d50\u69cb\u65e9\u3044\u306e\u3067\u3044\u3061\u3044\u3061EC2\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u7acb\u3061\u4e0a\u3052\u305f\u308a\u3059\u308b\u5fc5\u8981\u304c\u306a\u3044\u306e\u3067Stable Diffusion\u306e\u904b\u7528\u7684\u306b\u306f\u697d\u3060\u3068\u601d\u3046<\/p>\n\n\n\n<p>\u3057\u304b\u3057\u3001Snowpark Container Services\u306e\u30b3\u30f3\u30d4\u30e5\u30fc\u30c8\u30ea\u30bd\u30fc\u30b9\u306e\u5e45\u304c\u3067\u304b\u3044\u306e\u3067\u30b3\u30b9\u30c8\u306b\u6ce8\u610f\u304b\u3082\u3057\u308c\u306a\u3044<\/p>\n\n\n\n<p>\u3061\u3087\u3063\u3068\u4e8b\u524d\u6e96\u5099\u3068\u3057\u3066\u30b3\u30f3\u30c6\u30ca\u30a4\u30e1\u30fc\u30b8\u3092\u3069\u3053\u304b\u3067\u4f5c\u3089\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u306e\u304c\u9762\u5012\u306a\u306e\u3060\u304c\u3001<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u6d41\u308c<\/h2>\n\n\n\n<p>\u7a3c\u50cd\u3055\u305b\u308b\u307e\u3067\u306e\u6d41\u308c\u306f\u4ee5\u4e0b\u306e\u901a\u308a<\/p>\n\n\n\n<ul>\n<li>\u3069\u3053\u304b\u3067\u30b3\u30f3\u30c6\u30ca\u30a4\u30e1\u30fc\u30b8\u3092\u4f5c\u6210<\/li>\n\n\n\n<li>Snowflake\u30b3\u30f3\u30c6\u30ca\u30ec\u30b8\u30b9\u30c8\u30ea\u306bPUSH<\/li>\n\n\n\n<li>Volume\u30de\u30a6\u30f3\u30c8\u3057\u3066\u753b\u50cf\u4fdd\u5b58\u3084\u30d7\u30e9\u30b0\u30a4\u30f3\u306a\u3069\u3092\u4fdd\u5b58\u3067\u304d\u308b\u30a8\u30ea\u30a2\u3092\u4f5c\u6210<\/li>\n\n\n\n<li>\u30ec\u30b8\u30b9\u30c8\u30ea\u4e0a\u306e\u30a4\u30e1\u30fc\u30b8\u3084Volume\u3092\u30de\u30a6\u30f3\u30c8\u3057\u3066\u30b3\u30f3\u30c6\u30ca\u8d77\u52d5<\/li>\n\n\n\n<li>URL\u304c\u751f\u6210\u3055\u308c\u308b\u306e\u3067\u30a2\u30af\u30bb\u30b9<\/li>\n\n\n\n<li>AI\u753b\u50cf\u751f\u6210<\/li>\n<\/ul>\n\n\n\n<p>\u3068\u3044\u3046\u6d41\u308c\u306b\u306a\u308b<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Stable Diffusion WebUI\u306e\u30b3\u30f3\u30c6\u30ca\u30a4\u30e1\u30fc\u30b8\u3092\u4f5c\u6210<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">EC2\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4f5c\u308b<\/h3>\n\n\n\n<p>\u4eca\u56de\u306fEC2\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4e0a\u306bStable Diffusion WebUI(AUTOMATIC1111\u7248)\u306e\u30b3\u30f3\u30c6\u30ca\u30a4\u30e1\u30fc\u30b8\u3092\u4f5c\u6210\u3059\u308b<\/p>\n\n\n\n<p>EC2\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306bGPU\u3084NVIDIA Toolkit\u306a\u3069\u306f\u5fc5\u8981\u306a\u3044\uff08\u52d5\u304b\u3055\u306a\u3044\u306e\u3067\uff09<\/p>\n\n\n\n<p>\u30b3\u30f3\u30c6\u30ca\u30a4\u30e1\u30fc\u30b8\u3092\u4f5c\u308b\u969b\u306b\u3044\u308d\u3044\u308d\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u308a\u3059\u308b\u306e\u3067\u3001\u3042\u308b\u7a0b\u5ea6\u30d1\u30ef\u30fc\u306e\u3042\u308b\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u65b9\u304c\u3088\u3044<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"264\" src=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-1-1024x264.png\" alt=\"\" class=\"wp-image-3532\" style=\"width:605px;height:auto\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-1-1024x264.png 1024w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-1-300x77.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-1-768x198.png 768w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-1.png 1460w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u30b9\u30c8\u30ec\u30fc\u30b8\u30828G\u3067\u306f\u5168\u304f\u8db3\u308a\u306a\u3044\u306e\u3067\u300130G\u304f\u3089\u3044\u3042\u308b\u3068\u3088\u3044\u3002\u30b3\u30f3\u30c6\u30ca\u30a4\u30e1\u30fc\u30b8\u306f9G\u304f\u3089\u3044\u306b\u306a\u308b<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"214\" src=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-2-1024x214.png\" alt=\"\" class=\"wp-image-3533\" style=\"width:585px;height:auto\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-2-1024x214.png 1024w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-2-300x63.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-2-768x161.png 768w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-2.png 1214w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Git\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\uff1a\u8a73\u7d30\u306f\u3053\u3061\u3089<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-bluebear-i-o wp-block-embed-bluebear-i-o\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"xKF3z3PqrS\"><a href=\"https:\/\/blue-bear.jp\/kb\/amazon-linux2023%e3%81%abgit%e3%82%92%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95\/\">Amazon Linux2023\u306bGit\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u65b9\u6cd5<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Amazon Linux2023\u306bGit\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u65b9\u6cd5&#8221; &#8212; Bluebear I\/O: \u6280\u8853\u5099\u5fd8\u9332\" src=\"https:\/\/blue-bear.jp\/kb\/amazon-linux2023%e3%81%abgit%e3%82%92%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95\/embed\/#?secret=L58TOQvgc3#?secret=xKF3z3PqrS\" data-secret=\"xKF3z3PqrS\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>docker compose v2\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\uff1a\u8a73\u7d30\u306f\u3053\u3061\u3089<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-bluebear-i-o wp-block-embed-bluebear-i-o\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"rH33KZ7un1\"><a href=\"https:\/\/blue-bear.jp\/kb\/amazon-linux%e3%81%abdocker-compose-v2%e4%bb%a5%e9%99%8d%e3%82%92%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95\/\">Amazon Linux2023\u306bdocker compose v2\u4ee5\u964d\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u65b9\u6cd5<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Amazon Linux2023\u306bdocker compose v2\u4ee5\u964d\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u65b9\u6cd5&#8221; &#8212; Bluebear I\/O: \u6280\u8853\u5099\u5fd8\u9332\" src=\"https:\/\/blue-bear.jp\/kb\/amazon-linux%e3%81%abdocker-compose-v2%e4%bb%a5%e9%99%8d%e3%82%92%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95\/embed\/#?secret=TF5Pr1ulW5#?secret=rH33KZ7un1\" data-secret=\"rH33KZ7un1\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Stable Diffusion WebUI\u306e\u30b3\u30f3\u30c6\u30ca\u30a4\u30e1\u30fc\u30b8\u3092\u53d6\u5f97\u3057\u3066\u30d3\u30eb\u30c9<\/h3>\n\n\n\n<p>Stable Diffusion WebUI\u306e\u30b3\u30f3\u30c6\u30ca\u30a4\u30e1\u30fc\u30b8\u3092\u53d6\u5f97\u3057\u3066\u30d3\u30eb\u30c9\u3059\u308b<\/p>\n\n\n\n<p><a href=\"https:\/\/github.com\/AbdBarho\/stable-diffusion-webui-docker\/wiki\/Setup\">https:\/\/github.com\/AbdBarho\/stable-diffusion-webui-docker\/wiki\/Setup<\/a><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo git clone https:\/\/github.com\/AbdBarho\/stable-diffusion-webui-docker<\/code><\/pre>\n\n\n\n<p>\u30d3\u30eb\u30c9\u3059\u308b\u3001CRUD\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u3044\u308d\u3044\u308d\u51fa\u308b\u304c\u7121\u8996\u3067\u3088\u3044<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd .\/stable-diffusion-webui-docker\/\nsudo docker compose --profile download up --build<\/code><\/pre>\n\n\n\n<p>Docker\u30b3\u30f3\u30c6\u30ca\u81ea\u4f53\u306f\u7acb\u3061\u4e0a\u3052\u308b\u5fc5\u8981\u306a\u3044\u306e\u3067UP\u3067\u306f\u306a\u304fBUILD\u3067\u3088\u3044<br>\uff0aSnowflake\u306e\u30ac\u30a4\u30c9\u3067\u306fBUILD\u306e\u969b\u306b&#8211;platform linux\/amd64\u3092\u3064\u3051\u308b\u5fc5\u8981\u304c\u3042\u308b\u3068\u66f8\u3044\u3066\u3042\u3063\u305f\u304c\u306a\u304f\u3066\u3082\u52d5\u4f5c\u3057\u305f<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo docker compose --profile auto build<\/code><\/pre>\n\n\n\n<p>\u30d3\u30eb\u30c9\u304c\u5b8c\u6210\u3057\u305f\u3089\u3001\u78ba\u8a8d<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo docker image list<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"114\" src=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-4-1024x114.png\" alt=\"\" class=\"wp-image-3541\" style=\"width:738px;height:auto\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-4-1024x114.png 1024w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-4-300x33.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-4-768x85.png 768w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-4.png 1190w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>sd-auto\u304c\u3067\u304d\u3066\u3044\u308b\u306f\u305a\u3001TAG\u306fweb ui\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u3088\u3063\u3066\u7570\u306a\u308b\u3068\u601d\u3046\u304c\u3001TAG\u3082\u899a\u3048\u3066\u304a\u304f\u3053\u3068<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Snowflake\u30b3\u30f3\u30c6\u30ca\u30ec\u30b8\u30b9\u30c8\u30ea\u3092\u4f5c\u6210<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u30ed\u30fc\u30eb\u30fbDB\u30fbWarehouse\u306a\u3069\u3092\u4f5c\u6210\u3057\u3066GRANT<\/h3>\n\n\n\n<p>\u30b3\u30f3\u30c6\u30ca\u30b5\u30fc\u30d3\u30b9\u3092\u8d77\u52d5\u3055\u305b\u308b\u969b\u3001AccountAdmin\u3067\u306e\u8d77\u52d5\u306f\u7981\u6b62\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u500b\u5225\u30ed\u30fc\u30eb\u3092\u4f5c\u6210\u3057\u3001\u6a29\u9650\u3092\u4ed8\u4e0e\u3057\u3066\u3044\u304f<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>USE ROLE ACCOUNTADMIN;\nCREATE ROLE test_role;\nGRANT ROLE test_role TO USER &lt;user>;\nCREATE DATABASE stable_diffusion_db;\nGRANT OWNERSHIP ON DATABASE stable_diffusion_db TO ROLE test_role COPY CURRENT GRANTS;\n\nCREATE OR REPLACE WAREHOUSE stable_diffusion_warehouse WITH\n  WAREHOUSE_SIZE='X-SMALL';\nGRANT USAGE ON WAREHOUSE stable_diffusion_warehouse TO ROLE test_role;\n\nGRANT BIND SERVICE ENDPOINT ON ACCOUNT TO ROLE test_role;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">COMPUTE POOL\u3092\u4f5c\u6210<\/h3>\n\n\n\n<p>\u30b3\u30f3\u30c6\u30ca\u3092\u8d77\u52d5\u3055\u305b\u308b\u305f\u3081\u306eCOMPUTE POOL\u3092\u4f5c\u6210\u3059\u308b\u3001GPU\u3092\u4f7f\u7528\u3057\u305f\u3044\u306e\u3067\u300cGPU_NV_S\u300d\u3092\u6307\u5b9a<\/p>\n\n\n\n<p>\u9078\u629e\u3067\u304d\u308b\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4e00\u89a7\u306f<a href=\"https:\/\/docs.snowflake.com\/en\/sql-reference\/sql\/create-compute-pool\">\u3053\u3061\u3089<\/a><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE COMPUTE POOL stable_diffusion_pool\n  MIN_NODES = 1\n  MAX_NODES = 1\n  INSTANCE_FAMILY = GPU_NV_S;\nGRANT USAGE, MONITOR ON COMPUTE POOL stable_diffusion_pool TO ROLE test_role;\n\n\/\/\u78ba\u8a8d\nSHOW COMPUTE POOLS; \nDESCRIBE COMPUTE POOL stable_diffusion_pool;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">OAUTH INTEGRATION\u3092\u4f5c\u6210<\/h3>\n\n\n\n<p>\u8d77\u52d5\u3057\u305f\u30b3\u30f3\u30c6\u30ca\u306b\u30ed\u30b0\u30a4\u30f3\u3059\u308b\u305f\u3081\u306bOAUTH INTEGRATION\u3092\u4f5c\u6210\u3059\u308b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE SECURITY INTEGRATION IF NOT EXISTS snowservices_ingress_oauth\n  TYPE=oauth\n  OAUTH_CLIENT=snowservices_ingress\n  ENABLED=true;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">EXTERNAL ACCESS INTEGRATION\u3092\u4f5c\u6210<\/h3>\n\n\n\n<p>\u30b3\u30f3\u30c6\u30ca\u304b\u3089\u5916\u90e8\u306b\u30a2\u30af\u30bb\u30b9\u3092\u8a31\u53ef\u3059\u308b\u30eb\u30fc\u30eb\u3092\u4f5c\u6210\u3001\u672c\u6765\u306f0.0.0.0\u3068\u3044\u3046\u5168\u90e8\u958b\u3051\u308b\u5fc5\u8981\u306f\u306a\u3044\u306e\u3060\u304c\u3001\u3069\u306e\u901a\u4fe1\u3092\u958b\u3051\u308b\u3079\u304d\u304b\u6642\u9593\u304c\u304b\u304b\u308a\u305d\u3046\u3060\u3063\u305f\u306e\u3067\u5168\u958b\u3051\u3057\u3066\u3044\u308b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE NETWORK RULE allow_all_rule\n  TYPE = HOST_PORT\n  MODE= EGRESS\n  VALUE_LIST = ('0.0.0.0:443','0.0.0.0:80')\n;\n\nCREATE EXTERNAL ACCESS INTEGRATION external_access_integration_sd\n  ALLOWED_NETWORK_RULES = (\n    allow_all_rule\n    )\n  ENABLED = true\n;\n\nGRANT USAGE ON INTEGRATION external_access_integration_sd TO ROLE test_role;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u30b3\u30f3\u30c6\u30ca\u30ec\u30b8\u30b9\u30c8\u30ea\u3092\u4f5c\u6210<\/h3>\n\n\n\n<p>Snowflake\u3067\u30b3\u30f3\u30c6\u30ca\u30a4\u30e1\u30fc\u30b8\u3092\u4fdd\u7ba1\u3059\u308b\u30b9\u30ad\u30fc\u30de\u3068\u30b3\u30f3\u30c6\u30ca\u30ec\u30b8\u30b9\u30c8\u30ea\u3092\u4f5c\u6210\u3059\u308b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>USE ROLE TEST_ROLE;\nUSE WAREHOUSE stable_diffusion_warehouse;\nCREATE SCHEMA IF NOT EXISTS data_schema;\n\nCREATE IMAGE REPOSITORY IF NOT EXISTS stable_diffusion_repository;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u30b3\u30f3\u30c6\u30ca\u30ec\u30b8\u30b9\u30c8\u30ea\u306eURL\u3092\u53d6\u5f97<\/h3>\n\n\n\n<p>\u30b3\u30f3\u30c6\u30ca\u30ec\u30b8\u30b9\u30c8\u30ea\u306eURL\u3092\u53d6\u5f97\u3059\u308b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW IMAGE REPOSITORIES;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"174\" src=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-3-1024x174.png\" alt=\"\" class=\"wp-image-3540\" style=\"width:573px;height:auto\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-3-1024x174.png 1024w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-3-300x51.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-3-768x131.png 768w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-3.png 1118w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Snowflake\u30b3\u30f3\u30c6\u30ca\u30ec\u30b8\u30b9\u30c8\u30ea\u306bPUSH<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">docker login<\/h3>\n\n\n\n<p>EC2\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u623b\u308a\u3001\u5148\u307b\u3069\u4f5c\u6210\u3057\u305fDocker Image\u3092Snowflake\u30ec\u30b8\u30b9\u30c8\u30ea\u306bPUSH\u3059\u308b\u305f\u3081\u306bdocker login\u3067\u30ed\u30b0\u30a4\u30f3\u3059\u308b<\/p>\n\n\n\n<p>\uff0aregistry_hostname\u306f\u300c&lt;orgname&gt;-&lt;acctname&gt;.registry.snowflakecomputing.com\u300d\u306b\u306a\u308b\u3002<br>\uff0a\u30e6\u30fc\u30b6\u540d\u306fSnowflake\u306b\u30ed\u30b0\u30a4\u30f3\u3059\u308b\u30e6\u30fc\u30b6\u540d<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo docker login &lt;registry_hostname&gt; -u &lt;username&gt;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">docker tag<\/h3>\n\n\n\n<p>\u5148\u307b\u3069\u4f5c\u6210\u3057\u305fDocker Image\u3092Snowflake\u30ec\u30dd\u30b8\u30c8\u30ea\u306bTAG\u4ed8\u3051\u3059\u308b<br>\uff0aversion\u306flatest\u3068\u3057\u3066\u3044\u308b<br>\uff0aregistry_url\u306f\u5148\u307b\u3069\u300cSHOW IMAGE REPOSITORIES;\u300d\u3067\u51fa\u529b\u3057\u305fURL\u306b\u306a\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo docker tag sd-auto:72 &lt;repository_url&gt;\/sd-auto:latest<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">docker push<\/h3>\n\n\n\n<p>TAG\u4ed8\u3051\u3057\u305fDocker Image\u3092PUSH<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo docker push &lt;repository_url&gt;\/sd-auto:latest<\/code><\/pre>\n\n\n\n<p>9G\u306e\u30a4\u30e1\u30fc\u30b8\u8ee2\u9001\u306b\u306a\u308b\u306e\u3067\u7d50\u69cb\u6642\u9593\u304c\u304b\u304b\u308b<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Volume\u30de\u30a6\u30f3\u30c8\u3057\u3066\u753b\u50cf\u4fdd\u5b58\u3084\u30d7\u30e9\u30b0\u30a4\u30f3\u306a\u3069\u3092\u4fdd\u5b58\u3067\u304d\u308b\u5185\u90e8\u30b9\u30c6\u30fc\u30b8\u3092\u4f5c\u6210<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Volume\u30de\u30a6\u30f3\u30c8\u7528\u306e\u5185\u90e8\u30b9\u30c6\u30fc\u30b8\u4f5c\u6210<\/h3>\n\n\n\n<p>Snowflake\u30b3\u30f3\u30c6\u30ca\u30b5\u30fc\u30d3\u30b9\u3067\u306f\u30b3\u30f3\u30c6\u30ca\u3092\u518d\u8d77\u52d5\u30fb\u7d42\u4e86\u3055\u305b\u308b\u3068\u30b3\u30f3\u30c6\u30ca\u4e0a\u306e\u30c7\u30fc\u30bf\u304c\u5168\u3066\u6d88\u3048\u308b\u306e\u3067\u3001AI\u30e2\u30c7\u30eb\u3084\u30d7\u30e9\u30b0\u30a4\u30f3\u30fb\u5b8c\u6210\u3057\u305f\u753b\u50cf\u306a\u3069\u306f\u6d88\u3048\u306a\u3044\u9818\u57df\u306b\u4fdd\u7ba1\u3057\u3066\u304a\u304d\u305f\u3044\u306e\u3067\u3001\u30b3\u30f3\u30c6\u30ca\u304b\u3089Volume\u30de\u30a6\u30f3\u30c8\u3055\u305b\u308b\u9818\u57df\u3092\u4f5c\u6210\u3059\u308b<\/p>\n\n\n\n<p>Stable Diffusion WebUI(AUTOMATIC1111\u7248)\u3067\u306fDATA\u3068OUTPUT\u3068\u3044\u3046\u4e8c\u3064\u306e\u9818\u57df\u3092\u30de\u30a6\u30f3\u30c8\u3057\u3066\u3044\u308b\u306e\u3067\u305d\u308c\u306b\u5247\u3063\u3066\u3001\u4e8c\u3064\u306e\u5185\u90e8\u30b9\u30c6\u30fc\u30b8\u3092\u4f5c\u6210\u3059\u308b<\/p>\n\n\n\n<p>\u5185\u90e8\u30b9\u30c6\u30fc\u30b8\u306fDIRECTORY\uff1dTRUE\u3001ENCRYPTION\uff1dSNOWFLAKE_SSE\u3068\u3057\u3066\u304a\u304f<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE STAGE IF NOT EXISTS stable_diffusion_models\n  DIRECTORY = ( ENABLE = true )\n  ENCRYPTION = (TYPE = 'SNOWFLAKE_SSE');\/\/DATA\u7528\nCREATE STAGE IF NOT EXISTS stable_diffusion_output\n  DIRECTORY = ( ENABLE = true )\n  ENCRYPTION = (TYPE = 'SNOWFLAKE_SSE');\/\/OUTPUT\u7528<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u30ec\u30b8\u30b9\u30c8\u30ea\u4e0a\u306e\u30a4\u30e1\u30fc\u30b8\u3084Volume\u3092\u30de\u30a6\u30f3\u30c8\u3057\u3066\u30b3\u30f3\u30c6\u30ca\u8d77\u52d5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">SERVICE\u306e\u4f5c\u6210\u3068\u6ce8\u610f\u8af8\u3005<\/h3>\n\n\n\n<p>\u30ec\u30b8\u30b9\u30c8\u30ea\u306e\u30a4\u30e1\u30fc\u30b8\u3084\u3089Volume\u30de\u30a6\u30f3\u30c8\u3084\u3089\u3092\u6307\u5b9a\u3057\u3066SERVICE\u3092CREATE\u3057\u3066\u8d77\u52d5\u3055\u305b\u308b<\/p>\n\n\n\n<p>\u91cd\u8981\uff1aGPU\u3092\u5229\u7528\u3057\u306a\u3044\u3068\u753b\u50cf\u751f\u6210\u6642\u306b\u30a8\u30e9\u30fc\u306b\u306a\u308b\u306e\u3067\u3001resources\u306bGPU\u3092\u6307\u5b9a\u3057\u3066\u304a\u304f\u3053\u3068<\/p>\n\n\n\n<p>\u8d77\u52d5OPTION\u306fenv\u306e\u914d\u4e0b\u306eCLI_ARGS\u3067\u30b3\u30f3\u30c6\u30ca\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u6e21\u305b\u308b\u5916\u90e8\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3044\u306a\u3089\u300c&#8211;enable-insecure-extension-access\u300d\u3092\u3064\u3051\u3066\u304a\u304f<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE SERVICE df_service\n  IN COMPUTE POOL stable_diffusion_pool\n  FROM SPECIFICATION $$\n    spec:\n      containers:\n      - name: df\n        image: \/stable_diffusion_db\/data_schema\/stable_diffusion_repository\/sd-auto:latest\n        resources:\n          requests:\n            memory: 2G\n            cpu: 0.5\n            nvidia.com\/gpu: 1\n          limits:\n            memory: 32G\n            nvidia.com\/gpu: 1\n        env:\n          SERVER_PORT: 7860\n          CLI_ARGS: \"--allow-code --medvram --xformers --enable-insecure-extension-access --api --no-half --precision full --no-half-vae\"\n        volumeMounts:\n        - name: sd-models\n          mountPath: .\/data\n        - name: sd-output\n          mountPath: .\/output\n      endpoints:\n      - name: dfendpoint\n        port: 7860\n        public: true\n      volumes:\n      - name: sd-models\n        source: \"@stable_diffusion_models\"\n        uid: 1000\n        gid: 1000\n      - name: sd-output\n        source: \"@stable_diffusion_output\"\n        uid: 1000\n        gid: 1000\n      $$\n   EXTERNAL_ACCESS_INTEGRATIONS = (EXTERNAL_ACCESS_INTEGRATION_SD)\n   MIN_INSTANCES=1\n   MAX_INSTANCES=1\n;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">GET_SERVICE_STATUS<\/h3>\n\n\n\n<p>\u8d77\u52d5\u3059\u308b\u307e\u3067\u306b\u7d50\u69cb\u6642\u9593\u304c\u304b\u304b\u308b\u306e\u3067\u3001\u30b9\u30c6\u30fc\u30bf\u30b9\u78ba\u8a8d\u30b3\u30de\u30f3\u30c9\u3067\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CALL SYSTEM$GET_SERVICE_STATUS('stable_diffusion_db.data_schema.df_service');<\/code><\/pre>\n\n\n\n<p>PENDING\u306e\u5834\u5408\u306f\u3001\u307e\u3060\u30a2\u30af\u30bb\u30b9\u3067\u304d\u306a\u3044\u3002READY\u306b\u306a\u308b\u3068\u30a2\u30af\u30bb\u30b9\u53ef\u80fd\u3068\u306a\u308b<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"192\" src=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-6-1024x192.png\" alt=\"\" class=\"wp-image-3545\" style=\"width:664px;height:auto\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-6-1024x192.png 1024w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-6-300x56.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-6-768x144.png 768w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-6-1536x288.png 1536w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-6.png 1576w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Stable Diffusion WebUI\u306b\u30a2\u30af\u30bb\u30b9<\/h3>\n\n\n\n<p>\u30a2\u30af\u30bb\u30b9\u7528URL\u3092\u8868\u793a\u3055\u305b\u3066\u30a2\u30af\u30bb\u30b9<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW ENDPOINTS IN SERVICE df_service;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"856\" height=\"320\" src=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-7.png\" alt=\"\" class=\"wp-image-3546\" style=\"width:362px;height:auto\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-7.png 856w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-7-300x112.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-7-768x287.png 768w\" sizes=\"(max-width: 856px) 100vw, 856px\" \/><\/figure>\n\n\n\n<p>\u3061\u3083\u3093\u3068\u8d77\u52d5\u3057\u3066\u3044\u308b<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"269\" src=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-8-1024x269.png\" alt=\"\" class=\"wp-image-3547\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-8-1024x269.png 1024w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-8-300x79.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-8-768x201.png 768w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-8-1536x403.png 1536w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-8-2048x537.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u30e2\u30c7\u30eb\u306a\u3069\u304c\u4fdd\u7ba1\u3055\u308c\u3066\u3044\u308b\u304b\u78ba\u8a8d<\/h3>\n\n\n\n<p>\u5148\u307b\u3069DATA Volume\u3068\u3057\u3066\u30de\u30a6\u30f3\u30c8\u3057\u305f\u5185\u90e8\u30b9\u30c6\u30fc\u30b8\u306b\u306f\u8272\u3005\u3068\u30c7\u30fc\u30bf\u304c\u5165\u3063\u3066\u308b\u3001\u30b3\u30f3\u30c6\u30ca\u304c\u8d77\u52d5\u3057\u305f\u969b\u306b\u8272\u3005\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u3044\u308b\u3088\u3046\u3059<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"142\" src=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-9-1024x142.png\" alt=\"\" class=\"wp-image-3548\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-9-1024x142.png 1024w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-9-300x42.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-9-768x106.png 768w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-9-1536x213.png 1536w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-9.png 1992w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u3042\u3068\u306f\u30e2\u30c7\u30eb\u3092\u3053\u3053\u306e\u300cSTABLE_DIFFUSION_MODELS\/models\/Stable-diffusion\u300d\u306b\u5165\u308c\u308c\u3070\u3088\u3044\u304c\u3001\u5927\u304d\u3044\u30d5\u30a1\u30a4\u30eb\u306fWebUI\u304b\u3089\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3067\u304d\u306a\u3044\u306e\u3067\u3001\u300csd-civitai-browser\u300d\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3068\u697d<\/p>\n\n\n\n<p><a href=\"https:\/\/github.com\/Vetchems\/sd-civitai-browser\">https:\/\/github.com\/Vetchems\/sd-civitai-browser<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"425\" src=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-10-1024x425.png\" alt=\"\" class=\"wp-image-3549\" style=\"width:738px;height:auto\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-10-1024x425.png 1024w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-10-300x125.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-10-768x319.png 768w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-10-1536x638.png 1536w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-10.png 1782w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u30d7\u30e9\u30b0\u30a4\u30f3\u306e\u4fdd\u5b58\u5148\u3082\u5185\u90e8\u30b9\u30c6\u30fc\u30b8\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3067WebUI\u3092\u518d\u8d77\u52d5\u3057\u3066\u3082\u6d88\u3048\u306a\u3044<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"145\" src=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-11-1024x145.png\" alt=\"\" class=\"wp-image-3550\" style=\"width:817px;height:auto\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-11-1024x145.png 1024w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-11-300x42.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-11-768x108.png 768w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-11-1536x217.png 1536w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-11.png 1968w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u3088\u3046\u3084\u304f\u751f\u6210<\/h3>\n\n\n\n<p>\u3042\u3068\u306f\u597d\u304d\u306a\u30e2\u30c7\u30eb\u3092civitai\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u4f7f\u3046\u3068\u5b8c\u6210\uff01\u30e2\u30c7\u30eb\u306fManiamix\u3092\u5229\u7528\u3057\u3066\u3044\u308b<\/p>\n\n\n\n<p>GPU_NV_S\u3067\u306e512 x 512\u306e\u751f\u6210\u3067\uff12\u79d2\u304f\u3089\u3044\u3067\u751f\u6210\u3067\u304d\u305f\u3001\u7d50\u69cb\u65e9\u3044<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"578\" src=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-12-1024x578.png\" alt=\"\" class=\"wp-image-3551\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-12-1024x578.png 1024w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-12-300x169.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-12-768x433.png 768w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-12-1536x867.png 1536w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-12-2048x1155.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Positive<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>(((masterpiece))), (((best quality))), ((ultra-detailed)), (illustration), (1 girl), (solo), ((an extremely delicate and beautiful)), little girl, ((beautiful detailed sky)), beautiful detailed eyes, side blunt bangs, hairs between eyes, ribbons, bowties, buttons, bare shoulders, (small breast), blank stare, pleated skirt, close to viewer, ((breeze)), Flying splashes,  Flying petals, wind<\/code><\/pre>\n\n\n\n<p>Negative<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>nsfw, lowres, bad anatomy, bad hands, text, error, missing fingers, extra digit, fewer digits, cropped, worst quality, low quality, normal quality, jpeg artifacts, signature, watermark, username, blurry, missing fingers,  bad hands, missing arms, long neck, Humpbacked, shadow, nude<\/code><\/pre>\n\n\n\n<p>\u753b\u50cf\u3092\u4fdd\u5b58\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u4fdd\u5b58\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u5185\u90e8\u30b9\u30c6\u30fc\u30b8\u306eOUTPUT\u306b\u4fdd\u7ba1\u3055\u308c\u308b<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"946\" height=\"352\" src=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-13.png\" alt=\"\" class=\"wp-image-3552\" style=\"width:570px;height:auto\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-13.png 946w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-13-300x112.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-13-768x286.png 768w\" sizes=\"(max-width: 946px) 100vw, 946px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">OUTPUT\u5185\u90e8\u30b9\u30c6\u30fc\u30b8\u306b\u753b\u50cf\u4fdd\u5b58\u3068\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/h3>\n\n\n\n<p>\u5f8c\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u3044\u5834\u5408\u306fSnowflake\u306eWebUI\u306e\u5185\u90e8\u30b9\u30c6\u30fc\u30b8\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"231\" src=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-14-1024x231.png\" alt=\"\" class=\"wp-image-3553\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-14-1024x231.png 1024w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-14-300x68.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-14-768x174.png 768w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-14-1536x347.png 1536w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2024\/03\/image-14-2048x463.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u7247\u4ed8\u3051\uff1a\u91cd\u8981<\/h3>\n\n\n\n<p>\u4f7f\u3044\u7d42\u308f\u3063\u305f\u3089Snowflake\u4e0a\u3067SERVICE\u3092\u7d42\u4e86\u3057\u3066\u304a\u304f\u3053\u3068\u3001\u653e\u3063\u3066\u304a\u3044\u3066\u3082SUSPEND\u306b\u306a\u3089\u306a\u3044\u306e\u3067\u7d42\u4e86\u3055\u305b\u3066\u304a\u304f<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP SERVICE df_service;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Snowflake\u30b3\u30f3\u30c6\u30ca\uff1dSnowpa<\/p>\n","protected":false},"author":1,"featured_media":3556,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[511],"tags":[517],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts\/3531"}],"collection":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/comments?post=3531"}],"version-history":[{"count":10,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts\/3531\/revisions"}],"predecessor-version":[{"id":3686,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts\/3531\/revisions\/3686"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/media\/3556"}],"wp:attachment":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/media?parent=3531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/categories?post=3531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/tags?post=3531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}