.delete table update policy
Delete the table update policy. The update policy instructs Azure Data Explorer to automatically append data to a target table whenever new data is inserted into the source table, based on a transformation query that runs on the data inserted into the source table.
Note
The source table and the table for which the update policy is defined must be in the same database. The update policy function schema and the target table schema must match in their column names, types, and order.
Permissions
You must have at least Table Admin permissions to run this command.
Syntax
.delete
table
[ DatabaseName.
]TableName policy
update
Parameters
Name | Type | Required | Description |
---|---|---|---|
DatabaseName | string | The name of the database. This is required when running the command from outside the database context of the specified table. | |
TableName | string | ✓ | The name of the table. |
Returns
Returns a JSON representation of the policy.
Example
Delete the update policy for a table:
.delete table MyDatabase.MyTable policy update