(Glue-2311) App User Interface

Source management

In the sidebar, you can manage sources. Each source represents replicated storage, you can read more about them here https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/4420862777.

To add a new source, either select an already existing database or enter a new database name and click on the Create button. Then in the Select schema box, enter the name of the source you want to add and click Create.

Open

Main screen

The UI consists of two tabs. The first tab, Overview, is for general information regarding merges running on replicated tables and their management. The second tab, Settings, is for managing either default settings, or per schema settings.

Open

Overview

At the top of the Overview tab, you can see the current state of merge tasks on individual tables.

Under statistics is the Merge tasks area where you can manage to merge tasks on replicated tables.

Settings

In settings, you can manage settings for the currently selected source.

Available settings:

1. Merge settings

   1. Warehouse: What warehouse should be used for merge execution.

   2. Historical table suffix: Suffix of the table where data from the replicated table will be merged into.

   3. Merge scheduling period: How often merge should run on replicated tables.

   4. Backup retention period: Retention period for backups created after table deactivation (in days)

2. Metadata settings

   1. Timestamp field: Name of the field used to determine the last record of a specific key

   2. Change field: Type of change of specific field

   3. Insert flag: What identifier in metadata should represent inserts, can insert multiple values if they are separated by a comma, use the '<empty>' placeholder for space

   4. Update flag: What identifier in metadata should represent updates, can insert multiple values if they are separated by a comma, use the '<empty>' placeholder for space

   5. Delete flag: What identifier in metadata should represent deletes, can insert multiple values if they are separated by a comma

3. Save settings button: Saves current settings

Application role management

In Manage Access one can manage application roles assignment. After clicking on it select to which account role you want to grant privileges. Then select application roles to be granted by clicking on the specific role.