Adding A Custom Query

Adding A Custom Query

To add a Custom Query while creating a dataset, follow the steps given below.

  1. At the product selection page click on create dataset under Data Connect.

  2. Then Select any dataset Under RDBMS
  3. Click  Add  Custom Query on selected dataset. Then Add Custom Query page is displayed.

  4. Enter a suitable Name for your custom query.
  5. Enter a suitable Description for your query.
  6. Enter your query in the Add Custom Query field. (For example, select * from A where city = "Pune")
  7. Click Add Query. The query is added to your Dataset.

The following figure shows Add Custom Query page.




Notes:

  • You can add multiple queries to your Dataset. Repeat the steps to add more custom queries.
  • For more information on MongoDB custom query, refer Query Your Data

    • Related Articles

    • Custom Functions in RubiPython

      Reading Data from File A sample Python code to read data from file is shown in the image below. The table below explains the above code snippet. Line of Code Result getReaderData(“datasetName”,“subdatasetName”) This custom function checks the type of ...

    • Custom Functions in RubiPython

      Reading Data from File A sample Python code to read data from file is shown in the image below. The table below explains the above code snippet. Line of Code Result getReaderData(“datasetName”,“subdatasetName”) This custom function checks the type of ...

    • Enable Direct Query

      To Enable Direct Query for a dataset in the dashboard, follow the steps below. Open the dashboard in edit mode. Refer to Editing the Dashboard. The dashboard is displayed. If required, add a new dataset to the dashboard. Refer to Adding a dataset to ...

    • Direct Query

      "Direct Query" is the term that usually refers to a feature in Data Visualization. It fetches the real-time data from the underlying data source. The direct query option is useful when dealing with large datasets that are unable to import efficiently ...

    • Snowflake

      Creating Snowflake Dataset To create a snowflake dataset, follow the steps 1 and 2 given in Creating SQL Dataset. The following figure shows the Product Selection page. The Data Connect page for choosing your dataset type is displayed. From the RDBMS ...