Dataset using Simple Query

• By this process User can create dataset by writing a simple query.

1. Login to AIV training server using your credentials.

2. Go to hamburger menu > MasterData > Dataset Section.

   

3. User can create Dataset using 2 different ways:-

I. From the Footer Menu

II. From the Context Menu

4. Click on Create Dataset option using anyone option listed above.

5. Enter the details in Create Dataset window as per below:-

• Name: Demo New (user can select name as per their requirement)
  
• Source: Select aws_rds from drop-down (same name as you set it when you are creating database connection)
  

6. Write your Query in Query window as shown below:

7. For this example you can refer below Query.

:::note[Info] Query

Select * from products

:::

8. We have written products in Query because we are going to use that table for making Dataset.

9. Go to Output Columns Tab & your window will look as per image below:

10. Click on Preview button.

11. Click on Submit button & your Dataset will be created & it will be available in listview of Dataset section.