Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ Azure Data Explorer
Turns on or turns off a table's ingestion time policy. This policy adds a hidden datetime column in the table, called $IngestionTime. Whenever new data is ingested, the time of ingestion is recorded in the hidden column.
Permissions
You must have at least Table Ingestor permissions to run this command.
Syntax
.alter table TableName policy ingestiontime Flag
.alter tables (TableName, ...) policy ingestiontime Flag
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| TableName | string |
✔️ | The name of the table. |
| Flag | bool |
✔️ | Determines whether to turn on or turn off the policy. true turns on the policy. false turns off the policy. |
Examples
To turn on the policy:
.alter table table_name policy ingestiontime true
To turn off the policies of multiple tables:
.alter tables (table1, table2) policy ingestiontime false