(Glue-2305) App User Interface

Owned by Robert Adamec
Last updated: Jul 06, 2023 by Marian Vidra
3 min read

Source management

In the sidebar, you can manage sources. Each source represents replicated storage, you can read more about them here Architecture design.

To add a new source, enter its name into the text box and press Add source. Keep in mind that the name will be capitalized. The newly created source will be created with the current Default source settings.

To delete a source, enter its name in the text box and press Delete source. This drops the entire schema with corresponding objects within it.

Main screen

The refresh button, in the right top corner, only refreshes sources, active merges, and available warehouses. It does not refreshes settings.

The UI consists of 2 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.

 

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. Here you can manage to merge tasks on replicated tables.

 

Settings

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

Available settings:

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

  2. Metadata table → name of the table that holds SNP GlueTM metadata

  3. Stream name → the name of the stream that will be created on the metadata table

  4. Historical table suffix→ suffix of the table where data from the replicated table will be merged into

  5. Control scheduling period → how often the 'START_CONTROL' task should run. This task checks the metadata table stream for new entries of replicated tables and creates appropriate objects to start the deferred merge on them

  6. Merge scheduling period → how often merge should run on replicated tables

  7. Save settings button → save current settings

  8. The control managing button has 3 states → ‘Start control', ‘Suspend control’, and ‘Resume control’ based on the current state of the ‘START_CONTROL’ task.

    • Start control → creates a 'START_CONTROL’ task and a stream for the metadata table.

    • Suspend control → Suspends 'START_CONTROL' task.

    • Resume control → Recreates and resumes the 'START_CONTROL' task with current source 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.

Multiple options can be selected.