Creating and Updating Instance

This section explains how to create and update an instance for a Data Store, including setting and refreshing Time to Live (TTL) limits.

Prerequisites: The Data Store Settings must be configured in the Admin module to enable the Instance functionality inside a Report.

What is a Personalised Store?

A Personalised Data Store is one where the user can set a Time to Live (TTL) limit using the Story interface. This allows temporary control over how long the data remains available for reporting.

• TTL Range: 1 to 30 days

• Maximum TTL Limit: 30 days

If the TTL expires, the data will no longer be available in the report until refreshed.

Creating an Instance

When creating a report from a Data Store, you can configure its Time to Live (TTL):

1. Navigate to the Create New Report page.

2. Filter the Data Store list by the Personalised category.

3. Select a Data Store using the checkbox next to its name.

4. Open the TTL (Time to Live) option.

5. Specify the TTL value (between 1 and 30 days).

6. Proceed with report creation.

Updating an Instance

If a Data Store instance expires, you must manually update it.

• Expired instances are flagged in the Days Left column, showing Expired in red.

Steps to update:

1. Navigate to the Create New Report page.

2. Filter the Data Store list with the Personalised category.

3. Select a Data Store marked as Expired.

4. Open the TTL (Time to Live) option.

5. Enter the number of days (up to 30).

6. Click Refresh.

7. A notification confirms the update.

8. The refreshed TTL value is displayed in the Days Left column.

9. Continue with Create Report to design and save the report.

Distinguishing Data Stores

• Instance-based vs. Scheduler-based Data Stores

  • Instance-based: Requires TTL configuration and manual refresh.

  • Scheduler-based: Automatically refreshed based on defined schedules.

• Active vs. Expired Instances

  • Active: TTL is within the valid range.

  • Expired: Marked with Expired Status in the Data Store list.

Notes:

• Always ensure TTL is updated before it expires to avoid interruptions in reporting.

• Expired instances must be refreshed to repopulate data in PostgreSQL, ClickHouse, MongoDB, and Pinot.

• TTL cannot exceed 30 days; attempts to set a higher value will be rejected.