Skip to content
AIV

Create Dataset using View

What is View?

  • A view is a database object that has no values. Its contents are based on the base table. It contains rows and columns similar to the real table. You can use views to hide table columns from users by granting them access to the view and not to the table itself.

Prerequisites

  • To create dataset by creating view in MySQL. User needs to work with MySQL Workbench.

  1. Log in to AIV using your respective credentials.

  2. Go to Hamburger Menu Image > MasterData > Dataset.

    Image

    Image

  • To know more in details about Dataset Section Click here .
  1. User can create dataset using 2 options:-

I. From the Footer Menu

Image

II. From the Context Menu

Image

  1. Click on Create Dataset option & your screen will look as per below image.

    Image

  1. Enter the details in Create Dataset window as per below:-
  • Name: Demo Dataset (user can select name as per their requirement)
  • Source: Select aiv from drop-down (same name as you set it when you are creating database connection)

  1. In Datasource option JDBC is selected by default.

    Image

  2. Write Query in Query window as given below:

  3. For this example we used below given query.

:::note[Info] Query

SELECT * FROM customersview;

:::

Image

  1. Click on Preview button & it will show the output as per the image below:

Image