...
This document is a walkthrough to create and edit an import Model through the Sprngy UI.
Pre-requisites:
The list of tools required to run/develop in the UI are as follows:
...
Visual Studio Code (Developers only)
...
Python 3.8.10
...
Flask 1.1.4
...
Node 14.17.6
...
npm 7.24.1
...
R 3.6.3
...
Application is created in Admin UI.
Import Model
An import model is used to import dataset from source location to sprngy datalake.
...
To create a new Import Model, select the required Module name and Entity name from the drop down and click 'Submit'.
Alternatively, using the Upload box, import model (in csv) format can be uploaded for the selected entity.
This checks the existence of a import model. If there is a previously created or even initiated import model then it will bring back that data, if creating import model for the very first time then provides blank fields for input.
...
Field Name | Description | Data Type | is Required? | Validation |
|---|---|---|---|---|
Entity Business Owner Name | First name + Last name of Entity Business Owner | String | Yes |
|
Entity Business Owner Email | The Business Owner email Id | String | Yes | should have @ |
Entity Data Owner Name | The Data Owner Name of Entity | String | Yes |
|
Entity Data Owner Email | The Data Owner Email of Entity | String | Yes | should have @ |
Entity It Owner Name | The IT owner name of an entity | String | Yes |
|
Entity It Owner Email | The IT owner email of the entity | String | Yes | should have @ |
Vendor Support Name | The vendor support name of the entity. Default Non-editable to support@sprngy.com, non-editable | String | Auto-Fill |
|
Vendor Support Email | The vendor support name of the entity. Default Non-editable to support@sprngy.com, non-editable | String | Auto-Fill |
|
After these details have been filled out, you can hit on “Back” to go to “Step 1” or if you are done filling out your PreEntity Details all details you can hit on “Submit”.
Step 3 -
...
After you are done with creating all your queries, click on “Final Submit”. This will create your import model in your local HDFS Sprngy datalake and route you back to your home screen.
Bulk Upload Import Model
There is also one other way to create a import model, that is by uploading a CSV file. For this, you are required to have a import model .csv file with all the required fields. To directly upload a csv -
Home Screen:
The image below is the Home screen of the UI.
From the side menu open ‘Meta Data Configuration' option, then select 'Import Model’ option.
...
Step 1 -
After clicking on the Import Model menu option below screen will be displayed.
...
Select the module and entity for which you want to upload a import model. In the file upload option browse or drag and drop the import model csv file and click Submit.