Snowflake存储集成是否支持多个Azure存储帐户?在文档(https://docs.snowflake.com/en/user-guide/data-load-azure-config.html)中,它是这样指定的。
create storage integration azure_int
type = external_stage
storage_provider = azure
enabled = true
azure_tenant_id = 'a123b4c5-1234-123a-a12b-1a23b45678c9'
storage_allowed_locations = ('azure://myaccount.blob.core.windows.net/mycontainer1/mypath1/', 'azure://myaccount.blob.core.windows.net/mycontainer2/mypath2/')
storage_blocked_locations = ('azure://myaccount.blob.core.windows.net/mycontainer1/mypath1/sensitivedata/', 'azure://myaccount.blob.core.windows.net/mycontainer2/mypath2/sensitivedata/');
我的问题是“它是否像下面这样支持?”
create storage integration azure_int
type = external_stage
storage_provider = azure
enabled = true azure_tenant_id = 'a123b4c5-1234-123a-a12b-1a23b45678c9'
storage_allowed_locations = ('azure://myaccount1.blob.core.windows.net/mycontainer1/mypath1/', 'azure://myaccount2.blob.core.windows.net/mycontainer2/mypath2/')
storage_blocked_locations = ('azure://myaccount1.blob.core.windows.net/mycontainer1/mypath1/sensitivedata/', 'azure://myaccount2.blob.core.windows.net/mycontainer2/mypath2/sensitivedata/');
发布于 2021-09-01 05:21:30
可以,可以在存储集成中为多个帐户设置它。请注意,对于交叉租户vnet规则,它需要与他们的Snowflake帐户或具有Azure的paired region位于同一区域。
https://stackoverflow.com/questions/69007484
复制相似问题