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.

Indices panel in the Schema Designer

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:

Custom index TTL configuration

  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

    • Related Articles

    • System Model Definition Query

      Article Type: Reference Audience: Developers Module: Data Models The System Model Definition is helpful in training your AI Models, building queries, and exposing your application ontology to visual graph tools. 1. Open the API Explorer Navigate to ...
    • Data Model (Schema) Design Standards

      Article Type: Standard / Reference Audience: Solution Architects, Application Designers, Developers Module: Fuuz Platform - Data Model Designer Applies to Versions: 2025.12+ 1. Overview Data Model (Schema) Design Standards define the mandatory ...
    • Master Data Table Screen Design Standard

      Master Data Table Screen Design Standard Article Type: Standard / Reference Audience: Solution Architects, Application Designers, Developers Module: Fuuz Platform - Application Designer Applies to Versions: 2025.12+ Template Reference: ...
    • Fuuz Data Flow Nodes - Complete Reference

      Article Type: Reference Audience: Developers, App Admins, Solution Architects Module: Data Flows / Data Ops Applies to Versions: All 1. Overview The Fuuz Industrial Operations Platform provides a comprehensive visual flow designer with 50+ ...
    • Historical Data Table Screen Design Standard

      Article Type: Standard / Reference Audience: Solution Architects, Application Designers, Developers Module: Fuuz Platform - Application Designer Applies to Versions: 2025.12+ Template Reference: Table_Screen_Design_Template_-_History_0_0_1.json 1. ...