{"id":49072,"date":"2023-04-21T19:08:19","date_gmt":"2023-01-30T22:39:52","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/"},"modified":"2024-04-30T00:37:48","modified_gmt":"2024-04-29T16:37:48","slug":"%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/","title":{"rendered":"\u5728Snowflake\u4e0a\u521b\u5efa\u8d44\u6e90\u7684\u6b65\u9aa4\u662f\u4f7f\u7528Terraform"},"content":{"rendered":"<h1>\u9996\u5148<\/h1>\n<p>\u5728\u4f7f\u7528Terraform\u6784\u5efaSnowflake\u7684\u8fc7\u7a0b\u4e2d\uff0c\u53c2\u8003Snowflake\u63d0\u4f9b\u7684\u6559\u7a0b\u662f\u5f88\u5bb9\u6613\u7406\u89e3\u7684\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u7136\u800c\uff0c\u5c3d\u7ba1\u6309\u7167\u6559\u7a0b\u64cd\u4f5c\u8fd8\u662f\u9047\u5230\u4e86\u56f0\u96be\uff0c\u56e0\u6b64\u6211\u603b\u7ed3\u4e86\u81ea\u5df1\u7684\u6b65\u9aa4\u3002<\/p>\n<h1>\u73af\u5883<\/h1>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">macOS Ventura 13.1<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">Homebrew 4.0.11<\/ul>\n<h1>\u7b80\u800c\u8a00\u4e4b<\/h1>\n<p>\u5728\u672c\u7bc7\u6587\u7ae0\u4e2d\uff0c\u6211\u5011\u5c07\u53c3\u8003\u6559\u7a0b\u4e26\u505a\u51fa\u4e00\u4e9b\u81ea\u5df1\u7684\u4fee\u6539\uff0c\u6700\u7d42\u4f7f\u7528Terraform\u5728Snowflake\u4e0a\u5275\u5efa\u4ee5\u4e0b\u8cc7\u6e90\u7684\u6b65\u9a5f\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30b9\u30ad\u30fc\u30de<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30b9\u30c6\u30fc\u30b8<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30a6\u30a7\u30a2\u30cf\u30a6\u30b9<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30e6\u30fc\u30b6\u30fc<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30ed\u30fc\u30eb<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\u8af8\u3005\u306e\u6a29\u9650\u4ed8\u4e0e<\/ul>\n<h1>1. \u5b89\u88c5 Terraform<\/h1>\n<p>\u5982\u679c\u8fd8\u6ca1\u6709\u5b89\u88c5Terraform\uff0c\u60a8\u9700\u8981\u5728\u672c\u5730\u8fdb\u884c\u5f00\u53d1\uff0c\u6240\u4ee5\u8bf7\u786e\u4fdd\u5148\u5b89\u88c5\u5b83\u3002<\/p>\n<p>\u5b89\u88c5tfenv<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>brew <span class=\"nb\">install <\/span>tfenv\r\n<\/code><\/pre>\n<p>\u7248\u672c\u786e\u8ba4<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>tfenv <span class=\"nt\">--version<\/span>\r\n<\/code><\/pre>\n<p>Terraform \u53ef\u5b89\u88c5\u7248\u672c\u9a8c\u8bc1<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>tfenv list-remote\r\n<\/code><\/pre>\n<p>\u622a\u81f3\u52302023\u5e744\u67089\u65e5\uff0c\u6700\u65b0\u7248\u4e3av1.4.4\uff0c\u8bf7\u5b89\u88c5\u6b64\u7248\u672c\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>tfenv <span class=\"nb\">install <\/span>1.4.4\r\n<\/code><\/pre>\n<p>\u6307\u5b9a\u8981\u4f7f\u7528\u5df2\u5b89\u88c5\u7248\u672c\u7684Terraform\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>tfenv use 1.4.4\r\n<\/code><\/pre>\n<h1>2. \u96ea\u82b1\u51c6\u5907\u597d\u4e86<\/h1>\n<p>\u7531\u4e8eSnowflake\u53ef\u4ee5\u521b\u5efa\u4e00\u4e2a\u514d\u8d39\u768430\u5929\u8bd5\u7528\u8d26\u6237\uff0c\u6240\u4ee5\u5982\u679c\u60a8\u8fd8\u6ca1\u6709\u8d26\u6237\uff0c\u53ef\u4ee5\u5148\u521b\u5efa\u4e00\u4e2a\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u5982\u679c\u6309\u7167\u753b\u9762\u4e0a\u7684\u6307\u793a\u586b\u5199\u9879\u76ee\uff0c\u60a8\u53ef\u4ee5\u8f7b\u677e\u5730\u521b\u5efa\u4e00\u4e2a\u8d26\u6237\u3002<br \/>\n\u6211\u9009\u62e9\u4e86\u6807\u51c6\u7248\uff0cAWS\u4f5c\u4e3a\u4e91\u670d\u52a1\u63d0\u4f9b\u5546\uff0c\u533a\u57df\u9009\u62e9\u4e86\u4e9a\u592a\u5730\u533a\uff08\u4e1c\u4eac\uff09\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d8924913a08637a6c51cb\/25-0.png\" alt=\"undefined\" \/><\/div>\n<p>\u521b\u5efa\u8d26\u6237\u540e\uff0c\u60a8\u5c06\u6536\u5230\u4e00\u5c01\u7535\u5b50\u90ae\u4ef6\uff0c\u8bf7\u6fc0\u6d3b\u8d26\u6237\u5e76\u767b\u5f55\u3002<\/p>\n<h1>3. \u51c6\u5907\u8fde\u63a5<\/h1>\n<p>\u6211\u4f1a\u6267\u884c\u4ee5\u4e0b\u64cd\u4f5c\uff0c\u521b\u5efa\u7528\u4e8e\u8fde\u63a5\u7684\u5bc6\u94a5\u5e76\u5c06\u5176\u590d\u5236\u5230\u526a\u8d34\u677f\u4e0a\u4fdd\u5b58\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">cd<\/span> ~\/.ssh\r\n<span class=\"nv\">$ <\/span>openssl genrsa 2048 | openssl pkcs8 <span class=\"nt\">-topk8<\/span> <span class=\"nt\">-inform<\/span> PEM <span class=\"nt\">-out<\/span> snowflake_tf_snow_key.p8 <span class=\"nt\">-nocrypt<\/span>\r\n<span class=\"nv\">$ <\/span>openssl rsa <span class=\"nt\">-in<\/span> snowflake_tf_snow_key.p8 <span class=\"nt\">-pubout<\/span> <span class=\"nt\">-out<\/span> snowflake_tf_snow_key.pub\r\n<span class=\"nv\">$ <\/span><span class=\"nb\">cat <\/span>snowflake_tf_snow_key.pub | pbcopy\r\n<\/code><\/pre>\n<p>\u4e0b\u9762\u662f\u5728Snowflake\u4e0a\u6267\u884c\u7684\u6b65\u9aa4\u3002<br \/>\n\u6240\u505a\u7684\u662f\u521b\u5efa\u4e00\u4e2a\u7528\u4e8eTerraform\u7684Snowflake\u7528\u6237\uff0c\u5e76\u5c06\u89d2\u8272\u5206\u914d\u7ed9\u8be5\u7528\u6237\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">USER<\/span> <span class=\"nv\">\"tf-snow\"<\/span>\r\n\t<span class=\"n\">RSA_PUBLIC_KEY<\/span><span class=\"o\">=<\/span><span class=\"s1\">'${\u751f\u6210\u3057\u305f\u516c\u958b\u9375}'<\/span>\r\n\t<span class=\"n\">DEFAULT_ROLE<\/span><span class=\"o\">=<\/span><span class=\"k\">PUBLIC<\/span>\r\n\t<span class=\"n\">MUST_CHANGE_PASSWORD<\/span><span class=\"o\">=<\/span><span class=\"k\">FALSE<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">GRANT<\/span> <span class=\"k\">ROLE<\/span> <span class=\"n\">SYSADMIN<\/span> <span class=\"k\">TO<\/span> <span class=\"k\">USER<\/span> <span class=\"nv\">\"tf-snow\"<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">GRANT<\/span> <span class=\"k\">ROLE<\/span> <span class=\"n\">SECURITYADMIN<\/span> <span class=\"k\">TO<\/span> <span class=\"k\">USER<\/span> <span class=\"nv\">\"tf-snow\"<\/span><span class=\"p\">;<\/span>\r\n<\/code><\/pre>\n<p>\u5f53\u60a8\u7c98\u8d34\u516c\u94a5\u65f6\uff0c\u8bf7\u786e\u4fdd\u5220\u9664\u524d\u540e\u7684&#8212;&#8211;BEGIN PUBLIC KEY&#8212;&#8211;\u3001&#8212;&#8211;END PUBLIC KEY&#8212;&#8211;\u3002<\/p>\n<p>\u6211\u4eec\u8ba9\u521b\u5efa\u7684\u7528\u6237\u80fd\u591f\u4f7f\u7528\u4e24\u79cd\u89d2\u8272\uff0c\u4f46\u662f\u4f7f\u7528\u65b9\u6cd5\u5982\u4e0b\u3002<\/p>\n<p>SYSADMIN: \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3084\u30b9\u30ad\u30fc\u30de\u3001\u30a6\u30a7\u30a2\u30cf\u30a6\u30b9\u306a\u3069\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u4f5c\u6210<\/p>\n<p>SECURITYADMIN: \u30e6\u30fc\u30b6\u30fc\u3068\u30ed\u30fc\u30eb\u306e\u4f5c\u6210\u3001\u6a29\u9650\u4ed8\u4e0e<\/p>\n<p>\u7136\u540e\u5728\u672c\u5730\u6267\u884c\u4ee5\u4e0b\u64cd\u4f5c\u4ee5\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">export <\/span><span class=\"nv\">SNOWFLAKE_USER<\/span><span class=\"o\">=<\/span><span class=\"s2\">\"tf-snow\"<\/span>\r\n<span class=\"nv\">$ <\/span><span class=\"nb\">export <\/span><span class=\"nv\">SNOWFLAKE_PRIVATE_KEY_PATH<\/span><span class=\"o\">=<\/span><span class=\"s2\">\"~\/.ssh\/snowflake_tf_snow_key.p8\"<\/span>\r\n<span class=\"nv\">$ <\/span><span class=\"nb\">export <\/span><span class=\"nv\">SNOWFLAKE_ACCOUNT<\/span><span class=\"o\">=<\/span><span class=\"s2\">\"<\/span><span class=\"k\">${<\/span><span class=\"p\">\u30a2\u30ab\u30a6\u30f3\u30c8Locator<\/span><span class=\"k\">}<\/span><span class=\"s2\">\"<\/span>\r\n<span class=\"nv\">$ <\/span><span class=\"nb\">export <\/span><span class=\"nv\">SNOWFLAKE_REGION<\/span><span class=\"o\">=<\/span><span class=\"s2\">\"<\/span><span class=\"k\">${<\/span><span class=\"p\">\u30ea\u30fc\u30b8\u30e7\u30f3ID<\/span><span class=\"k\">}<\/span><span class=\"s2\">\"<\/span>\r\n<\/code><\/pre>\n<p>\u5728 URL \u4e2d\uff0c\u300c\u30a2\u30ab\u30a6\u30f3\u30c8Locator\u300d\u662f\u5305\u542b\u7c7b\u4f3c xy12345 \u5b57\u7b26\u4e32\u7684\u90e8\u5206\u3002<br \/>\n\u7531\u4e8e\u6211\u5728\u521b\u5efa\u5e10\u6237\u65f6\u9009\u62e9\u4e86 AWS \u7684\u4e9a\u592a\u5730\u533a\uff08\u4e1c\u4eac\uff09\uff0c\u6240\u4ee5\u300c\u30ea\u30fc\u30b8\u30e7\u30f3ID\u300d\u5c06\u662f ap-northeast-1.aws\u3002<\/p>\n<p>\u8fd9\u4e9b\u4fe1\u606f\u4e5f\u53ef\u4ee5\u901a\u8fc7\u5728Snowflake\u4e0a\u6267\u884c\u4ee5\u4e0b\u64cd\u4f5c\u6765\u786e\u8ba4\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">SELECT<\/span>\r\n\t<span class=\"n\">current_account<\/span><span class=\"p\">()<\/span> <span class=\"k\">as<\/span> <span class=\"n\">YOUR_ACCOUNT_LOCATOR<\/span><span class=\"p\">,<\/span>\r\n\t<span class=\"n\">current_region<\/span><span class=\"p\">()<\/span> <span class=\"k\">as<\/span> <span class=\"n\">YOUR_SNOWFLAKE_REGION_ID<\/span><span class=\"p\">;<\/span>\r\n<\/code><\/pre>\n<p>\u5173\u4e8e\u533a\u57dfID\uff0c\u60a8\u9700\u8981\u6839\u636e\u6587\u6863\u53c2\u8003\u5c06\u5176\u8f6c\u6362\u4e3a\u76f8\u5e94\u7684\u4e91\u5730\u533aID\uff08\u5982\u6709\u5fc5\u8981\uff0c\u8fd8\u53ef\u4ee5\u52a0\u4e0a\u4e91\u670d\u52a1\u63d0\u4f9b\u5546\u7684\u540d\u79f0\uff09\u3002<\/p>\n<p>\u6bcf\u6b21\u542f\u52a8\u7ec8\u7aef\u90fd\u9700\u8981\u8f93\u5165\u73af\u5883\u53d8\u91cf\uff0c\u56e0\u6b64\u51c6\u5907\u4e00\u4e2a\u540d\u4e3asnow.env\u7684\u6587\u4ef6\uff0c\u5e76\u5728\u5176\u4e2d\u8fdb\u884c\u8bb0\u5f55\uff0c\u8fd9\u6837\u5728\u4ee5\u540e\u7684\u4f7f\u7528\u4e2d\u5c31\u4f1a\u66f4\u52a0\u8f7b\u677e\u3002<br \/>\n\uff08\u5728\u4f7f\u7528Git\u8fdb\u884c\u4ee3\u7801\u7ba1\u7406\u65f6\uff0c\u8bf7\u4e0d\u8981\u5fd8\u8bb0\u5c06snow.env\u6dfb\u52a0\u5230.gitignore\u4e2d\uff09<\/p>\n<h1>4. Terraform\u5b9e\u65bd<\/h1>\n<p>\u8bf7\u5728\u9879\u76ee\u7684\u57fa\u672c\u76ee\u5f55\u4e2d\u521b\u5efamain.tf\u6587\u4ef6\uff0c\u5e76\u7c98\u8d34\u4ee5\u4e0b\u5185\u5bb9\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">terraform<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"nx\">required_providers<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"nx\">snowflake<\/span> <span class=\"p\">=<\/span> <span class=\"p\">{<\/span>\r\n      <span class=\"nx\">source<\/span>  <span class=\"p\">=<\/span> <span class=\"s2\">\"Snowflake-Labs\/snowflake\"<\/span>\r\n      <span class=\"nx\">version<\/span> <span class=\"p\">=<\/span> <span class=\"s2\">\"0.42.1\"<\/span>\r\n    <span class=\"p\">}<\/span>\r\n  <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">provider<\/span> <span class=\"s2\">\"snowflake\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"nx\">role<\/span>  <span class=\"p\">=<\/span> <span class=\"s2\">\"SYSADMIN\"<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">resource<\/span> <span class=\"s2\">\"snowflake_database\"<\/span> <span class=\"s2\">\"db\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"nx\">name<\/span>     <span class=\"p\">=<\/span> <span class=\"s2\">\"TF_DEMO_DB\"<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">resource<\/span> <span class=\"s2\">\"snowflake_warehouse\"<\/span> <span class=\"s2\">\"warehouse\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"nx\">name<\/span>           <span class=\"p\">=<\/span> <span class=\"s2\">\"TF_DEMO_WH\"<\/span>\r\n  <span class=\"nx\">warehouse_size<\/span> <span class=\"p\">=<\/span> <span class=\"s2\">\"large\"<\/span>\r\n  <span class=\"nx\">auto_suspend<\/span> <span class=\"p\">=<\/span> <span class=\"mi\">60<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<div>\u6211\u5c06\u63d0\u4f9b\u5546\u7684\u7248\u672c\u56fa\u5b9a\u57280.42.1\u3002<\/div>\n<p>\u5728\u6559\u7a0b\u4e2d\uff0c\u6211\u4eec\u5efa\u8bae\u4f7f\u75280.35\u6216\u66f4\u9ad8\u7248\u672c\u7684\u6700\u65b0\u7248\u672c\uff0c\u4f46\u5982\u679c\u4f7f\u7528\u8f83\u65b0\u7684\u7248\u672c\uff0c\u6807\u51c6\u7248\u4f1a\u51fa\u73b0\u9519\u8bef\u3002<br \/>\n\u8fd9\u4e2a\u9519\u8bef\u662f\u7531\u4e8e\u5728\u521b\u5efa\u4ed3\u5e93\u65f6\uff0c\u6807\u51c6\u7248\u4e2d\u65e0\u6cd5\u4f7f\u7528\u7684\u53c2\u6570\u4f1a\u88ab\u81ea\u52a8\u6dfb\u52a0\u6240\u5bfc\u81f4\u7684\uff0c\u5373\u4f7f\u57282023\/04\/09\u65f6\u70b9\u7684\u6700\u65b0\u7248\u672c0.61.0\u4e2d\u4e5f\u6ca1\u6709\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u3002<br \/>\n\u56e0\u6b64\uff0c\u6211\u8ba4\u4e3a\u4f7f\u75280.42.1\u5de6\u53f3\u7684\u7248\u672c\u662f\u5408\u7406\u7684\uff0c\u53ef\u4ee5\u6b63\u5e38\u4f7f\u7528\u800c\u6ca1\u6709\u95ee\u9898\u3002<\/p>\n<h1>5. \u8fd0\u884cTerraform<\/h1>\n<p>\u5728\u9879\u76ee\u76ee\u5f55\u4e0b\u6267\u884c\u4ee5\u4e0b\u64cd\u4f5c\u3002<br \/>\n\u5c06Terraform\u6267\u884c\u6240\u9700\u7684\u4f9d\u8d56\u5173\u7cfb\u548c\u4fdd\u5b58\u72b6\u6001\u7684\u6587\u4ef6\u4e0b\u8f7d\u5230\u672c\u5730\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>terraform init\r\n<\/code><\/pre>\n<p>\u5982\u679c\u4f60\u5728\u4f7f\u7528Git\u8fdb\u884c\u4ee3\u7801\u7ba1\u7406\uff0c\u5e94\u8be5\u5c06\u751f\u6210\u7684\u72b6\u6001\u6587\u4ef6\u7b49\u6dfb\u52a0\u5230.gitignore\u4e2d\uff0c\u4ee5\u907f\u514d\u610f\u5916push\u4e0a\u53bb\u3002<\/p>\n<pre class=\"post-pre\"><code>*.terraform*\r\n*.tfstate\r\n*.tfstate.*\r\n<\/code><\/pre>\n<p>\u7136\u540e\u6267\u884c\u4ee5\u4e0b\u64cd\u4f5c\uff0c\u68c0\u67e5\u5728\u6267\u884cTerraform\u540e\u6240\u505a\u7684\u66f4\u6539\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>terraform plan\r\n<\/code><\/pre>\n<p>\u5982\u679c\u6ca1\u6709\u8d44\u6e90\u66f4\u6539\u7684\u95ee\u9898\uff0c\u6211\u8ba4\u4e3a\u8981\u8fdb\u884c\u7684\u66f4\u6539\u662f\u521b\u5efa\u6570\u636e\u5e93\u548c\u4ed3\u5e93\u3002\u5982\u679c\u6ca1\u6709\u95ee\u9898\uff0c\u6211\u4eec\u5c06\u6267\u884c\u4ee5\u4e0b\u64cd\u4f5c\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>terraform apply\r\n<\/code><\/pre>\n<p>\u5982\u679c\u663e\u793a\u5e76\u8be2\u95ee\u662f\u5426\u5e94\u7528\u518d\u6b21\u66f4\u6539\u5185\u5bb9\uff0c\u8bf7\u8f93\u5165&#8221;\u662f&#8221;\u3002<\/p>\n<p>\u5728\u6210\u529f\u65f6\uff0c\u5c06\u5728Snowfalke\u4e0a\u521b\u5efa\u6570\u636e\u5e93\u548c\u6570\u636e\u4ed3\u5e93\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d8924913a08637a6c51cb\/58-1.png\" alt=\"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8 2023-04-09 3.00.45.png\" \/><\/div>\n<h1>6. \u6dfb\u52a0\u8d44\u6e90<\/h1>\n<p>\u8bf7\u6700\u7ec8\u521b\u5efa\u5176\u4ed6\u8d44\u6e90\u3002<br \/>\n\u8bf7\u5728main.tf\u4e2d\u6dfb\u52a0\u4ee5\u4e0b\u5185\u5bb9\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c1\">\/\/ SECURITYADMIN\u30ed\u30fc\u30eb\u3067\u64cd\u4f5c\u3067\u304d\u308b\u3088\u3046\u306b<\/span>\r\n<span class=\"k\">provider<\/span> <span class=\"s2\">\"snowflake\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"nx\">alias<\/span> <span class=\"p\">=<\/span> <span class=\"s2\">\"security_admin\"<\/span>\r\n  <span class=\"nx\">role<\/span>  <span class=\"p\">=<\/span> <span class=\"s2\">\"SECURITYADMIN\"<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c1\">\/\/ \u30ed\u30fc\u30eb\u4f5c\u6210<\/span>\r\n<span class=\"k\">resource<\/span> <span class=\"s2\">\"snowflake_role\"<\/span> <span class=\"s2\">\"role\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"k\">provider<\/span> <span class=\"p\">=<\/span> <span class=\"nx\">snowflake<\/span><span class=\"p\">.<\/span><span class=\"nx\">security_admin<\/span>\r\n  <span class=\"nx\">name<\/span>     <span class=\"p\">=<\/span> <span class=\"s2\">\"TF_DEMO_ROLE\"<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c1\">\/\/ \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u6a29\u9650\u4ed8\u4e0e<\/span>\r\n<span class=\"k\">resource<\/span> <span class=\"s2\">\"snowflake_database_grant\"<\/span> <span class=\"s2\">\"grant\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"k\">provider<\/span>          <span class=\"p\">=<\/span> <span class=\"nx\">snowflake<\/span><span class=\"p\">.<\/span><span class=\"nx\">security_admin<\/span>\r\n  <span class=\"nx\">database_name<\/span>     <span class=\"p\">=<\/span> <span class=\"nx\">snowflake_database<\/span><span class=\"p\">.<\/span><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span>\r\n  <span class=\"nx\">privilege<\/span>         <span class=\"p\">=<\/span> <span class=\"s2\">\"USAGE\"<\/span>\r\n  <span class=\"nx\">roles<\/span>             <span class=\"p\">=<\/span> <span class=\"p\">[<\/span><span class=\"nx\">snowflake_role<\/span><span class=\"p\">.<\/span><span class=\"nx\">role<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span><span class=\"p\">]<\/span>\r\n  <span class=\"nx\">with_grant_option<\/span> <span class=\"p\">=<\/span> <span class=\"kc\">false<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c1\">\/\/ \u30b9\u30ad\u30fc\u30de\u4f5c\u6210<\/span>\r\n<span class=\"k\">resource<\/span> <span class=\"s2\">\"snowflake_schema\"<\/span> <span class=\"s2\">\"schema\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"nx\">database<\/span>     <span class=\"p\">=<\/span> <span class=\"nx\">snowflake_database<\/span><span class=\"p\">.<\/span><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span>\r\n  <span class=\"nx\">name<\/span>         <span class=\"p\">=<\/span> <span class=\"s2\">\"TF_DEMO_SCHEMA\"<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c1\">\/\/ \u30c7\u30d5\u30a9\u30eb\u30c8\u30b9\u30ad\u30fc\u30de\u3078\u306e\u6a29\u9650\u4ed8\u4e0e<\/span>\r\n<span class=\"k\">resource<\/span> <span class=\"s2\">\"snowflake_schema_grant\"<\/span> <span class=\"s2\">\"schema_default_grant\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"k\">provider<\/span>          <span class=\"p\">=<\/span> <span class=\"nx\">snowflake<\/span><span class=\"p\">.<\/span><span class=\"nx\">security_admin<\/span>\r\n  <span class=\"nx\">database_name<\/span>     <span class=\"p\">=<\/span> <span class=\"nx\">snowflake_database<\/span><span class=\"p\">.<\/span><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span>\r\n  <span class=\"nx\">schema_name<\/span>       <span class=\"p\">=<\/span> <span class=\"nx\">snowflake_schema<\/span><span class=\"p\">.<\/span><span class=\"nx\">schema<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span>\r\n  <span class=\"nx\">privilege<\/span>         <span class=\"p\">=<\/span> <span class=\"s2\">\"USAGE\"<\/span>\r\n  <span class=\"nx\">roles<\/span>             <span class=\"p\">=<\/span> <span class=\"p\">[<\/span><span class=\"nx\">snowflake_role<\/span><span class=\"p\">.<\/span><span class=\"nx\">role<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span><span class=\"p\">]<\/span>\r\n  <span class=\"nx\">with_grant_option<\/span> <span class=\"p\">=<\/span> <span class=\"kc\">false<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c1\">\/\/ \u30b9\u30ad\u30fc\u30de\u3078\u306e\u6a29\u9650\u4ed8\u4e0e\uff08\u4eca\u5f8c\u4f5c\u6210\u3055\u308c\u308b\u3082\u306e\u3082\u542b\u3080\uff09<\/span>\r\n<span class=\"k\">resource<\/span> <span class=\"s2\">\"snowflake_schema_grant\"<\/span> <span class=\"s2\">\"schema_grant\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"k\">provider<\/span>          <span class=\"p\">=<\/span> <span class=\"nx\">snowflake<\/span><span class=\"p\">.<\/span><span class=\"nx\">security_admin<\/span>\r\n  <span class=\"nx\">database_name<\/span>     <span class=\"p\">=<\/span> <span class=\"nx\">snowflake_database<\/span><span class=\"p\">.<\/span><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span>\r\n  <span class=\"nx\">privilege<\/span>         <span class=\"p\">=<\/span> <span class=\"s2\">\"USAGE\"<\/span>\r\n  <span class=\"nx\">roles<\/span>             <span class=\"p\">=<\/span> <span class=\"p\">[<\/span><span class=\"nx\">snowflake_role<\/span><span class=\"p\">.<\/span><span class=\"nx\">role<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span><span class=\"p\">]<\/span>\r\n  <span class=\"nx\">with_grant_option<\/span> <span class=\"p\">=<\/span> <span class=\"kc\">false<\/span>\r\n  <span class=\"nx\">on_future<\/span>         <span class=\"p\">=<\/span> <span class=\"kc\">true<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c1\">\/\/ \u30c6\u30fc\u30d6\u30eb\u3078\u306e\u6a29\u9650\u4ed8\u4e0e\uff08\u4eca\u5f8c\u4f5c\u6210\u3055\u308c\u308b\u3082\u306e\u3082\u542b\u3080\uff09<\/span>\r\n<span class=\"k\">resource<\/span> <span class=\"s2\">\"snowflake_table_grant\"<\/span> <span class=\"s2\">\"table_grant\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"k\">provider<\/span>      <span class=\"p\">=<\/span> <span class=\"nx\">snowflake<\/span><span class=\"p\">.<\/span><span class=\"nx\">security_admin<\/span>\r\n  <span class=\"nx\">database_name<\/span> <span class=\"p\">=<\/span> <span class=\"nx\">snowflake_database<\/span><span class=\"p\">.<\/span><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span>\r\n  <span class=\"nx\">privilege<\/span>     <span class=\"p\">=<\/span> <span class=\"s2\">\"SELECT\"<\/span>\r\n  <span class=\"nx\">roles<\/span>         <span class=\"p\">=<\/span> <span class=\"p\">[<\/span><span class=\"nx\">snowflake_role<\/span><span class=\"p\">.<\/span><span class=\"nx\">role<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span><span class=\"p\">]<\/span>\r\n  <span class=\"nx\">on_future<\/span>     <span class=\"p\">=<\/span> <span class=\"kc\">true<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c1\">\/\/ \u30d3\u30e5\u30fc\u3078\u306e\u6a29\u9650\u4ed8\u4e0e\uff08\u4eca\u5f8c\u4f5c\u6210\u3055\u308c\u308b\u3082\u306e\u3082\u542b\u3080\uff09<\/span>\r\n<span class=\"k\">resource<\/span> <span class=\"s2\">\"snowflake_view_grant\"<\/span> <span class=\"s2\">\"view_grant\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"k\">provider<\/span>      <span class=\"p\">=<\/span> <span class=\"nx\">snowflake<\/span><span class=\"p\">.<\/span><span class=\"nx\">security_admin<\/span>\r\n  <span class=\"nx\">database_name<\/span> <span class=\"p\">=<\/span> <span class=\"nx\">snowflake_database<\/span><span class=\"p\">.<\/span><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span>\r\n  <span class=\"nx\">privilege<\/span>     <span class=\"p\">=<\/span> <span class=\"s2\">\"SELECT\"<\/span>\r\n  <span class=\"nx\">roles<\/span>         <span class=\"p\">=<\/span> <span class=\"p\">[<\/span><span class=\"nx\">snowflake_role<\/span><span class=\"p\">.<\/span><span class=\"nx\">role<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span><span class=\"p\">]<\/span>\r\n  <span class=\"nx\">on_future<\/span>     <span class=\"p\">=<\/span> <span class=\"kc\">true<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c1\">\/\/ \u30b9\u30c6\u30fc\u30b8\u4f5c\u6210<\/span>\r\n<span class=\"k\">resource<\/span> <span class=\"s2\">\"snowflake_stage\"<\/span> <span class=\"s2\">\"stage\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"nx\">name<\/span>     <span class=\"p\">=<\/span> <span class=\"s2\">\"TF_DEMO_STAGE\"<\/span>\r\n  <span class=\"nx\">database<\/span> <span class=\"p\">=<\/span> <span class=\"nx\">snowflake_database<\/span><span class=\"p\">.<\/span><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span>\r\n  <span class=\"nx\">schema<\/span>   <span class=\"p\">=<\/span> <span class=\"nx\">snowflake_schema<\/span><span class=\"p\">.<\/span><span class=\"nx\">schema<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c1\">\/\/ \u30b9\u30c6\u30fc\u30b8\u3078\u306e\u6a29\u9650\u4ed8\u4e0e<\/span>\r\n<span class=\"k\">resource<\/span> <span class=\"s2\">\"snowflake_stage_grant\"<\/span> <span class=\"s2\">\"stage_grant\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"k\">provider<\/span>      <span class=\"p\">=<\/span> <span class=\"nx\">snowflake<\/span><span class=\"p\">.<\/span><span class=\"nx\">security_admin<\/span>\r\n  <span class=\"nx\">database_name<\/span> <span class=\"p\">=<\/span> <span class=\"nx\">snowflake_database<\/span><span class=\"p\">.<\/span><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span>\r\n  <span class=\"nx\">schema_name<\/span>   <span class=\"p\">=<\/span> <span class=\"nx\">snowflake_schema<\/span><span class=\"p\">.<\/span><span class=\"nx\">schema<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span>\r\n  <span class=\"nx\">stage_name<\/span>    <span class=\"p\">=<\/span> <span class=\"nx\">snowflake_stage<\/span><span class=\"p\">.<\/span><span class=\"nx\">stage<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span>\r\n  <span class=\"nx\">privilege<\/span>     <span class=\"p\">=<\/span> <span class=\"s2\">\"READ\"<\/span>\r\n  <span class=\"nx\">roles<\/span>         <span class=\"p\">=<\/span> <span class=\"p\">[<\/span><span class=\"nx\">snowflake_role<\/span><span class=\"p\">.<\/span><span class=\"nx\">role<\/span><span class=\"p\">.<\/span><span class=\"nx\">name<\/span><span class=\"p\">]<\/span>\r\n  <span class=\"nx\">depends_on<\/span>    <span class=\"p\">=<\/span> <span class=\"p\">[<\/span><span class=\"nx\">snowflake_stage<\/span><span class=\"p\">.<\/span><span class=\"nx\">stage<\/span><span class=\"p\">]<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c1\">\/\/ \u30e6\u30fc\u30b6\u30fc\u4f5c\u6210<\/span>\r\n<span class=\"k\">resource<\/span> <span class=\"s2\">\"snowflake_user\"<\/span> <span class=\"s2\">\"user\"<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"k\">provider<\/span>             <span class=\"p\">=<\/span> <span class=\"nx\">snowflake<\/span><span class=\"p\">.<\/span><span class=\"nx\">security_admin<\/span>\r\n  <span class=\"nx\">name<\/span>                 <span class=\"p\">=<\/span> <span class=\"s2\">\"TF_DEMO_USER\"<\/span>\r\n  <span class=\"nx\">password<\/span>             <span class=\"p\">=<\/span> <span class=\"s2\">\"password\"<\/span>\r\n  <span class=\"nx\">default_role<\/span>         <span class=\"p\">=<\/span> <span class=\"s2\">\"\"<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<p>\u4ed6\u4eec\u5206\u522b\u6b63\u5728\u505a\u7684\u4e8b\u60c5\u5982\u8bc4\u8bba\u4e2d\u6240\u8ff0\u3002<\/p>\n<p>\u5728\u6dfb\u52a0\u4ee3\u7801\u4e4b\u540e\uff0c\u6211\u4eec\u4f1a\u5728\u8ba1\u5212\u4e2d\u786e\u8ba4\u66f4\u6539\uff0c\u5e76\u4e14\u5982\u679c\u6ca1\u6709\u95ee\u9898\u7684\u8bdd\uff0c\u5c31\u4f1a\u5e94\u7528\u66f4\u6539\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>terraform plan\r\n<span class=\"nv\">$ <\/span>terraform apply\r\n<\/code><\/pre>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d8924913a08637a6c51cb\/65-0.png\" alt=\"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8 2023-04-09 15.15.25.png\" \/><\/div>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d8924913a08637a6c51cb\/66-0.png\" alt=\"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8 2023-04-09 15.17.20.png\" \/><\/div>\n<p>\u6211\u8ba4\u4e3a\u5176\u4ed6\u521b\u5efa\u7684\u8d44\u6e90\u4e5f\u6309\u7167\u9884\u671f\u8fdb\u884c\u4e86\u521b\u5efa\u3002<\/p>\n<p>\u8bf7\u53c2\u8003Terraform\u7684\u63d0\u4f9b\u8005\u9875\u9762\uff0c\u4e86\u89e3\u5176\u4ed6\u53ef\u914d\u7f6e\u7684\u8d44\u6e90\u548c\u53c2\u6570\u7b49\u8bbe\u7f6e\u9009\u9879\u3002<\/p>\n<p>&nbsp;<\/p>\n<h1>\u6982\u8ff0<\/h1>\n<p>\u6211\u4ecb\u7ecd\u4e86\u4f7f\u7528Terraform\u521b\u5efa\u57fa\u672c\u8d44\u6e90\u7684\u6b65\u9aa4\u3002<br \/>\n\u6211\u5df2\u7ecf\u5c06\u672c\u6b21\u521b\u5efa\u7684\u4ee3\u7801\u4e0a\u4f20\u5728\u4e0b\u9762\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u5b9e\u9645\u4e0a\uff0c\u5f53\u5b9e\u65bd\u8fd0\u8425\u65f6\uff0c\u8fd8\u9700\u8003\u8651\u8bf8\u5982\u6587\u4ef6\u5206\u5272\u3001\u72b6\u6001\u6587\u4ef6\u7684\u5b58\u50a8\u65b9\u5f0f\u3001\u8d44\u6e90\u589e\u52a0\u65f6\u7684\u5904\u7406\u7edf\u4e00\u5316\u7b49\u65b9\u9762\u3002\u5bf9\u4e8e\u8fd9\u4e9b\u95ee\u9898\uff0c\u6211\u8ba1\u5212\u5728\u53e6\u4e00\u7bc7\u6587\u7ae0\u4e2d\u8be6\u7ec6\u8ba8\u8bba\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9996\u5148 \u5728\u4f7f\u7528Terraform\u6784\u5efaSnowflake\u7684\u8fc7\u7a0b\u4e2d\uff0c\u53c2\u8003Snowflake\u63d0\u4f9b\u7684\u6559\u7a0b\u662f\u5f88\u5bb9\u6613\u7406\u89e3\u7684\u3002 [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-49072","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u5728Snowflake\u4e0a\u521b\u5efa\u8d44\u6e90\u7684\u6b65\u9aa4\u662f\u4f7f\u7528Terraform - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5728snowflake\u4e0a\u521b\u5efa\u8d44\u6e90\u7684\u6b65\u9aa4\u662f\u4f7f\u7528terraform\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5728Snowflake\u4e0a\u521b\u5efa\u8d44\u6e90\u7684\u6b65\u9aa4\u662f\u4f7f\u7528Terraform\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u5728\u4f7f\u7528Terraform\u6784\u5efaSnowflake\u7684\u8fc7\u7a0b\u4e2d\uff0c\u53c2\u8003Snowflake\u63d0\u4f9b\u7684\u6559\u7a0b\u662f\u5f88\u5bb9\u6613\u7406\u89e3\u7684\u3002 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5728snowflake\u4e0a\u521b\u5efa\u8d44\u6e90\u7684\u6b65\u9aa4\u662f\u4f7f\u7528terraform\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-30T22:39:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T16:37:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d8924913a08637a6c51cb\/25-0.png\" \/>\n<meta name=\"author\" content=\"\u65b0, \u97f5\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u65b0, \u97f5\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/\",\"name\":\"\u5728Snowflake\u4e0a\u521b\u5efa\u8d44\u6e90\u7684\u6b65\u9aa4\u662f\u4f7f\u7528Terraform - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-01-30T22:39:52+00:00\",\"dateModified\":\"2024-04-29T16:37:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5728Snowflake\u4e0a\u521b\u5efa\u8d44\u6e90\u7684\u6b65\u9aa4\u662f\u4f7f\u7528Terraform\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9\",\"name\":\"\u65b0, \u97f5\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g\",\"caption\":\"\u65b0, \u97f5\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunxin\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5728Snowflake\u4e0a\u521b\u5efa\u8d44\u6e90\u7684\u6b65\u9aa4\u662f\u4f7f\u7528Terraform - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u5728snowflake\u4e0a\u521b\u5efa\u8d44\u6e90\u7684\u6b65\u9aa4\u662f\u4f7f\u7528terraform\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5728Snowflake\u4e0a\u521b\u5efa\u8d44\u6e90\u7684\u6b65\u9aa4\u662f\u4f7f\u7528Terraform","og_description":"\u9996\u5148 \u5728\u4f7f\u7528Terraform\u6784\u5efaSnowflake\u7684\u8fc7\u7a0b\u4e2d\uff0c\u53c2\u8003Snowflake\u63d0\u4f9b\u7684\u6559\u7a0b\u662f\u5f88\u5bb9\u6613\u7406\u89e3\u7684\u3002 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5728snowflake\u4e0a\u521b\u5efa\u8d44\u6e90\u7684\u6b65\u9aa4\u662f\u4f7f\u7528terraform\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-01-30T22:39:52+00:00","article_modified_time":"2024-04-29T16:37:48+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d8924913a08637a6c51cb\/25-0.png"}],"author":"\u65b0, \u97f5","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u65b0, \u97f5","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/","name":"\u5728Snowflake\u4e0a\u521b\u5efa\u8d44\u6e90\u7684\u6b65\u9aa4\u662f\u4f7f\u7528Terraform - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-01-30T22:39:52+00:00","dateModified":"2024-04-29T16:37:48+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5728Snowflake\u4e0a\u521b\u5efa\u8d44\u6e90\u7684\u6b65\u9aa4\u662f\u4f7f\u7528Terraform"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9","name":"\u65b0, \u97f5","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g","caption":"\u65b0, \u97f5"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunxin\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8snowflake%e4%b8%8a%e5%88%9b%e5%bb%ba%e8%b5%84%e6%ba%90%e7%9a%84%e6%ad%a5%e9%aa%a4%e6%98%af%e4%bd%bf%e7%94%a8terraform%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/49072","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=49072"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/49072\/revisions"}],"predecessor-version":[{"id":88616,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/49072\/revisions\/88616"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=49072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=49072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=49072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}