Setting TTL on a Data Model Table

Setting TTL on a Data Model / Table

Article Type: Reference Audience: Developers Module: Data Models

In designing solid applications, it is best practice to consider the data you'll be storing in Fuuz, and determine with your business users how long that data should be retained. In Fuuz you can do this by establishing appropriate TTLs on your data models using indices.

Instructions

1. Open the Schema Designer
2. Locate the data model you wish to apply TTL to — drag it out to the canvas and select it by clicking on it to highlight and expose the configuration panel on the right side of the designer canvas
3. Scroll the panel down until you see Indices — expand this panel
4. Click the + option to add a custom index
5. Within the custom index, define the date field you wish to use as your baseline
6. Set the TTL value (in seconds)
   • This is the amount of time, from the date/time in the date field you've selected, to effect the TTL
7. Save and Deploy your changes

Note: You cannot set TTL on the pre-defined system indices; however, you can add your own custom indices (even for the same fields as the system-defined indices) and then set your TTL.

To recap:

1. Open the Schema Designer
2. Select the data model and drag it to the canvas
3. Select the data model — expose the configuration panel — scroll to Indices
4. Click +

Then:

1. Set the index name
2. Set the TTL (seconds) — the example is 1 year
3. Set the field to index on — the example is ["createdAt"]
4. Save/Deploy your updates

See Also

• Indices
• Cascade-Deletion
• Data-Model-Schema-Design-Standards
• Data-Change-History

---

Source: support.fuuz.com