search

Editing a Data Store

Edit an existing Data Store to update its configurations, fields, or query. The editing process may vary based on the Data Source category (e.g., RDBMS, API).

circle-exclamation

Prerequisites:

  • You have access to the Data Center → Data Stores.

  • You have permission to view/edit the target Data Store.

hashtag
Steps to Edit a Data Store

  1. Navigate to the Data Stores List Go to Data Center → Data Stores.

  2. Select the Data Store From the list, select the Data Store you wish to edit.

  3. Enter Edit Mode Click the View/Edit icon next to the Data Store. Result: The selected Data Store opens in editable format.

  4. Edit Data Store Details

    • Modify fields or configurations as required:

      • Name

      • Description

      • SQL query

      • Dimensions, Measures, Time fields

      • Data Type Definitions

      • Hierarchy settings

    • Next: Click Next to proceed through the steps for editing.

  5. Complete Configuration

    • Continue editing details in subsequent steps (e.g., Data Restrictions, Schedule Refresh).

    • Review all configuration pages until the final step.

  6. Finish Editing Once you’ve completed the required changes, click Finish. Result: A confirmation message appears, and the selected Data Store is updated.

circle-info

Important Notes & Tips:

  • The steps required to create/edit a Data Store may vary depending on the Data Source (e.g., RDBMS, API, File).

  • Validation Required for Database Data Stores: For Database-based Data Stores, ensure to validate the query and fields before saving.

  • Validate early: For RDBMS-based Data Stores, always click Validate after editing the query or structure to ensure it runs correctly.

  • Step-by-step editing: Don’t skip over any intermediate steps like Dimensions, Measures, or Time—they affect your data model.

hashtag
Troubleshooting

  • Save button disabled: Ensure you've completed all required fields in the current step and validated the data for Database-based Data Stores.

  • Unexpected changes after save: Recheck previous steps for missing field changes or unsaved modifications.

  • Query not working: If the query fails during validation, check for syntax errors, missing fields, or incorrect data types.