Add Table Policy documentation

crate / cloud-docs

Documentation for CrateDB Cloud.

https://crate.io/docs/cloud/

Apache License 2.0

0 stars 1 forks source link

Add Table Policy documentation #72

Closed matkuliak closed 4 months ago

matkuliak commented 4 months ago

What's Inside

Documentation of new feature - Table Policies

Preview

https://crate-cloud--72.org.readthedocs.build/en/72/reference/overview.html#table-policies

Highlights

What the feature does
How to get to it
Configuration
Logs

Checklist

[x] Link to issue this PR refers to (if applicable): https://github.com/crate/cloud/issues/1602
[x] CLA is signed

proddata commented 4 months ago

Can we maybe add an example?

e.g. set replicas to 0 for data older than 30 days -> to save space for the replica with the assumption it is already available in a snapshot
delete data that is older than 60 days

could be very simple

CREATE TABLE data_table (
   ts TIMESTAMP
   ts_day GENERATED ALWAYS AS date_trunc('day',ts),
   val DOUBLE
) PARTITIONED BY (ts_day);

matkuliak commented 4 months ago

Something like this? https://github.com/crate/cloud-docs/pull/72/files#diff-88ca359c1e314aab139ab284940806ab980c28bc964aef99f258756727c5b47fR790

Also, I meant to ask about the segment merge action. I'm not exactly sure what it does😅 And also couldn't find much about it on CrateDB docs. Could you explain please? I think I should clarify it, or add a note maybe @proddata