Direct Query Dataset

Direct Query is a mechanism to fetch the updated data directly from the data source (i.e. connector) using Metadata stored in the application table.
When Direct Query feature is enabled, the Storyboard data will be stored in the Meta datastore instead of Elasticsearch and is saved under the “Direct Query” folder.
NOTE:
The saved Storyboard data will be stored in the Database and no index is created in Elasticsearch.
Perform the following steps to create Dataset with Direct Query:
  1. Navigate to the Connections tab and select the folder where the connection is added.
  2. Click the [] icon and click [Add Dataset].
  3. The Add Dataset page displays. Provide the following details:
    • Dataset Name
      : Provide a unique Dataset name.
      NOTE:
      If the Dataset with the provided name is already created, an error message displays.
    • Connection Name
      : Displays the selected Connection Name.
    • Direct Query
      : Toggle the [Direct Query] option using the slider to enable Direct Query.
  4. Add the desired data tables to the Selected data section.
    Enable Direct Query
  5. Click [Next] the Customize Data page display.
  6. Click [Add Join] to generate multiple joins and select the respective columns from table with primary key and foreign key relationship.
  7. Click [Next] the Modify Entities page displays.
    1. Select the Source Time Zone from the drop-down list.
    2. Select the desired columns to generate the Dataset and click [Next].
      Modify Entities - Direct Query
  8. The Preview Dataset page displays, click [Next].
    Preview Dataset - Direct Query
  9. On the Configure Dataset page
    “For direct queries, data sync configuration is not applicable. Click the Finish button to continue”
     message displays.
    Configure Dataset - Direct Query
  10. Click [Finish] the
    “Dataset Saved Successfully”
     message displays and Create a Content for this Dataset dialog displays.
    Configure Dataset - Direct Query
  11. If user does not want to continue creating the Content, click [Not Now]. This saves the dataset.
    (OR)
    Click [Sure] to continue creating the Content. The Add Content page displays.
Direct Query Dataset Information
  1. Click the new Dataset, navigate through the tabs to view respective information:
    • Details tab
      : Displays the Dataset created information and Dataset Sync information.
      Dataset Details - Direct Query
    • Preview Dataset
      : Displays the Dataset preview for 1000 rows by default. User can select the number of rows to display from the drop-down list. Click the column header to apply filter to the columns or to select the columns to display on the Preview Dataset panel.
      Preview Dataset - Direct Query
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.