Define DataHub Queries

you can define a database query from your litmus add ins in a structured, sequential way the process resembles the syntax familiar to queries in dashboard tools like grafana and executes within an excel integrated query before you begin ensure at least one datahub connection is already created see define datahub connections docid 6o3gzwf3gm2lwncmekbjw for details confirm that your selected database includes the necessary measurements ( tables ) see configure an external datahub source docid\ krblzusscfmgbvwx41dw to learn more step 1 navigate to query management form open a new excel file with litmus excel add ins enabled see install litmus excel add ins docid\ gzdhbj1xzznddthyocuuu to learn more click on manage datahub queries the litmus datahub queries window pops up you can take the following actions from this page add a new queries see step 2 (next step) below for detailed steps learn more this add in only supports queries using influxdb v1 you can access the influxdb documentation through this link step 2 add a new query note verify the visibility of the add button, which indicates readiness for query creation if the add button isn't visible, check the define datahub connections docid 6o3gzwf3gm2lwncmekbjw guide click the add button to begin the process the system will prompt for a query name and connection selection query name the tool auto generates a default query name that includes the creation date and time (optionally) modify the default name to align with your internal naming standards connection name choose the appropriate connection from the drop down menu see define datahub connections docid 6o3gzwf3gm2lwncmekbjw if you don't see any defined connection step 3 configure query parameters configure the following fields from pick the desired table (from the drop down menu) for the query query statement it displays only the query that the user configures using all the other tools time range, order by, limit, slimit, select, where the system constructs a default query that applies a mean calculation on the selected field groups results by time orders data in ascending order note the default time range is set to the last hour if the query syntax is correct, you will see the message " query is executable " in green at the bottom step 4 preview the query results use the preview icon to display the first 10 rows of query results the results for action execution window appears the preview serves as an initial data check troubleshooting a lack of data may indicate an incorrect query configuration a combination of conditions that returns no data no data available within the selected time range step 5 save and finalize the query after validating the query setup, click save to save the query when saved, a new excel sheet with query details is added, and the dashboard updates accordingly note the query remains functional independently of the datahub add in and can be refreshed directly via excel’s data refresh option