Creating a Data Set using the Pinot DB Connector

Check out the illustration on creating a Pinot Data Set based on a Pinot Data Connector.

• Navigate to the Data Center homepage.

• Click the New option.

• Select the Data Set option from the context menu.

• A list of available Data Connectors appears entitled as Data Source Name.

• Select a Data Connector with the Pinot database.

• Click the Create Data Set icon.

• The Data Set page opens.

• Configure the following fields:

  • Service Name: Enter any user-defined name for the new data set.

  • Description: Provide a brief description of the Data Set (optional).

  • Data Connector Name: This is a pre-defined field based on the selected data connector.

  • Database Name: This is a pre-defined field based on the data connector chosen earlier.

  • Query: Write a valid query service in the given space.

• Table Information: On the right side of the page Table information is displayed. It will contain all the tables in the Database and the Column name in the table. Double click on the Table or Column will auto-generate a sample query for the user to validate and get data.

• Click the Validate option to execute the new Data Set.

Please Note: Users must perform the following steps if the data set query contains a filter.

• If the query contains filters, then the right-side filter column will appear.

• Click on the Continue button to execute the query.

• A message appears to inform the successful execution.​

• The data preview appears at the bottom of the page.

• The Save option gets enabled.

• A notification message appears to ensure the completion of the action.​

• The newly created Data Set gets added to the Data Sets List.