Direct Query

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 into the dashboard.

The direct query option does not create cache files and reads the data directly from the live data source. RubiSight Dashboard provides the function to enable/disable Direct Query at the dataset level. This option is applicable for that particular dashboard level and will work as set at other dashboard levels.



    • Related Articles

    • Disable Direct Query

      To Disable Direct Query in a dataset in the dashboard, follow the steps below. Open the dashboard in edit mode. Refer to Editing the Dashboard. The dashboard is displayed. In the Data Pane, click the ellipsis corresponding to the dataset, and then ...

    • 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 ...

    • Adding A Custom Query

      To add a Custom Query while creating a dataset, follow the steps given below. Click Custom Query on any dataset creation page. The Add Custom Query page is displayed. Enter a suitable Name for your custom query. Enter a suitable Description for your ...

    • Google Big Query

      Google Big Query is a serverless architecture. It lets you query huge amounts of data and provides desired results in seconds. It helps you to manage and analyse your data with built-in features. Prerequisites for a Google Big Query are: Google Cloud ...

    • 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 ...