.alter table policy caching command
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer
Change's the table's cache policy. To speed up queries, data is cached on processing nodes, in SSD, or even in RAM. The cache policy allows your database to describe the data artifacts that it uses, so that more important data can take priority.
You must have at least Table Admin permissions to run this command.
.alter
table
[DatabaseName .
]TableName policy
caching
PolicyParameters
Learn more about syntax conventions.
Name | Type | Required | Description |
---|---|---|---|
DatabaseName | string |
The name of the database. When you run the command from the database context that contains the table to alter, DatabaseName is not required. | |
TableName | string |
✔️ | The name of the table. Use without DatabaseName when running in the required database's context. |
PolicyParameters | string |
✔️ | The policy parameters to set. See cache policy. |
Set the caching policy to include the last 30 days.
.alter table MyTable policy caching hot = 30d
Set the caching policy to include the last 30 days and extra data from January and April 2021.
.alter table MyTable policy caching
hot = 30d,
hot_window = datetime(2021-01-01) .. datetime(2021-02-01),
hot_window = datetime(2021-04-01) .. datetime(2021-05-01)
Set the caching policy for several tables to include the last 30 days, and data from January and April 2021.
.alter tables (MyTable1, MyTable2, MyTable3) policy caching
hot = 30d,
hot_window = datetime(2021-01-01) .. datetime(2021-02-01),
hot_window = datetime(2021-04-01) .. datetime(2021-05-01)
Set the caching policy for several tables to include the last 30 days.
.alter tables (MyTable1, MyTable2, MyTable3) policy caching hot = 30d