Data Querying and Visualization

The significance of this test is to demonstrate the following:

"As a user logging into the SDL, I can query the data in the browser using Superset and create dashboards from Superset"

Steps to Validate Superset Querying

Browse to SDL instance URL and login w/ appropriate credentials
In the Catalog page, select target datasource (example datasource for this procedure: Palantir), then click Enable
Click on View for the same tile, once it becomes available > Note: You may need to wait a up to 3 minutes for data to populate, depending on connectivity
On right side of new window - click Open in SQL Labs button
If prompted, click Sign in with Keycloak
In the SCHEMA dropdown - choose same datasource that was enabled earlier (ie Palantir)
In the SEE TABLE SCHEMA dropdown - choose a table (ie admin_palantir)
In the input-field on the right, input an appropriate SQL query for the dataset (ie `SELECT * FROM admin_palantir`) and click RUN
Look at the data populated from the table in the RESULTS section and verify it is viewable

Browse to SDL instance URL and login w/ appropriate credentials
In the Catalog page, select target datasource (example datasource for this procedure: Palantir), then click Enable
To create a dashboard in ArcadeDB:
SQL query: SELECT * FROM admin_palantir
click run
Click new CREATE CHART button that should be available in the RESULTS section
In the pop-up frame, name the new chart appropriately and click SAVE & EXPLORE button
In new window, under DATA > Visualization type, click View all charts
In the pop-up frame, under Category, select Flow > Chord Diagram and the click SELECT
In the Query section, under DATA, configure the following:
For SOURCE click the box, then in the new frame, drop-down under SIMPLE > COLUMN and select abc data, and click SAVE
For TARGET click the box, then in the new frame, drop-down under SIMPLE > COLUMN and select abc totalcount, and click SAVE
For METRIC click the box, then in the new frame, drop-down under SAVED > SAVED METRIC and select f(x) count, and click SAVE
Click UPDATE CHART at the bottom of DATA section, then click SAVE at top-right corner
In the new frame, input test for CHART NAME, input test for ADD TO DASHBOARD and click test in the new drop-down to set the value
Click SAVE & GO TO NEW DASHBOARD