英文:
ADX: Update policy cross database
问题
可以在多个数据库之间创建更新策略吗?我指的是像 db_1 中的 table_1 应该通过更新策略将数据发送到 db_2 中的 table_2。
如果不能,为什么不起作用?
还有:关于函数呢?我能跨数据库选择数据吗?
英文:
Is it possible to create an update policy across databases?
I mean like table_1 in db_1 should send data via update policy to table_2 in db_2.
If not, why does it not work?
And: What about functions? Can i select data across dbs?
答案1
得分: 0
> 是否可以跨多个数据库创建更新策略?
根据文档的说明,目前不支持此功能:
与策略相关的查询可以调用存储函数,但无法访问数据库外部的数据。
具体来说:
- 不能执行跨数据库查询
- 不能执行跨集群查询
...
> 如果不能,为什么不起作用?
目前由于安全考虑而被阻止。未来可能会使用托管身份支持此功能。
> 函数呢?我可以选择跨数据库的数据吗?
允许存储函数包括跨数据库的引用。
例如:
.create function MyFunction() {
database("MyOtherDatabase").MyTable
| summarize max(Timestamp)
}
英文:
> Is it possible to create an update policy across databases?
as mentioned in the documentation, this is not currently supported:
The policy-related query can invoke stored functions, but can't access data external to the database.
specifically:
- It can't perform cross-database queries
- It can't perform cross-cluster queries
...
> If not, why does it not work?
this is currently blocked due to security considerations. it may be supported in the future using managed identities.
> What about functions? Can i select data across dbs?
stored functions are allowed to include cross-database references.
for example:
.create function MyFunction() {
database("MyOtherDatabase").MyTable
| summarize max(Timestamp)
}
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论