Create Superset Metrics for Stock On Hand Report

When we create the Stock On Hand metrics in postgresql in we need to define these metrics in the database. This ticket focuses on creating the Superset metrics to be able to connect to that database and create the dashboard.

Activities:

• Create a generic demo user account in Superset (demo|Password1)

• Create a database connection in Superset to connect to the postgreSQL datasource running in the local docker container

• Create one slice for Stock On Hand report

• Create a dashboard for the stock on hand report

• Export a SQL template of these items from the Superset metadata database

• Create Nifi processor group to load in these tables

• Create a Nifi template of this processor group

Acceptance Criteria:

• Slice and dashboard is created

• SQL export is complete

• Nifi template is exported and pasted to this ticket